Advertisement

Anonymous

25 Jul 2021

∙

General Investing

Do you guys track your investments just within the brokerage app or on a separate excel sheet?

Any templates or best way to track using excel?

4

Discussion (4)

What are your thoughts?

Learn how to style your text

Ho Chang Jun

27 Jul 2021

I do use an excel sheet in order to gain a comprehensive picture of my fund since I use different brokerage platforms for stocks and crypto. You can use googlefinance or importhtml functions to obtain live stock and cryptocoin prices and create charts that are instatly updated as well.

Reply

Save

Timothy Ong Chee Aik

27 Jul 2021

I used a separate one with Google sheet. This is a wonderful sheet that i came across to track US stocks - https://docs.google.com/spreadsheets/d/1GqusdLl...

Can also modify to track SG stocks too but the stock price portion need to be manual or grab using below...-just replace A2 with ticker

=REGEXREPLACE(index(IMPORTHTML(CONCAT("http://www.shareinvestor.com/fundamental/factsh...",A2),"table",5),1,1),"^d","")/1000

Reply

Save

rogersk

Edited 26 Jul 2021

I did create a spreadsheet. Ended up damn lazy to maintain. The main issue wif Google sheets was tha...

Write your thoughts

Related Posts

When tracking your stock portfolio, how do you guys include/ factor in roboadvisor investment into your excel sheets?

I started to invest. Any tips / advice to share how to track / monitor on the progress or status of my portfolio (phone app / Excel)?

Can you guys recommend a good app or excel template to manage investments?

Let's talk about budgeting apps. Any recommended apps you guys use to track your expenses and for budgeting? How do you sync your spouse's data together?

I am a 28 year old guy who's aiming to get married in the next 5 years. I am new to investing as well, could you advise me an investment type that could earn me decent returns within 3-7 years?

Related Posts

When tracking your stock portfolio, how do you guys include/ factor in roboadvisor investment into your excel sheets?

I started to invest. Any tips / advice to share how to track / monitor on the progress or status of my portfolio (phone app / Excel)?

Can you guys recommend a good app or excel template to manage investments?

Let's talk about budgeting apps. Any recommended apps you guys use to track your expenses and for budgeting? How do you sync your spouse's data together?

I am a 28 year old guy who's aiming to get married in the next 5 years. I am new to investing as well, could you advise me an investment type that could earn me decent returns within 3-7 years?

Advertisement