Announcement

Collapse
No announcement yet.

Questions about the opening price...

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Questions about the opening price...

    Hello all.

    I have been working with a client regarding a custom indicator that needs to pull the correct opening price for the day and calculate based on this price. The problem we are exeriencing is in regards to the reporting of an accurate opening price.

    The clients Excel SS reports the open for INTC on 2/6 @ 15.49

    My esignal reports it @ 15.54

    The SS is using a DDE link to esignal. The client is on Central Time and I am in CA.

    Can anyone at eSignal please describe the issue we can't figure out??? Solution please??

    Thanks in advance.

    Brad
    Brad Matheny
    eSignal Solution Provider since 2000

  • #2
    Well, I show 15.51 for the open.
    Attached Files

    Comment


    • #3
      and my Time&Sales for INTC shows... 15.51


      I bet the DDE link is picking up the first tick change after 9:30 which appears to be 15.49, or maybe the second trade is getting picked up, not the first.
      Attached Files

      Comment


      • #4
        Daily Open Price....

        There has to be a way to get the DAILY opening price of a chart from within a 1 minute or x minute chart...

        Right now the only way it to count the date and time to pull the values...

        Brad
        Brad Matheny
        eSignal Solution Provider since 2000

        Comment


        • #5
          how about something like

          if(timeH==9 && timeMin>29 && 1stTick==0)
          1stTick=close();

          Comment


          • #6
            opening price...

            David,

            That is basically what I did, but I wanted to get the open of two different symbols and run my analysis on the two opens.

            Basically, I believe there should be functions to retrieve the open,high,low and close DAILY price from within the EFS.

            Maybe something like...

            GetPrice([Interval],[Price],[Date], [Symbol]);

            This would allow us to pull any price we need with complete certainty - rather than writing a bunch of code to accomplish this..

            Brad
            Brad Matheny
            eSignal Solution Provider since 2000

            Comment


            • #7
              Have you seen this EFS? TodaysOpen under Formulas, OHLC

              /************************************************** **************************************************
              Copyright © eSignal, a division of Interactive Data Corporation. 2002. All rights reserved.
              This sample eSignal Formula Script (EFS) may be modified and saved under a new
              filename; however, eSignal is no longer responsible for the functionality once modified.
              eSignal reserves the right to modify and overwrite this EFS file with each new release.
              ************************************************** ************************************************** */
              function preMain() {
              setPriceStudy(true);
              setStudyTitle("Today's Open (TO)");
              setCursorLabelName("TO");

              /*
              * Set the properties of the default bar. These will be the
              * properties of any bar for which style, color, thickness is
              * not specificed.
              */
              setDefaultBarStyle(PS_DASH);
              setDefaultBarFgColor(Color.blue);
              setDefaultBarThickness(1);
              setPlotType(PLOTTYPE_FLATLINES);

              }

              /*
              * This is a neat formula because it is working on multiple intervals
              */
              function main() {
              return call("getTodayOHLC.efs", "Open");
              }

              Comment


              • #8
                Function error....

                David,

                Based on my testing of a similar function within my code, the example you have given is dependant on the "Time Template" that you are using. For example, if you are bringing in pre-market data into your chart, this function will return the OPEN of the first bar for the new day.

                Obviously, the open of a bar at 3AM is not the actual open of the DAILY chart. I have tested this with variant time frames and the results are always the same. It returns the first bar of the new day (getFirstBarIndexOfDay) - just like it says in the function name. This can be any errant pre-market bar - not the actual Daily Opening price.

                The way I've resolved this is to create HOUR and MINUTE conditions for my client that force them to select the exact time of the opening bar. This, then, returns an approximate open.

                Let's run a little test after market today. I would like to ask everyone to report the opening price (for today) for the following symbols. My client report that the opening price is different on my machine and theirs (both running esignal). I would like to see if this is true...

                INTC
                IBM
                QLGC
                AOL

                Thanks. Hoping to get an answer to a better solution soon...

                Brad
                Brad Matheny
                eSignal Solution Provider since 2000

                Comment


                • #9
                  INTC 15.07
                  IBM 77.10
                  QLGC 33.17
                  AOL 10.68

                  all at 930 am est per my adv chart

                  Comment


                  • #10
                    Brad
                    Same values as David's.
                    Alex
                    Last edited by ACM; 02-10-2003, 12:07 PM.

                    Comment


                    • #11
                      My Opens...

                      Here they are...

                      INTC 15.07
                      IBM 77.10
                      QLGC 33.17
                      AOL 10.63

                      These were all off the daily charts...

                      Now, if I pull the opening price on a 5 minute chart (@ 6:30 AM) in my case, here are the numbers...

                      INTC 15.121 - different.
                      IBM 77.10 - same
                      QLGC 33.17 - same
                      AOL 10.63 - same

                      The issue I am running into is not on the Daily charts... it is pulling Daily data from an intra-day chart.

                      Please see if your numbers a approx 6:30 AM PST are similar - adjust time accordingly.

                      Thanks..
                      Brad Matheny
                      eSignal Solution Provider since 2000

                      Comment


                      • #12
                        my numbers WERE from a 5 min chart

                        Comment


                        • #13
                          Check Daily Charts...

                          David,

                          Check your Daily charts...

                          B
                          Brad Matheny
                          eSignal Solution Provider since 2000

                          Comment


                          • #14
                            Sure, if you say please....


                            all the same, btw, on the daily charts

                            Comment


                            • #15
                              Brad
                              The numbers I said in a previous message were the same as David's were off the Daily charts.
                              Just ran the same on 5 min chart and come up with the same values as on Daily.
                              Using 9:30-16:00 Time Template
                              Alex

                              Comment

                              Working...
                              X