How do you plug a real time stock price into a Microsoft Excel worksheet?
I have my stocks listed in the excel program but I don’t like updating them by hand. I would rather enter a formula so that the worksheet gets updated automatically. Is there anyway to do that?
This can be done by linking to an external data source. The link below offers step by step advice on how to link it to Yahoo’s Finance site.
http://www.ehow.com/how_2027266_stock-prices-excel.html
It doesn’t mention that you can have it auto update every 1 minute by right click the data selecting data range properties and editing the refresh control.
Using that method the quickest it can refresh is every 1 minute. If you need it quicker than that you can record a macro and the following line of code to the end:
Application.OnTime Now + TimeValue("00:00:01"), "Refresh"
Where Refresh is the name of your Macro
This will refresh every 1 second (change 00:00:00 part for any time in hours minutes and seconds.
August 16th, 2009 at 5:00 am
This can be done by linking to an external data source. The link below offers step by step advice on how to link it to Yahoo’s Finance site.
http://www.ehow.com/how_2027266_stock-prices-excel.html
It doesn’t mention that you can have it auto update every 1 minute by right click the data selecting data range properties and editing the refresh control.
Using that method the quickest it can refresh is every 1 minute. If you need it quicker than that you can record a macro and the following line of code to the end:
Application.OnTime Now + TimeValue("00:00:01"), "Refresh"
Where Refresh is the name of your Macro
This will refresh every 1 second (change 00:00:00 part for any time in hours minutes and seconds.
References :