Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Does anyone know the correct "format" for the stock symbol to download stock
quotes for preferred shares from the Toronto Stock Exchange. Note that getting quotes for common shares is fine; no problem. Here's an example ... Canadian Imperial Bank of Commerce Preferred D is commonly listed as ... cm.pr.d or cm-d. The former gets me the name but no stock info. The latter "sometimes" gets me the price, but most often will not. It is getting very frustrating to manually update 20 stocks every day. FWIW I'm using Excel 2007 and Vista Premium. Note that everything worked OK until a few months ago, so I don't think it is an Excel or Vista problem. I think I really just need to know the format for symbols for preferred shares. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
stock quote help, VLOOKUP or what?? | Excel Worksheet Functions | |||
stock quote addin | Excel Discussion (Misc queries) | |||
stock quote add in | Excel Discussion (Misc queries) | |||
MSN MoneyCentral Stock Quote Add In | Setting up and Configuration of Excel | |||
How do I get a refreshable stock quote for S | Excel Discussion (Misc queries) |