Portfolio tracking in Excel

A

akivak

I’m using MSNStockQuote function to get data from MSN Money to Excel. It’s not Real Time, but it’s good enough for me. However, couple of weeks ago it stopped working for most (if not all) ETF options (SPY, GLD etc.). So I checked directly in MSN Money – they don’t have data for those options. I guess it might be related to the new symbols? Does someone know when MSN Money is going to resume the quotes? Any other recommendations how to get quotes (especially options) to Excel?
 
Quote from wa1gon:

What broker are you using. TOS has an real time DDE interface that
Excel can hook into.

-Darryl DE WA1GON
More...
I'm using IB. I know they also have an interface but I wasn't able to use it. If someone can help it would be much appreciated.
 
Can you tell me how you're using MSNStockQuote to obtain option pricing? I couldn't find any documentation on how to get an option quote through this function.

Thanks,
Ray
 
Quote from akivak:

I’m using MSNStockQuote function to get data from MSN Money to Excel. It’s not Real Time, but it’s good enough for me. However, couple of weeks ago it stopped working for most
More...

Can you just use finance.yahoo data instead?
 
Quote from RainmanRam:

Can you tell me how you're using MSNStockQuote to obtain option pricing? I couldn't find any documentation on how to get an option quote through this function.

Thanks,
Ray
More...
MSNStockQuote("MSFT","last")
 
Quote from Rodney King:

Can you just use finance.yahoo data instead?
More...
It doesn't import quotes for options (or maybe I'm doing something wrong?)
 
You must log in or register to reply here.
Back
Top