comparing todays volume to yesterdays

  • Thread starter Thread starter andrew21
  • Start date Start date
A

andrew21

in A1 is the daily cumulative volume for the NYSE updating ever
second...i would like to take a "snapshot" of this value at the end o
each minute and have that entered into another cell...a market day i
approximately 390 minutes so i guess that would mean a colum
containing 390 cells...then i would like to do the same for th
following day(another column of 390 cells)...then have a ratio formul
divide the most recent minutes data with its corresponding value fro
yesterday..the purpose of course is to see if todays volume is runnin
above or below yesterdays volume and have that info re-calculated ever
minute...also A1 is reset to zero before the market open each day(no
sure if that is relevant)...any and all suggestions are greatl
appreciated..thank
 
You can use an OnTime event macro to capture the data and write the time and
value to, say, columns B and C. If yesterday's data is in E and F, in column D
you could write simply =D2/F2. If the time in B2 doesn't match that in E2,
then you need to lookup the time in column E:

=C2/(VLOOKUP(B2,$E$2:$F$390,2,0)

That will give you a series of ratios in column D. If you only want the last
ratio, maybe this will work:


=INDEX($C$2:$C$390,COUNT($C$2:$C$390))/VLOOKUP(INDEX($B$2:$B$390,COUNT($C$2:$C$390)),$E$2:$F$390,2,0)
 
thanks Myrna..now all i have to do is figure out how to make an On Tim
event macro...i'm pretty new to exce
 
Back
Top