|
#1
10-27-2006, 08:55 AM
| |||
| |||
 Re: How to track portfolio investments over time? "FranksPlace2" <FranksPlace2[at]gmail.com> wrote in message news:1161870147.766059.304870[at]e3g2000cwe.googlegroups.com... - quote - > I suggest you spend $30 on Quicken or Money. Then you can download
Tom,> stock prices dailey or whenever. > Frank > tom.berkey[at]gmail.com wrote: > > Can anyone provide any info regarding how Google finance can be > > employed to track the investments in a given portfolio as a function of > > time? It seems as if the only means of doing this currently is a manual > > cut and paste operation into an Excel spreadsheet. Before you spend that money look into the Web Query function in Excel. This little-known function allows you to import stock prices directly into a spreadsheet. It's under Tools > Import External Data. A quick Google turns up many tutorials on Web Queries, such as this one: http://tinyurl.com/ygqtbd Also, the Gummy Stuff website has a some Excel files about this tool here: http://www.gummy-stuff.org/portfolio.htm |
|
10-26-2006, 01:42 PM
| |||
| |||
| Re: How to track portfolio investments over time? I suggest you spend $30 on Quicken or Money. Then you can download stock prices dailey or whenever. Frank tom.berkey[at]gmail.com wrote: - quote - > Can anyone provide any info regarding how Google finance can be > employed to track the investments in a given portfolio as a function of > time? It seems as if the only means of doing this currently is a manual > cut and paste operation into an Excel spreadsheet. |
|
#-1
10-23-2006, 08:13 PM
| |||
| |||
| How to track portfolio investments over time? Can anyone provide any info regarding how Google finance can be employed to track the investments in a given portfolio as a function of time? It seems as if the only means of doing this currently is a manual cut and paste operation into an Excel spreadsheet. |
| Tags |
| investments, portfolio, time, track |
Similar Threads | ||||
| Thread | Forum | Replies | Last Post | |
| How to track costs when changing investments within IRA stock acct Frustrated: I have an investment account which is classified as an IRA, but I can use it the same way as a stock market account. However, when I try to track... | Microsoft Money | 7 | 03-08-2007 02:53 PM | |
| How Can I Track Investments by CUSIP Craig: Hello, I have Money 2006 Deluxe and am entering two new investments that are causing me fits. 1) A bond. I have the CUSIP number and I enter... | Microsoft Money | 5 | 01-16-2006 09:08 PM | |
| track ^SPX and add investments to watch ab: Hi, Whenever I try to compare the performance of an investment (stock or fund) with a major index (S&P 500 or DJIA), I get an error saying "You... | Microsoft Money | 8 | 04-04-2005 12:19 AM | |
| Thread Tools | |
| Display Modes | |
| |
Linear Mode
