[Trendup_]

I tried to use Excel 2002, but didn’t win, I am completely lost.
Could it be a too old Excel? Did someone find the doc helpful??

[Trendup_]

Back to confirm that Excel02 is not suitable, 2003 is the oldest we can use.
Cheers

[Frank]

Hi Trendup,

I have done a fair bit of further work on this and at times it gets kind of tricky so let me know what you think you would like to see and I can help.

I do think that creating your own dashboard is significantly helpful in terms of organizing complex data into something more manageable.

[Frank]

As a starter, watch and bookmark this video on how Excel calculates time. This is a bit funky but it is not complex and trust me, it is important to understand how Microsoft has decided to convert dates into serial numbers and time into %'s of a day as keeping track of the timestamp of the OpenEcry feed will ensure that your data is correct.

YouTube - How Does Excel Calculate Time?

YouTube - How Does Excel Calculate Time?

(you may have to watch the video 2-3 times before you really get it --- but if you have trouble with this, then excel is probably not for you).

[Frank]

ok,

here is a starter video on one thing you can do when live-linked to Excel that I have found useful. this relates to nuances you pick-up in tape-reading and order flow by having the data organized and presented in a certain way. its very hard to explain the value in this -- you just have to watch it every day and you begin to pick up clues in the price action.

this particular video is about understanding that volume can be better interpreted in context of the time of day that the volume bar is building.

YouTube - OEC volume

YouTube - OEC volume

[Trendup_]

I noticed that the total volume reported in Excel ‘Quotes’ table is different than the Total volume shown under the histogram in the OEC DOM, also when I add the lastVol in Excel ‘Quotes’ I can see that the result is different than the increment in TotalVol, It looks like I don’t get the full numbers of transactions in LastVol.
The lastVol must be a snpashot only?

[Frank]

hmm, I don't use the quotes table.

I use these types of codes:

For 5-min Volume:

=ACCTNAME|bars!ESU9?5?Vol ume?0


For the Time-Stamp of a 5-min bar

=ACCTNAME|bars!ESU9?5?Tim e?0
(note that my Ecry has screwy time stamp that is 7 hours ahead of my time -- but you can do a formula in the next cell referring to that cell such as

=A6-(TIME(7,0,0))

that adjusts it 7 hours to make it local to my time --
and then format the cell for date and time.)


For 1-Min Volume:

=ACCTNAME|bars!ESU9?1?Vol ume?0

etc....