J
jrathman
I'm fairly new to using Excel for financial modeling, but recentl
figured out how to pull graphs from the internet and have them updat
periodically (Excel asks you to choose a number of minutes betwee
updates).
However, I really don't want the web query to update, I want it to sav
the chart each day (automatically instead of manually) in a ne
worksheet so I can go back and develop a page that will chart changes.
If it helps to visualize, I'm pulling a currency chart fro
Bloomberg.com, but they only list the day's movements. I'd like to hav
it save each day at market close so I can begin to see currenc
trends/movements.
Thank you for taking the time to read this
figured out how to pull graphs from the internet and have them updat
periodically (Excel asks you to choose a number of minutes betwee
updates).
However, I really don't want the web query to update, I want it to sav
the chart each day (automatically instead of manually) in a ne
worksheet so I can go back and develop a page that will chart changes.
If it helps to visualize, I'm pulling a currency chart fro
Bloomberg.com, but they only list the day's movements. I'd like to hav
it save each day at market close so I can begin to see currenc
trends/movements.
Thank you for taking the time to read this