Free Online Investment Stock Portfolio Tracker Spreadsheet

Free Online Investment Stock Portfolio Tracker Spreadsheet stockportfoliotracker

What is this Stock Portfolio Tracker in a Nutshell?

The stock portfolio tracker is a FREE Google Spreadsheet hosted at Google that can do the following:

  • Track your stocks, shares or bonds by transactions
  • You can enter Buy, Sell, Stock Splits, Rights Issues (or Cash Calls), Cash Dividends, Stock Dividends, Gift Stocks
  • Show you each of your asset (stocks, bonds) realized returns, unrealized returns, cash dividends received
  • AUTOMATICALLY UPDATES STOCK PRICES. If the shares symbol can be found on Yahoo Finance, chances are you don’t have to key in prices yourself. Every time you login to your spreadsheet on your phone, computer or anywhere, that is very up to date prices automatically.
  • Embed your portfolio in your own website
  • Access your portfolio on your iOS, Android phones via Google Docs App

Update: Would like to Thank Everyone for the support! I created this in 2011 and have received overwhelming responses on how it managed help so many folks who is looking for a sophisticated spreadsheet that you can trust. 

Why do we need another portfolio spreadsheet? Well I have a few criteria and objectives:

As little lock in as possible

I have blogged about in the past that I use Intuit’s Quicken to budget and track monetary stuff. Well that causes money and intuit is not the only provider. Microsoft used to provide MS Money but they have stopped the support for it. Some folks may have concern with going too far with the app and difficult to switch to an alternative if another MS Money happens to their paid app.

Stock Portfolio Tracker do not have this problem because it’s stored as a spreadsheet in Google Docs in the Internet cloud. You can always download the data as an excel xls or xlsx workbook to backup locally or if u intend to port it to another platform.

Manage portfolio based on transactions

Actually I don’t want to do this portfolio tracker. I searched around the net to see if someone came up with this simple excel sheet to track my portfolio this way. I would only need to do little modification.

It turns out that most portfolio trackers track based on one stock and the number of units needs to be calculated ad hoc by the user.

Lets just say that there are quite a few investors that hold stocks for a long time. They want to review their holdings, see how much they have gain or loss, how much income in total.

This kind of portfolio should be constructed based on an aggregation of their buy, sell and div transactions.

With these transaction data, user can then construct different review perspective whether it is return on investment or different portfolio category.

Portfolio access anywhere

One problem with Quicken and local excel spreadsheet is you only can access your portfolio on your computer.

With Google Spreadsheet, your workbook is stored on the Internet. That brings advantages.

  1. You can access your portfolio from any computer with Internet access. Right now, smartphones are powerful enough to power a web browser and it’s HTML and JavaScript pages, which Google Spreadsheet runs on.
  2. It acts as a backup should your laptop or desktop gets trashed.
  3. If you would like to share the viewing and editing of the portfolio with friends, family and associates you can do that with the sharing feature.
  4. If you are a finance blogger you can append these data on your blogs.
    Part of me was thinking: how bad is Google Spreadsheet versus Excel. It turns out that they are generally very similar when it comes to formulas but those that I need they do not provide. Still you can cook up a smashing portfolio with what Google provided and they are constantly improving it.

Instructions: How to get started now to use this spreadsheet

The Google Spreadsheet can be found here [Link to spreadsheet >].

The spreadsheet you see is my portfolio of stocks listed on SGX and NYSE.

  1. To assess this Google Spreadsheet you will need a Google account. [Sign up for Google account >>]
  2. At my Google Spreadsheet page in the link above, go to the top right corner and click the “Sign In” link.
  3. Once you are signed in , make a copy of this document by doing the instructions in the image below.

Free Online Investment Stock Portfolio Tracker Spreadsheet duplicate%20a%20copy

Note: You do not have to click Share and ask for my permission. Just go to File > Make a copy… and you can create a copy for you to get started.

Once you have made a copy you would need to understand a few things.

Version history and notes

Free Online Investment Stock Portfolio Tracker Spreadsheet version%20history
The “Read This First” contains instructions on how you can make use of this spreadsheet.

It also contains notes on amendment that I constantly do to this spreadsheet.


Free Online Investment Stock Portfolio Tracker Spreadsheet legend

Yellow cells – these are cells that user will need to fill in appropriate data input.

Light blue cells – these are cells that will be computed by Stock Portfolio Tracker automatically. Do not fill in your own input here!

Drop down selection – these cells are user inputs but they are fixed values that are derived from “Ref” sheet or other cells.

Define the stocks you want to track

Free Online Investment Stock Portfolio Tracker Spreadsheet stock%20summary

Stocks are defined in the worksheet “Stock Summary“. This is where you define the stock name and symbol. Upon viewing it for the first time, you will see rows of already populated stocks. Those are mine. What you need to do is clear row 3 onwards if you are starting afresh by populating your stocks one by one.

For each row of unique stock, make a copy of row 2, and then enter the stock name, quote [optional], manual price [optional] and expected dividend yield [optional] in “Stock Summary”.

Note: The stock name is used not just in this sheet but also “Transactions”, so whenever you make a name change here do change the corresponding stock transactions tagged to this stock name.

The “Last Price” is determine by which data source is available. For this to work you will need to find out the stock quote of the stock you want to track in Google Finance or Yahoo Finance.

We provide 3 options for updating of current last done stock price.

Free Online Investment Stock Portfolio Tracker Spreadsheet quotes

Should your stock be unsupported by Google Finance, if you specify the stock symbol in Yahoo Finance, Stock Portfolio Tracker will automatically update your stock data with values from Yahoo Finance.

Should your stock belong to exchange supported by Google Finance (e.g. US exchange), entering the quote will enable Google Spreadsheet to automatically update your stock data every time you review your spreadsheet.

Update (28 Apr 2013): As of today, Singapore SGX Stock Exchange is supported. Instead of what is depicted in the picture, look up the symbol in Google Finance. They should be as “SGX:{your stock symbol}”. Read update here.

The difference between Google and Yahoo is that Yahoo supports more decimal places, Google can only go up to 2 decimal places. Yahoo takes last trade price while Google seem to take active trade price. Thus if your stock is halted for long, Google will show price 0, which may not be what you want. The upside for Google is that the data seem to be REAL TIME. So you may be able to make use of it.

If you are unable to get live prices from Google Finance or Yahoo Finance, you will need to update the last done price manually every time you open this spreadsheet to review.

The sequence is to take Yahoo Finance as a priority, then Google, then Manual. If you don’t like that sequence go to Last Price column and change the sequence.

One of the main purpose is to track dividend stocks so there is a column that yield investors can make use of to track for this stock how much yield on cost (yield on your average cost of stock purchase) you expect.

Free Online Investment Stock Portfolio Tracker Spreadsheet category%20dropdown Free Online Investment Stock Portfolio Tracker Spreadsheet ref%20sheet

Notice there is a “category” field, this is a drop down validation whose data is defined in the “Ref” sheet. It is to help an investor better segregate the stocks that he or she is tracking.  The user can change and add more category by going to that column in “Ref” to manage.

Enter your stock transactions as they take place

Free Online Investment Stock Portfolio Tracker Spreadsheet transactions%20sheet

The transactions are managed under the “Transactions” sheet.

Free Online Investment Stock Portfolio Tracker Spreadsheet row2

Note that the most important row is row 2, which is the first transaction row. Each new transaction you create is done by selecting the previous row and dragging it down one row and then amending this new row.

Note: Do Not Delete this Row 2! For your first transaction, amend the yellow cells in this row. Only input values for the yellow cells and the “Type” field.

Stock Portfolio Tracker supports 4 kinds of transaction “Type” currently: “Buy”, “Sell”, “Div” and “Split”. From the drop down select the type you are entering.

For all transactions, enter the date of transaction, select the stock by name and select the type.

For “Buy” transaction, enter the “Transacted Units”, “Transacted Price”, “Fees”. Ensure that the value in “Stock Split Ratio” is 1.0.

For “Sell” transaction, enter the “Transacted Units”, “Transacted Price”, “Fees”. Ensure that the value in “Stock Split Ratio” is 1.0.

For “Div” transaction, enter the “Transacted Units”, “Transacted Price”. Ensure that the value in “Stock Split Ratio” is 1.0 and “Fees” is 0.0.

For “Split” transaction, enter the “Stock Split Ratio”. Ensure that the value in  “Transacted Units” is 0.0, “Transacted Price” is 0.0 and “Fees” is 0.0.

The Stock Split Ratio is calculated as follows:

If it is a 4 to 2, the ratio is 2/4 = 0.5.

If it is a 1 to 5, the ratio is 5/1 = 5.0.

For Rights Issues/Cash Call, Bonus Shares, Dividend Reinvestments, please take a look at the FAQ section below to guide you.

Free Online Investment Stock Portfolio Tracker Spreadsheet drag%20row%20down

Note: At times after you insert one row below the formula will go astray. That can be easily solved by re-propagating the formula again by dragging the light blue cells in row 2 to the rest of the transactions row.

Reviewing your portfolio

Once all the data are entered whenever a transaction is made, reviewing your portfolio is easy.

Aggregate transactions in stock summary view

Free Online Investment Stock Portfolio Tracker Spreadsheet stock%20summary%20review

The “Stock Summary” provides you with an aggregate view of your realize and unrealized gains or losses. You will also be able to see your average cost of current shares for each stock.

If you learn from my formulas you can insert more columns possibly to calculate XIRR or total gains or losses.

Aggregate Stocks in multiple portfolio in Portfolio View

Free Online Investment Stock Portfolio Tracker Spreadsheet portfolio%20summary%20review

The “Portfolio Summary” sheet provides more aggregation. This is an aggregation of “Stock Summary” and “Stock Summary USD”

I did not fully develop this at the time of writing because different investors track different set of information. Should you be comfortable with it you can modify this to make it more powerful.

Dividend Collected, Realised Gains and Losses by Months and Years

We also provide 2 worksheets so that as bloggers you can easily tell your readers how much dividends you collected each month and how much gains or losses you realise.

Free Online Investment Stock Portfolio Tracker Spreadsheet monthly%20aggregate

This is the monthly dividend and realise gains sheet

Free Online Investment Stock Portfolio Tracker Spreadsheet yearly%20aggregate

This aggregates dividends and gains on an annual basis


Q: I created a new stock / asset in stock summary with a valid Yahoo stock quote but the price does not seem to be updating!

Free Online Investment Stock Portfolio Tracker Spreadsheet faq%20 %20troubleshoot%20yahoo%20prices%20not%20updating%204

This happens to be a strange bug that i cannot get rid of and i have to apologize for not being able to solved this. That said, the work around solution is very simple.

The reason the price shows wrongly is because the Stock Portfolio Tracker fails to grab the last price from Yahoo. Follow the instructions below to refresh any new stock added.

This means that every time you add a stock such as Intel that you have not keep track of previously, you do this. Once you are keeping track of it, you do not have to do this.

Free Online Investment Stock Portfolio Tracker Spreadsheet faq%20 %20troubleshoot%20yahoo%20prices%20not%20updating%201

1. Go to the worksheet “Yahoo Data Ref“. This is where the data is retrieved.

2. Click on cell A2.

3. At the top formula bar (fx), click and use Ctrl A on your keyboard to select the whole formula string.

Free Online Investment Stock Portfolio Tracker Spreadsheet faq%20 %20troubleshoot%20yahoo%20prices%20not%20updating%202

4. Use keyboard Ctrl X to cut the whole formula

5. Click on a cell that is out of range like what is shown in the picture above. This should make the rest of the cell computation disappear

Free Online Investment Stock Portfolio Tracker Spreadsheet faq%20 %20troubleshoot%20yahoo%20prices%20not%20updating%203

6. Now click on cell A2 again. Use Ctrl V to put back the formula you cut away just now.

7. Now check your Stock Summary that the last price is updated. On the Yahoo Data Ref, you should also see that the new stock is correctly retrieved.

Q: I am still confuse by the terms use in the headers of each field in each sheet could you make it simpler for me?

  1. Read This First > Basic version history and introduction
  2. Portfolio Summary > You do not need to edit this. This pulls data from the other sheets to show an aggregate portfolio view. Once you get the hang of it you can edit to put more things you want to monitor here
  3. Stock Summary > This is where you will define your stock e.g. General Electric, Macdonalds, Total SA
    1. As in all places, cells in yellow means you need to input things, cells in light blue or colored generally means it is computed by the spreadsheet.
    2. Category > this drop down specifies which category this stock is under. You can increase the drop down in the Ref sheet.
    3. Stock Name > The name of the stock. Note that this will impact the dropdown in the Transactions sheet, and how the stocks transaction tracks back to this stock in this sheet
    4. Google Quote > This is where you will specify your google stock quote. Go to google finance and find the stock quote and enter here e.g. TEF for telefonica, VXX for Vix ETF
    5. Yahoo Quote > Similar to (4) but only this one is the quote from Yahoo. Actually Google and Yahoo’s quote look pretty similar if you look at my sheet!
    6. Manual Price > If for some unfortunate reasons your stock cannot be found on these 2 platform you can enter it manually
    7. Last DPU > For dividend stocks you may want to track the annual dividend payout. Here you can manually enter it.
    8. This is all you need to enter. The rest is auto computed. Note the Last Price use will be in this order: If you enter a Google quote it will use the Google Quote then follow by Yahoo Quote then follow by Manual Quote
  4. Transactions > This is your transactions of the stock in your Stock Summary. You will input buy, sell, div and splits here
    1. As in all places, cells in yellow means you need to input things, cells in light blue or colored generally means it is computed by the spreadsheet.
    2. Date > the date of the transaction
    3. Stock > the name of the stock. select the name of the stock from the drop down. if your stock is not seen here it means that you have not specify it under Stock Summary.
    4. Type > what kind of transaction. currently you can choose the drop down with the following
      1. Buy > an accumulation of that stock
        1. Fill in the amount of stocks you bought under transacted units
        2. Fill in the price you buy under Transacted Price (per unit)
        3. Fill in the commission or fees under Fees
        4. Keep the Stock Split Ratio as 1.0
      2. Sell > a distribution of that stock
        1. You have to do a check to ensure you don’t sell more until your total units left is less than zero. My sheet does not take care of that.
        2. Fill in the amount of stocks you sold under transacted units
        3. Fill in the price you sell under Transacted Price (per unit)
        4. Fill in the commission or fees under Fees
        5. Keep the Stock Split Ratio as 1.0
      3. Div > a cash dividend distribution
        1. Note: ensure that transactions to be in chronological order. for dividends use the ex-dividend date for the transaction instead of the date you get paid.
        2. Fill in the amount of stocks under consideration for cash dividends under Transacted units.(for reference you can take a look at Previous Units which shows the last amount of units you have for this stock.)
        3. Fill in the dividend per share under Transacted Price (per unit).
        4. Leave Fees as 0 unless you get charged for dividends
        5. Keep the Stock Split Ratio as 1.0
      4. Split > there is a stock split or a reverse stock split
        1. Keep Transacted Units at 0.
        2. Keep Transacted Price (per unit) at 0.
        3. Keep Fees at 0.
        4. Enter your split ratio under Stock Split Ratio. If its a 1 to 5 split the ratio is 5.0. If its a 5 to 1 consolidation the ratio is 0.2
  5. Stock Summary USD > When i come up with this spreadsheet i only have in mind local currency which to me is SGD. So i have a sepearte one that is similar to (3) here.
  6. Transactions USD > This is the transactions to Stock Summary USD.
  7. Mthly > This sheet splits Transactions and Transactions USD into total dividends and gains/losses collected by months.
  8. Yrly >This sheet splits Transactions and Transactions USD into total dividends and gains/losses collected by year.
  9. Allocation > Just a chart showing a pie of how much each stock i have. Once you are familiar with google spreadsheet you can create many of these to show to your readers.
  10. Ref > This sheet contains data found in the drop downs in the other sheets.
    1. Stock Category is some categorization that i set for my stocks. You can change them next time when you get comfortable.
    2. REIT Category – ignore this
    3. Price Tolerance – some warning indicator under Stock Summary to change the color of cells should it breach a certain level
    4. USDTOSGD - this you may find useful if you are new to Google Spreadsheet. I use this to convert USD to SGD via a formula in Google Finance. This will be used under Portfolio Summary to convert US portfolio to SGD portfolio
  11. Yahoo Data Ref > Here is where we get the data for the stocks under Stock Summary from Yahoo Finance.
    1. Do this right and your data from yahoo finance auto updates.
    2. There is only one cell that you need to edit here which is the cell A2. Take a look at it. It basically aggregates all the stock quotes in Stock Summary and then asks to return it in a CSV file and then display it in the cells below.
    3. You can request for more things. for more information take a look at
    4. There is a bug here but it is not something big. i will tell you about it below.
  12. Yahoo Data Ref USD > Same as (9) only for (5)

Q: How do I input Rights Issues or Cash Calls?

Rights Issues are basically company asking for more money from you to buy more shares. They make it attractive for you to buy at a lower price.

So take for example First REIT has a rights issue. Current price is $0.90 and they issue a  1 for 2 rights at $0.70. You currently have 2000 shares.

So a 1 for 2 rights means that you can purchase 1000 shares at $0.70. On top of that you can attempt to purchase excess rights (rights other investors don’t want). Lets say you can purchase another 2000 excess shares making your total 3000 @ $0.70.

Your input to Stock Portfolio Tracker will be a Buy transaction with a quantity of 3000 shares at a transacted price of $0.70 with zero commission.

Q: How do I input Bonus Shares?

Bonus shares are company paying you shares instead of cash. Take the example of Challenger Technologies issuing a 1 FOR 2 bonus shares. This means if you have 2000 Challenger shares you get 1000 (crazy good deal!)

Bonus shares on my Stock Portfolio Tracker is actually buying the stocks at ZERO transacted price.

You input a Buy transaction with a quantity of 1000 shares at a transacted price of ZERO with ZERO commission

Q: How do I input Dividend Reinvestments or DRIP?

Some companies like Aims AMP, Exxon Mobil have reinvestment plans. They are basically like bonus shares. Instead of the company taking that action, the share holder (you) choose to get paid by shares.

So in my Stock Portfolio Tracker it is basically handled like Bonus Shares.

Determine how much shares you will get from Reinvestment statements and input a Buy transaction with a quantity of shares at a transacted price of Zero with Zero commission


Must say that I thoroughly enjoyed this experience while creating this spreadsheet. I hope I am able to help someone who was having the same problem as myself.

Take a look at the spreadsheet, make a copy and modify it to suit your needs.

Free Online Investment Stock Portfolio Tracker Spreadsheet stockportfoliotracker

For those interested in tracking my most current holdings, you can review my portfolio over here. Since I am updating this together with my Quicken (yes still using that)

I hope you can make use of this tracker to help you fulfil your financial dreams. This spreadsheet is free, however should you want to contribute to my efforts in developing this tracker into something even better you can donate to me here! Else you may want to Like and Google Plus my site at the side panel!

For your FREE Dividend Stock Tracker you can review them here!

Want to read the best articles on Investment Moats? You can read them here >

Free Online Investment Stock Portfolio Tracker Spreadsheet facebook Free Online Investment Stock Portfolio Tracker Spreadsheet email Free Online Investment Stock Portfolio Tracker Spreadsheet google Free Online Investment Stock Portfolio Tracker Spreadsheet linkedin Free Online Investment Stock Portfolio Tracker Spreadsheet twitter Free Online Investment Stock Portfolio Tracker Spreadsheet reddit
  • Joseph Cavanagh

    Excellent spreadsheet. Donation sent for all the time you put into this.

  • Kyith

    Thank you so much Joseph, I hope its been helpful or inspires something that you can customized to help yourself

  • Kyith

    whoa! thanks Mike for helping. i will certainly keep track of this formula!

  • lin chunbin

    Hi kyith
    Thanks to provide so great information to us. But can you share with me how come you buy the valuetronics 1000 shares on 13/09/13 only pay the transaction fee 0.55$, but for me need to pay near 30$ for every transaction. Thanks you

    Best regards

    Lin cb

  • Kyith

    I am using standard chartered online trading with no minimum charges. the commission is .25% but note that its somewhat like a nominee acct. ur money is in a trustee with SC and not in CDP

  • Pingback: Tools to aid your Investment journey | shadowandy - my life stories

  • Mike

    No that’s not the case. Additionally, I’m getting Parse Error messages in the blue areas for no apparent reason. One day everything looks good and the next I get errors in fields where I have done nothing..

  • Kyith

    Hi Mike, would you like to share your sheet with so that I can try to troubleshoot

  • Mike

    I was hoping to show you a screen shot but it didn’t turn out properly.

  • Mike

    Thanks Kyith. It’s been sent

  • Mike

    Maybe you can delete the last couple of responses?

  • Kyith

    Mike the error was due to that the formulas for rows below being tainted. if you look at the formula there are alot of {} {}. What you need to do is take the second row blue cells drag them all the way down to repropagate them.

  • Mike

    Okay I’ll do that…. Thank you very much

  • Andrew

    Thanks for sharing this Mike, I was struggling with getting an alternative and this worked a charm. Can you also share your formula in excel for the realised gain/loss and dividends collected?

  • Andrew

    I got there in the end;


  • Jeff Tapia

    Kyith, Thank you, this is amazing work.

  • Kyith

    no problem

  • Silenius

    Hi there, I am trying to use this spreadsheet locally but my EXCEL keeps refusing to open the document after I have downloaded, saying “Excel cannot open this file. The file might have been damaged or modified from its original format”. Not sure why this happens. I am using a Mac. Appreciate advice pls and thanks for the great work!

  • LN

    Great work! Can the tracker be modified to also track equity options?

  • Kyith

    hi LN, i find it difficult. options is more for trading and perhaps a transactional log one with more put and strike targets and assessment make more sense.

  • Kyith

    hi Silenius, this is a Google Spreadsheet, and it works only on Google web.

  • Kannan S

    Thank you so much putting together this. I really appreciate the hard work and then sharing with the world, this is amazing thourght. I wanted to use this sheet as MS Excel sheet. anyone got template for it or copy of the google Stock portfolio tracker, so I can started put the transactions directly into excel. I am not a excel savvy person so having hard time getting to work in excel. Appreciate your kindness.

  • Noob

    Hi, thanks again for the wonderful work. I’ve been tinkering with the spreadsheet to customise it for myself but was wondering if you could advise if it is possible to auto-populate a stock’s latest annual dividend yield? I find that using the stock’s yield value is easier than inputting the DPU manually.. Many thanks!

  • Kyith

    hi Kannan, currently this only works in Google Spreadsheet

  • Kyith

    hi Noob, that will be hard. its difficult to get downloadable dividend data

  • Kannan S

    Thank you so much and I really appreciate your reply!!!

  • Kyith

    No problem. Just trying to help

  • John Money

    Would it be difficult to add columns for daily percentage and dollar change?

  • Kyith

    Hi John, i am not sure if it will be easy or difficult, it depends on your understanding. If you look at the sheet Yahoo Data Refs you will see that there are a string of letters at the back. they indicate what to get from Yahoo. The description of each letter are provided here >

    Add the 2 you want in, then at each Stock Summary, modify the vlookup to grab the approporiate column

  • Dane

    Hi, is there any way you can explain to me how to have a YTD unrealised/realised gain tracking so that I can see how I’m doing year over year. I would preferably like to have this on the YTD sheet and potentially something that happens similarly on the monthly sheet. Thanks for any insight.

  • Kyith

    Hi Dan, currently i don’t have that functionality. perhaps some readers can advice.

  • dane

    Hi Kyith, thanks for responding so quickly and thanks for such a great tool. I will tinker with the sheer and see what I can figure out.

  • CJ

    How do I update the spreadsheet to your newest version? I’m currently on version 1.5. Thanks!

  • Pingback: What software u all use to track ur counters, portfolio etc? -

  • Miker

    Doesn’t work for Canadian TSX Venture listed stocks. It returns N/A to the right of the google ticker and although the Yahoo ticker does update the prices, they’re wrong.

  • Kyith

    Hi CJ,

    you have to manually see the changes at my latest change log and update. i am sorry there is no easy way. you would also not want an auto erasing of your existing data isnt it.
    the most likely changes are the change to 1.10. nothing significant i feel

  • Kyith
  • Kyith
  • Kyith

    Hi Miker, strange it used to work. Perhaps Google Finance doesn’t support. Which company are you talking about here.

  • JH

    Hello, and thank you for a wonderful tool. I am having trouble getting new transactions to load on the “chart data” sheet. Please advise.
    Thank you

  • Kyith

    if you share your doc with me perhaps i can see whats wrong with it. usually the problem is that the data have gone off. perhaps u need to go to select data to re-select again.


  • JH

    Thank you for your response. Where and how do I re-select data?

    Jerry Herron

    Subject: Re: New comment posted on Free Online Investment Stock Portfolio Tracker Spreadsheet

  • Hamish

    Hi Dane and Kyith,

    I have just started using this and think that its a fantastic tool!! I agree that it would be useful to have a YTD unrealised/realised gain tracking system but unfortunately have no programming experience..

    I also think it could be useful to have a function that provides an annual return figure, say at the end of a financial tax year or calendar year, so that the percentage (theoretical) return could be seen. At the moment it appears that this is only calculated when there is a transaction and as I tend to hold my shares rather than trade this doesnt compute until they are sold and puts the gain/loss into the year that theyre sold rather than as an accumulation over all the years they were held.

    The only way I can see around this is to run multiple sheets: one master copy then another sheet for each financial year and effectively create transactions at the end of each financial year to “sell” all at the current price to get the annual return figures then at the same time create another sheet and “buy” the same number of units at that current price.. I feel that that may help to see how stocks are doing on an annual basis.

    Cheers for creating this whoever it was!

  • Kyith

    Hi glad you like it and do share around with your friends if I added enough value here, thanks!

  • Pat


    Wonderful worksheeet. Thanks for

    In Canada, to get the maximum of the tax system, we must have different accounts. I’d like to keep the information by account (to ease the reconciliation) but need to have an overview of all accounts to ensure that my asset allocation fit my risk assessment. I was wondering if you have the procedure to follow in order to add “transaction and stock summary” sheets to expend your
    worksheet and to ensure that the information is included in the portfolio summary sheet.

    Many thanks.

  • Pingback: Which app / site for input/viewing all yr trades? -

  • Pingback: which application you all are using to monitor stocks? -

  • Pingback: How do you guys track ur portfolio performance? - Page 2 -

  • Pingback: money management software? -