hip2b2
Board Regular
- Joined
- May 5, 2003
- Messages
- 135
- Office Version
- 2019
- Platform
- Windows
I have a list of ~>400 stock tickers (changing every day) that I want to determine (20 min delayed) stock price, volume, and a few other variables.
The MSN Money Stock Quotes Add-in works, but is limited to number of tickers that will be updated. I've found I have to copy small number of ticker symbols, hit update button, copy results, paste values to a second sheet, copy new partial ticker list, paste, wait for update button to time out, etc, etc, etc....
Is there any FREE program that will do what I want, or a VBA routine someone can guide me through to link to Yahoo's free financials, or something similar.
Please help
The MSN Money Stock Quotes Add-in works, but is limited to number of tickers that will be updated. I've found I have to copy small number of ticker symbols, hit update button, copy results, paste values to a second sheet, copy new partial ticker list, paste, wait for update button to time out, etc, etc, etc....
Is there any FREE program that will do what I want, or a VBA routine someone can guide me through to link to Yahoo's free financials, or something similar.
Please help
