DoughRoller receives compensation from some companies issuing financial products, like credit cards and bank accounts, that appear on this site. Unless a post is clearly marked "Sponsored", however, products mentioned in editorial articles and reviews are based on the author's subjective assessment of their value to readers, not compensation. Compensation may impact how and where products appear on non-editorial pages e. That said, our standard is that we will never accept advertising from a product which we wouldn't use ourselves.

There are a lot of tools out there to track your investments. One of my favorites is Personal Capital. It offers a free online financial dashboard that automatically tracks your investments and your spending. I have to give a BIG thank you to a reader named Dan. He built this spreadsheet and shared it with me weeks ago. To start, you can see the spreadsheet by clicking here.

It is build in Google Sheets. But it will give you a clear picture on how it works. The workbook has just two sheets.

Stock Connector

The first sheet lists all of your holdings click image to enlarge:. The Rick Ferri and Personal Capital allocations are there just for ideas. The spreadsheet calculates how much you have in each asset class based on column D of the first page of the workbook. If you want to add or change asset classes, you can. Just remember to add them in column D of page one and then add a row for each new class on this page.

I use both this spreadsheet AND Personal Capital to track my investments. Personal Capital is excellent for tracking investment fees, asset allocation, and even my monthly budget.

Visit Personal Capital to Get Started. One of the cool features of this spreadsheet is the rebalancing function. This simply calculates the actual amount of investments you have in each asset class. This data comes from the Holdings page of the spreadsheet. This column calculates the difference between your target allocation by class and your actual allocation. Note that some of the cells in this column are in red.

This column allows you to set a threshold for each asset class. In other words, how much can your actual investments drift from your target allocation before you need to rebalance. Once your actual allocation drifts from your target by the threshold percentage, the difference in the Diff column turns red. Play in new window Download Embed. Our Day Money Challenge will help you get out of debt, save more, and take back control of your life.

You'll also get instant access to my interview of a husband and father who retired at the ripe old age of. What others are saying: I'm at Day 26 in your 31 day money challenge podcast. Thank you, thank you, thank you! I've been looking for a comprehensive guide to all-things-money and this has been so informative.

Jon, you certainly can add individual stocks to the spreadsheet. I do that for my portfolio. You can of course add anything manually. One of the ETFs I own is iShares emerging markets ETF, XEC. When I enter that symbol, Google Finance recognizes that as Cimarex Energy Co. I can manually change the price to that of iShares emerging markets ETF, but would you know how I could correct that? I guess there is no easy way around that. The only thing I know to do is enter and update it manually.

Better yet, code the string so that it looks within a user-input cell containing the currency one prefers. That way it is more universal. The currency exchange rate function could also be used as a field for each investment if one wants to track impact of exchange rates for foreign investments purchased in native currency. You can try using the importhtml function in google sheets to import ducky from Morningstar or yahoo finance.

I added YTD return to mine using google finance feature. Just curious how you got this to work…….. I just keep getting loading data error. Checked with Google Finance help and it seems to be an issue…. What am I doing wrong? Same problem for me. Seems to act a little strange when adding lines, copying formulas, etc. Both are spreadsheet programs but built on different codes. I dont understand the Yahoo Finance part you mentioned Justin.

So if you want to use Excel instead, you need to define the function to tell Excel where to look and what data to pull. I mentioned Yahoo because people tend to have better luck pulling their data rather than google. If you look it up, there are plenty of add-ins that will cost you because someone has done the work to script it. You might be lucky and find someone who has generously posted their work.

This link might work: So, if you have a fund that has multiple asset classes, like many do, what would you say is the best way to manage that? Do you have to enter multiple lines for that fund and divvy out the percentage of shares for each line based on the percentages of each asset class within the fund? As the spreadsheet currently works, you would have to create multiple lines for the same investment.

Hey Rob… This is Dan yes that Dan. This is an issue I also brought up to you in a couple different emails now. I have a solution already done for this, I was just looking for a good source for this data. If possible, would someone mind sharing the method for breaking down managed funds, e. You provided a good template that anyone can modify to their liking. The syntax might differ slightly from the more popular MS Excel but documentation regarding google spreadsheet is robust.

This spreadsheet is FANTASTIC once set up. Thus, I need to manually update with Shares and Price. These funds are automatically updated on the Vanguard site as Outside Investments.

The Vanguard site is able to log into Fidelity and COPERA and refresh the data to current. Rob — THANKS for a great show and the continued wonderful advice……………Mike. You can only track investments with ticker symbols. If you can decompose funds, you can track them in google finance.

PeraAdvantage SRI Fund is 60 NSRIX, 40 OGGAX. Some COPERA funds unfortunately are actively managed and thus opaque. I thought about decomposing, but it gets fairly complex. First, determine a proxy for each fund in your k. Then, get the closing prices for both your fund and the proxy to create a conversion e. Add a column to the spreadsheet for this conversion factor. Enter your proxy in the Symbol column.

Lastly, modify the Value column to multiply the existing formula by the new conversion factor column. Then add a column with that conversion ratio, and use your proxy in the ticker column. Modify the value column to include the conversion in the calculation.

Can I change the categories of the assets classes? I found out how to change categories of asset classes by listening to the podcast on the spreadsheet. Click on a cell in the Category column. You can change them there. Thanks to all who have improved the spreadsheet and shared their tips here.

Sorry if it takes some time to see your comments once you post them. If you are a first time commenter, I have to manually approve the comment. This is not working. I want US Bonds and International Bonds. The spreadsheet seems to require permission to access. I sent a request for access — thanks in advance.

Rob, for some reason the spreadsheet for me is now in View Only mode when I download it. It is now protected and requires you give permission in order to make a copy. This seems very strange. I am logged on to my google account when I download the speadsheet. Thank you for making this available — for a spreadsheet newbie, this one looks workable for my passive index etf portfolio. Rob, I feel like complete dunce. Sorry for the confusion and again thanks for the resource. Thank you so much for doing this.

A11, it makes it easier for people to add their own asset classes. Any way another tab for stock option trades could be added. Maybe others have a spreadsheet they use for option trades. Great spreadsheet except one issue: Can you provide the code for including the stocks tab? How do you add lines that are formatted to make more entries?

I just added rows, but then none of the formatting is done on those rows. Is it limited to just 20 entries? Thanks for your help. Hi Stephanie, and thanks for your help! That worked for the most part. Also, the pulldown menu under Category only works thru line After that I just entered it myself. But I hesitate to keep adding data if this is not formatted correctly. I think there are still other problems too.

I added two asset classes under Category: I use them in the appropriate cells, but I notice they do not transfer to the Asset Class page. Anyway, I really appreciate your help.

I am working entirely in Google drive and the price info is being drawn from Google Finance as it should. Peter — just wondering if you ever solved your problem? Please let me know if you figured out a work around. Never mind, I figured it out! Where are these things saved? If so, try looking in your Google Drive drive.

This helped me find it. Their menu is awful, it should say where the documents are. But thanks you saved the day for me twice! Has anyone figured out how to get the I and K columns to work? I was able to copy the formula for everything else. The spreadsheet is fantastic! I was able to make ETFs work, Canadian mutual funds and Canadian stocks. All you need to do is add the ticker symbol exactly as Google Finance has it. As a suggestion, it would be great to take currency conversion into account.

Thank you so much for publishing this!

How do you save your changes? I try but when I reload the spreadsheet is is as original. You should be able to save it to your computer as a copy, which you can then edit with your own tracked info! Could someone please give a detailed explanation of the steps I need to take to resolve this? Thank you for the spreadsheet. I was looking for something to help my parents view their holdings and figured it would be Excel based, but the googlefinance formula is too easy too resist. Thanks for the spreadsheet.

Simple Stock Portfolio Management, by Excel | Guidance Blog

I am not used to using these and can not figure out a way to add rows that function. To me the real value is seeing the changes over time. I copied the By Asset Class to a new sheet and then just pasted values into column H instead of formulas.

Maybe then just add a column for Current Values each time I update? Next quarter Column I will be the latest and greatest amounts? Thanks for any suggestions. Click here to cancel reply. Email will not be published required. This site may be compensated in exchange for featured placement of certain sponsored products and services, or your clicking on links posted on this website.

The credit card offers that appear on this site are from credit card companies from which doughroller. This compensation may impact how and where products appear on this site including, for example, the order in which they appear.

This content is not provided or commissioned by the bank, credit card issuer, or other advertiser. Opinions expressed here are author's alone, not those of the bank, credit card issuer, or other advertiser, and have not been reviewed, approved or otherwise endorsed by the advertiser. This site may be compensated through the bank, credit card issuer, or other advertiser Affiliate Program. The content on this site is for informational and educational purposes only and should not be construed as professional financial advice.

Should you need such advice, consult a licensed financial or tax advisor. References to products, offers, and rates from third party sites often change. While we do our best to keep these updated, numbers stated on our site may differ from actual numbers. User Generated Content Disclaimer: The comments below each article are not provided or commissioned by the bank advertiser.

Responses have not been reviewed, approved or otherwise endorsed by the bank advertiser. You can explore the site through our archives dating back to An Awesome and Free Investment Tracking Spreadsheet. The Spreadsheet To start, you can see the spreadsheet by clicking here. The first sheet lists all of your holdings click image to enlarge: Take the Day Money Challenge Our Day Money Challenge will help you get out of debt, save more, and take back control of your life. Start the day money challenge!

We hate spam as much as you do. Jon May 24, May 24, at 3: Rob Berger May 24, May 24, at 8: Grant May 24, Justin May 25, May 25, at 1: Mihir May 25, Mark Church May 25, May 25, at 7: Rob Berger May 25, May 25, at 8: Mike May 27, May 27, at Mike May 30, May 30, at 9: Grant May 25, May 25, at Mike May 26, May 26, at 3: Justin May 27, May 27, at 2: Neo May 27, May 27, at 8: Justin May 28, May 28, at 3: Brett May 26, May 26, at Rob Berger May 26, Dan June 2, June 2, at 2: Ben July 29, July 29, at TheRetirementManifesto May 28, May 28, at Mike May 28, May 28, at 5: Richard May 28, May 28, at 7: Ryan May 28, Matt May 29, May 29, at 8: Matt June 4, June 4, at 6: Rob Berger May 30, Steve June 7, June 7, at 1: Greg June 23, June 23, at 4: Evelyn October 24, October 24, at 8: Rob Berger October 24, October 24, at 4: Evelyn October 25, October 25, at Evelyn October 27, October 27, at 7: Christian February 25, February 25, at 2: Rob Berger February 26, February 26, at 5: BruceT March 2, March 2, at 9: Chad May 18, May 18, at 1: Peter July 11, July 11, at Stephanie Colestock July 12, July 12, at 2: Peter July 12, July 12, at Jordana January 18, January 18, at Jordana January 19, January 19, at Kyla October 18, October 18, at 8: Aji October 19, October 19, at 9: Rob Berger October 20, October 20, at 9: Cris January 5, January 5, at 6: Paul D January 17, January 17, at 2: Stephanie Colestock January 18, January 18, at 9: Mark January 25, January 25, at 5: Rick February 15, February 15, at Jeff April 2, April 2, at 7: Clay April 12, April 12, at Alex Kistler April 14, April 14, at J John Lynch May 28, May 28, at 8: Take Control of Your Money Join over 23, who get our free weekly newsletter.

Get our free weekly newsletter packed with Links to our latest articles Money saving tips Tools, resources, and guides to improve your finances. We respect your privacy. Bank Rates Best Interest Rates --June Best Online Banks Best CD Rates Bank Account Promotions, Deals and Bonuses Today's Mortgage Rates.

Credit Card Rewards Best Credit Cards of Best Balance Transfer Cards Best Cash Back Credit Cards Best Travel Rewards Cards Best Business Credit Cards Today's Credit Card Bonuses Best Credit Cards for Poor Credit Free Prepaid Debit Cards. Money Toolbox Free Financial Dashboard Best Online Brokers Best Robo Advisors Free Credit Score Reports Best Tax Software.

Podcast Insurance Taxes Retirement Personal Finance.