| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pull stock price from web, format in Excel 2000
I am using Microsoft Excel 2000 with Windows XP.
I would like to take stock prices from Yahoo! Finance and multiply the current price by the number of shares I currently own. Here is an example of a stock I would like to track. http://finance.yahoo.com/q?s=yum It looks like the number is always to the right of "Last Trade". Any idea how to do the code? Thank you in advance for your help. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Pull stock price from web, format in Excel 2000
goto
http://groups.yahoo.com/group/xltraders/ join look for donaldb36 as author and download a free file to do it all for you. There are other files that will also be of use Don Guillett Microsoft MVP Excel SalesAid Software wrote in message ups.com... I am using Microsoft Excel 2000 with Windows XP. I would like to take stock prices from Yahoo! Finance and multiply the current price by the number of shares I currently own. Here is an example of a stock I would like to track. http://finance.yahoo.com/q?s=yum It looks like the number is always to the right of "Last Trade". Any idea how to do the code? Thank you in advance for your help. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel doesn't recognize stock symbol and won't update price | New Users to Excel | |||
| Stock Quote and Last Price in Excel 2007 | Excel Discussion (Misc queries) | |||
| How do I embed stock price link in Excel that updates regularly? | Excel Programming | |||
| How do I calculate the change in stock price in excel. | Excel Discussion (Misc queries) | |||
| Automatically changing stock tick quotes to decimal-price format. | Excel Worksheet Functions | |||
Linear Mode
