LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
sm sm is offline
external usenet poster
 
Posts: 13
Default Usage of StockQuote.MSNStockQuote in excel vba code

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 .

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
MSN StockQuote SPA Setting up and Configuration of Excel 0 April 13th 10 01:35 PM
How do I get the MSNStockQuote function in Excel? arrvin Excel Worksheet Functions 1 February 11th 10 10:39 PM
Code Usage Question Rob Excel Programming 2 September 13th 06 08:20 PM
Using Msnstockquote from excel VBA gary Excel Programming 0 July 4th 06 03:03 PM
Usage of SUMIF formula in the VBA code GreenInIowa Excel Programming 2 November 1st 05 09:36 PM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"