Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am having trouble with the external data function in Excel. Going
to morningstar.com and typing in tickers one by one and writing down the market cap type can be very tedious. Instead, I would like to create a table in Excel to pull this data for me. Rather than pull an entire stock quote based on the ticker entered into the dialog box (this example is provided in Excel), I'd like to type a list of multiple tickers into a column in Excel and have a web query return the Morningstar style box type into the cell to the right of my list of tickers. Is it possible to only pull this one phrase "Large Value" rather than the entire table from the following site? http://quicktake.morningstar.com/Sto...tab=snapsho t How could I create such a task? Thank you ahead of time for your help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel Inport External Data - new queries | Excel Worksheet Functions | |||
Excel 2002 External Data Queries and UNC !HELP! | Excel Discussion (Misc queries) | |||
External Data Queries - Data Range Properties v Spreadsheet Format | Excel Discussion (Misc queries) | |||
Internet Queries | Excel Discussion (Misc queries) | |||
Excel 2003 This Workbook contains queries to external data | Excel Discussion (Misc queries) |