Questions about the opening price...

[Doji3333]

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

[dloomis]

Well, I show 15.51 for the open.

[dloomis]

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.

[Doji3333]

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

[dloomis]

how about something like

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

[Doji3333]

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

[dloomis]

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");
}

[Doji3333]

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

[dloomis]

INTC 15.07
IBM 77.10
QLGC 33.17
AOL 10.68

all at 930 am est per my adv chart

[ACM]

Brad
Same values as David's.
Alex

[Doji3333]

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..

[dloomis]

my numbers WERE from a 5 min chart

[Doji3333]

Check Daily Charts...

David,

Check your Daily charts...

B

[dloomis]

Sure, if you say please....


all the same, btw, on the daily charts

[ACM]

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