Req: How to import rates for tickers (financial)?
Hi,
I wonder if it's possible to automatickly import the latest rate for a share by clicking an "update" button in excel. (open, high, low, volume...)
After clicking I would like the worksheet to contain all values from the last time I updated to the present day. None of the previous rates (for past days) are to be deleted. I would like to do this in order to make a graph for the historical rates.
The ticker I'm going to use is YAR (Yara International)
Thanks in advance.
Hi Cantog. You probably want to read up on using the DATA > IMPORT EXTERNAL DATA > WEB QUERY.
_________________
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!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks