Portfolio tracking in Excel

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?

 

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

-Darryl DE WA1GON

 

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

 

Can you just use finance.yahoo data instead?

 

Hoadley options addin is like $79 or something like that and it'll do all you want and then some.

 

MSNStockQuote("MSFT","last")

 

It doesn't import quotes for options (or maybe I'm doing something wrong?)

 

See http://www.elitetrader.com/vb/showthread.php?threadid=57533 & other threads

 

That'll get me the underlying, not options.