Help needed : macros to start and stop auto update every minute.

[chaitreya]

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 ?

[jaslake]

Hi chaitreya

Place this Code in a General Module

Please Login or Register  to view this content.

Place this Code in ThisWorkbook Mudule

Please Login or Register  to view this content.

Assign StartTimer to the Auto Update Button

Assign StopTimer to the Stop Auto Update Button.

[chaitreya]

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.

[chaitreya]

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.

[jaslake]

Hi chaitreya

Of course...add the indicated line of Code to Sub GetRTData()

Please Login or Register  to view this content.

[chaitreya]

Thanks a lot.

Its worked perfectly !!!

[jaslake]

You're welcome...glad I could help. Thanks for the Rep.