Usage of StockQuote.MSNStockQuote in excel vba code

S

SM

Hi, any help to resolve the under mentioned issue will be greatly appreciated.

I have an excel sheet with set of stock ( company share ) symbols stored in
a column. Next column is to store the last price and column next to that
would store volume.

I use StockQuote.MSNStockQuote for finding last price ( parameters being
Symbol , "Last Price","US" ) . When I run this in a vba code loop which would
supply stock symbols , function stores #NA on excel .
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA to run all variable combinations in a calculation model and store result 6
Minimum function in a list 5
VBA to create stock analytics display 1
Synthetic Speech in Excel? 2
Share Portfolio - Averaging the Cost per Shareholding 3
Find last date of sold stock and sold price. 2
Sort a range of strings using VBA code? 5
Import Historical Stock Data from Yahoo-Finance 0

Top