Hi Guys,
I'm not sure if this is possible but am hoping some wizard knows of a way to do this....
Basically I want to use Excel to construct my own Market Profile figures on foreign exchange instruments.. This means that I want to time the length of time throughout the day that the price of an instrument is at that price level...
More explanation...
My spreadsheet takes a feed for say AUDUSD through DDE and updates at every price change (Tick). So every second the feed could change a number of times... for simplicity
1.0391
1.0390
1.0391
1.0392
1.0391
1.0392
1.0391
1.0390
....
....
Etc...
I have the feed coming in at cell B1 then I have a range of prices in Column A (A5 to A500) i.e
A B
1.0396 <-----feed
1.0400
1.0399
1.0398
1.0397
1.0396 <------ This Row is highlighted Blue
1.0395
1.0394
1.0393
...
...
I have set up conditional formatting so that as the feed changes the highlighted row changes giving visual representation of current price.
All good so far... Now what i would like to do is place a timer in column C that starts counting up in seconds every time price is at that level, then stops if the price changes and then if the price comes back to that level then it picks up where it left off.
Like I said not sure if this is possible but ultimately i would like each price to have a timer so i can look at a glance to see how much time has been spent at each price level that day.
Any guidance or tips to point me in the right direction would be greatly appreciated.
Thanks
PP
Bookmarks