Track Real Time Changes In The Stock Market
"With Microsoft Excel and Internet access you can track real time changes in the stock market" we were told on a recent seminar for Financial Analysts.
The result of this daring statement was that nobody got it to work.
Some Excel Guru on the team said "The Change Event does not capture everything. I have grappled with this myself on several occasions, sometimes having to resort to putting the new data alongside the old, comparing the two (and taking any action I want if there are changes) then making the new data the old data . . . etc. It may depend mainly by the way you are importing the data".
I import via Excel's from Web which works fine but does not allow me to do any data tracking like writing the new values to the next cell of the next column.
Does anybody know of a workaround or something?