LinkBack URL
About LinkBacks
The enclosed sample excel gets real time intra-day quotes from google finance.
I wish to add two macros so as to 1. start getting quotes automatically every 60 sec (1 min), 2. Stop auto-update.
Can anyone help please ?
Help needed : macros to start and stop auto update every minute.
The enclosed sample excel gets real time intra-day quotes from google finance.
I wish to add two macros so as to 1. start getting quotes automatically every 60 sec (1 min), 2. Stop auto-update.
Can anyone help please ?
Hi chaitreya
Place this Code in a General ModulePlace this Code in ThisWorkbook Mudule
Please Login or Register to view this content.Assign StartTimer to the Auto Update ButtonPlease Login or Register to view this content.
Assign StopTimer to the Stop Auto Update Button.
John
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
Thanks a lot.
Today I am unable to check the working of this code as stock markets are closed. I will check on Monday after markets open.
I am very sorry to say, it's not working.
After starting 'StartTimer', it updates the quotes only once but fails to Auto Update every min thereafter.
Hi chaitreya
Of course...add the indicated line of Code to Sub GetRTData()
Please Login or Register to view this content.
Thanks a lot.
Its worked perfectly !!!
You're welcome...glad I could help. Thanks for the Rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks