Suppose in cell C1 is the price and D1 is the volume of a certain scrip.
Every time the price goes up( ie C1>OLDC1), in cell B1 we add 1. Concurrently in the cell A1 we add the Volume( D1-Prev D1)
Every time the price goes down( ie C1<OLDValueC1), in cell B1 we add -1. Concurrently in the cell A1 we add the Volume( D1-Prev D1) in a negative value=-(D1-OLDValueD1)
How can we write this for 2 pairs ?
It will be so kind of any one to help me out.
C1 and D1 have formula in them?
This would have to be a "calculate" event in the sheet itself. Something like this:
Please Login or Register to view this content.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Thanks .. I have not tried because I dont have a live feed now....
Will this work if the Data stream in C1 and D1 is live (or result of a formulae from live feed ) ?
You have a beautifull LOGO.. very attractive.. How did you make IT ?
I used an online GIF generator and paint program on my computer.
The macro is based on the "calculation" event occurring within your sheet. You'll have to test whether it's triggered by your feeds or not.
Thanks a lot !
If that takes care of your original query, please select Thread Tools from the menu above and mark the thread as solved. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks