ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Retrieving stock data (https://www.excelbanter.com/excel-discussion-misc-queries/50608-retrieving-stock-data.html)

Larry Wade

Retrieving stock data
 
In Excel97 I have been using "Multiple Price Quotes by PC Quote, Inc.iqy" to
retrieve stock prices. It has stopped working. I have now tried "Microsoft
Investor Stock Quotes.iqy". This works except the Microsoft one returns
only the stock name while the PC Quote one used to return the stock name and
symbol. I need the retrieval to return the symbol because I do a lookup
(using OFFSET) based on the symbol. Is there another iqy file I should be
using? Any ideas?



Don Guillett

See my answer to the question you asked in the yahoo xltraders group

--
Don Guillett
SalesAid Software

"Larry Wade" wrote in message
...
In Excel97 I have been using "Multiple Price Quotes by PC Quote, Inc.iqy"

to
retrieve stock prices. It has stopped working. I have now tried

"Microsoft
Investor Stock Quotes.iqy". This works except the Microsoft one returns
only the stock name while the PC Quote one used to return the stock name

and
symbol. I need the retrieval to return the symbol because I do a lookup
(using OFFSET) based on the symbol. Is there another iqy file I should be
using? Any ideas?






All times are GMT +1. The time now is 08:43 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com