smart tags and stock updates
I use smart tags in excel to track my stocks. Before using smart tages, I
used to bring in data using yahoo. But smart tags pulls their quotes from MSN Money, which is fine by me. The problem is I have many many spreadsheets, and MSN Money lets me refresh the quotes every five minutes. Great if it is all on one worksheet. Not great if you use many many worksheets. I tried tying the multiple worksheets together into one master worksheet, with all the info carried over form the first sheet to the larger one, but found they would not update the latest prices, unless the "smart tag" stocks were updated everywhere. Which means I've gotta hit "update quotes" and then wait 4:57 seconds until I can proceed to the next sheet! Is there some "master switch" I can throw to get all stocks in every worksheet updated, even if it's once/day, say at 6 pm or 9 am, or anytime? Thanks in advance. Switching to yahoo quotes is not an option. I have 200 worksheets. Yup, 200. |
All times are GMT +1. The time now is 07:03 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com