Home » How to track your mutual funds & stocks in google sheet?
How to track your mutual funds & stocks in google sheet?

How to track your mutual funds & stocks in google sheet?

by Ravi Sharma

Have you heard about the Pandemic Next spreadsheet? It’s a free project that automatically tracks your stocks and mutual funds in Google Sheet, so you don’t need to track them manually anymore!

This article is going to guide you step by step on how to use the Pandemic Next spreadsheet and will also show you some of its amazing features. Read on!

How do I install pandemic next sheet?

– You can download the cloud version of pandemic next sheet or use our web app at https://spreadsheets.google.com/a/islamictoolkit.com/…allspaces-.
– If you want to use the google sheets offline, click on the “Download (zip)” button, download and extract it.
– Then go to Google Drive, go to files tab and click on “Add a file”.
– Now upload pandemic_next.xlsx from your computer’s drive in the excel file field. Click on Save button after uploading. You can now open that file in Google Sheets by clicking on “Open with” and then Google Sheets(2 tabs).
– Set your timezone as either GMT or UTC +00:00 which is usually India’s time zone. Then press on save.
– Now click on share icon in the top left corner and then “Get sharable link”.
– Click on “Full view” when you’re redirected to a google sheet.  Then set up your account settings. Google sheet will guide you through the process of getting this done. You can set up your settings by going to Share → Get sharable link and choose “Pandemic Next”. That’s it! You can now track your stocks and mutual funds straight from google sheets.

So how is this different from yahoo finance?
You can track your stocks and mutual funds directly from google sheets. There are no embed links as it doesn’t make sense to hardcode the links in a sheets’s text.

It’s completely free too! It doesn’t require you to pay or sign up for any account, so it’s absolutely FREE for the whole world!

How does tracking stocks and mutual funds work?
Consider this example: I have mentioned in this article 4 companies in my sheet. I want to know what is Bharat Forge’s trailing P/E, EPS, EPS growth rate etc. Pandemic Next will help you get all of that information using Excel formulas.

For example: If I have these 4 companies in my sheet, I want to know the trailing P/E, EPS, EPS growth rate of these companies. This information is available on the company’s website.
So how does Pandemic Next help me with this?

For this we need to use a formula. A formula is simply a set of instructions that tell Excel what to do when you enter certain numbers in a cell. The formula will tell Excel what to do when you enter these 4 numbers into the cells that belong to their respective companies.

This is how your formula would look like:
=P(UNCOUNT(TOPLEFT([FILTER(A1, INDEX(A1:A7,”ALPHA”):INDEX(A1:A7,”C”)],2),5)-5)*5*EPS)
For this formula to work, you first have to enter the 4 companies in A1:A4 and select a stock for each of the 4 companies in cell A5.

Formula will work on a certain range of cells. In other words, it will only work on cells that belong to the company whose data we wish to access. For example, let’s say in your sheet A1 contains the P&L of a company. In this case, the formula will work on that particular range of cells only – starting from cell A1 (for example) and ending on a cell approximately 5th row down & 4th column down (in my case).

So how does tracking stocks and mutual funds help?
Tracking stocks and mutual funds helps you become more aware of your investments, much like a diary helps you become more aware than you were before.

With the pandemic next sheet you don’t have to remember what stocks and mutual funds you own, and which ones you haven’t checked months or even years ago. You can just check to see how they are doing whenever you want.

When I go to my stocks and mutual funds tab, I get a summary of all my holdings in a neat table format with links that take me directly to the company’s website. I then look at the company’s financial data (which is very neatly organized) and based on that I can decide whether or not I should keep those stocks in my portfolio.

Related Posts

Leave a Comment