Forum Discussion
Community Question - How have you been using the new Stocks and Geography Data Types?
Excel has been a fabulous tool for stock analysis and I really appreciate the Data>Stock feature. I am just new and exploring. The properties for auto updating stock information is not active. I have to manually refresh the data connection. Maybe I am missing something , kindly guide me.
- Hi Utpaal,
You are correct that you are only able to update the values manually via Data > Refersh at this time. However you can write a macro to refresh automatically using the existing RefreshAll command.
If we were to add an ability to refresh automatically in the future, can you share how you would like it to work? Some things to consider would be the interval at which we refresh and how you would like to switch back to manual refresh, and whether that needs to apply to everything or just some stocks.
Thanks for your feedback!
JamesHello James , The stock prices are required to be refreshed manually and understand I can auto refresh thru connection properties and also able to select time interval. However , the properties in data is not active.
I read the following in Help ..
((Refresh every n minutes Select this check box to enable automatic external data refresh at regular
time intervals, and then enter the number of minutes between each refresh operation. Clear this check
box to disable automatic external data refresh.))However , the properties link is inactive.AutoRefresh issue
- Hello James Spotanski,I have been using excel for stock analysis since many years. Unfortunately I use i3 Intel processor and required to open 25 excel files simultaneously and use macros to update EOD data of individual file from an excel dashboard file and return the updated results back to the dashboard file. This process is smooth in office 2007, but did not work well with office 365. I need a better processor. So for temporarily , I have exited using office 365.I have been using google spreadsheet for live trading decisions, but recently found issue with stock price updations. For sometime that I used office 365, I found the Stock data types very useful. I think, the user should have an option to update prices at a certain interval and the refresh needs to be automatic. There should be a selection for data updation interval like 2 min, 5 min, real time and so on...I would combine my analysis with latest stock prices and accordingly trade with help of excel. I can only speak for stock feature and cannot comment on other data type.ThanksUtpaal
