M
macutan
Hi All,
I have been lately trying (without much success) to get real-time
stock market data into excel. One method of doing it would be by using
a web query in excel to:
https://fastquote.fidelity.com/webxpress/popup_quote.phtml?SID_VALUE_ID=AAPL
And then I select the table where the "last [tick] (or last price) is,
note that the table has more information.
Well as it can be seen these are only delayed quotes and if I login
through the main site: http://www.fidelity.com and then go to that
site, I am able to see real-time prices.
My objective is to be able to get only the real-time price (I do not
wish to bring to excel the rest of the information on the table export
(ie, Change, Bid, Bid Size, etc.. ), at least not in this exercise.
Is there an easy way that I can accomplish this using VBA with web
queries?
Any guidance or information will be greatly appreciated.
Thanks in advance
Paco
I have been lately trying (without much success) to get real-time
stock market data into excel. One method of doing it would be by using
a web query in excel to:
https://fastquote.fidelity.com/webxpress/popup_quote.phtml?SID_VALUE_ID=AAPL
And then I select the table where the "last [tick] (or last price) is,
note that the table has more information.
Well as it can be seen these are only delayed quotes and if I login
through the main site: http://www.fidelity.com and then go to that
site, I am able to see real-time prices.
My objective is to be able to get only the real-time price (I do not
wish to bring to excel the rest of the information on the table export
(ie, Change, Bid, Bid Size, etc.. ), at least not in this exercise.
Is there an easy way that I can accomplish this using VBA with web
queries?
Any guidance or information will be greatly appreciated.
Thanks in advance
Paco