Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to get the quote from yahoo into excel?
Refer to the post in General Excel
Does anyone have any suggestions on how to get the quote from yahoo into excel? The quote is USDHKD=X. Thank for any suggestions Eric |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to get the quote from yahoo into excel?
Eric,
I used page http://finance.yahoo.com/currency/co...submit=Convert Select a cell whwre you want the data and then Data|Import external data|new web query Paste the link above in the address bar and click Go Select the table you want to import by clicking the yellow arrow and it turns into a green tick. Click import. Right click the query and click edit data range to set up refresh frequency. Mike "Eric" wrote: Refer to the post in General Excel Does anyone have any suggestions on how to get the quote from yahoo into excel? The quote is USDHKD=X. Thank for any suggestions Eric |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to get the quote from yahoo into excel?
Hi,
Do the following: 1. On the Data menu, point to Insert External Data, and then click New Web Query. The New query dialog box is displays. 2. Click the Stop icon to stop the default url getting executed. 3. In the Address box, enter this url : http://quote.yahoo.com/ and click the Go button. 4. Click the yellow arrow next to the table you want to import. When you click the yellow arrow it appears as tick mark. Click all those portion of the web page you want to import by clicking the yellow arrow. 5. Click the Import button to return to the import Data dialog box. 6. Specify the cell location where you want the imported data to be displayed. There are two option, whether you want it at the existing location or in a New worksheet. In our case case let assume the cell position is =$E$31 7. Click Ok to return to the active Worksheet. The excel displays the following message "Getting Data..." and the External Data Toolbar is displayed 8. Click the refresh icon to refresh data . Challa Prabhu "Eric" wrote: Refer to the post in General Excel Does anyone have any suggestions on how to get the quote from yahoo into excel? The quote is USDHKD=X. Thank for any suggestions Eric |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to get the quote from yahoo into excel? | Excel Discussion (Misc queries) | |||
How do I email an excel file via yahoo? | Excel Discussion (Misc queries) | |||
How do I to see ¨yahoo! charts¨ on my excel worksheet? | Excel Discussion (Misc queries) | |||
How do I to see ¨yahoo! charts¨ on my excel worksheet? | Excel Discussion (Misc queries) |