Caching a high and low value
Peter, I did a test or two on that principle and the only problem I saw with
it was the starting values of the reporting cells. I believe they might need
to be reset daily to get reliable daily readings.
"Billy Liddel" wrote:
This is a case of the blind leading the blind. I have never done a live
update. But with a portfolio containing one stock. I would create variables
MyHi, and MyLo
Then would need a comparison
If MyHi than StockVal Or _
MyLo < StockVal then
' do nothing
Elseif MyHi < StockVal then
MyHi = StckVal
elseif Mylo StockVal then
MyLo = StockVal
end if
The above code is put into a simple sub.
Assuming that a liveupdate creates a Worksheet_Change event you can call the
macro from there.
If not that you could have a Calculation event to call the macro (The sum of
Stock value)
Someone may have a better solution, but that is where I'd start from.
Regards
Peter
" wrote:
I have a spreadsheet of a stock portfolio that updates in real time
according to performance. I want to be able to create a cell that
will cache the high of the day and the low of the day. I would
certainly assume I have to use macros to do so.
Basically I just have a net place where the net value of the equity
position updates intraday and I want to run the process and begin
caching the high and low for whatever time period.
Can anyone point me in the right direction to get started?
|