Question on tracking your stocks

[desmond91]

Hi, peeps..

as i have just started trading..

hence asking around if anyone has a sample of their portfolio(excel) that i could follow to track my stocks...

not very sure if possible to grab the last done data online also

thanks in advance for help

 

[ZacharyA]

Hi, peeps..

as i have just started trading..

hence asking around if anyone has a sample of their portfolio(excel) that i could follow to track my stocks...

not very sure if possible to grab the last done data online also

thanks in advance for help

why use excel? then manually update the closing share price daily???

 

[StanleyCo]

Try this Google Sheet
Stock Portfolio Investment Tracker

 

[iantay88]

so this google sheet is updated automatically with live prices? i am sorry i am viewing it on my ipad so cant really go try it out

Try this Google Sheet
Stock Portfolio Investment Tracker

 

[StanleyCo]

Yes it does

 

[funnycow]

I think you can try to google this program, Jstock

 

[iantay88]

its not avail for mac users

I think you can try to google this program, Jstock

 

[desmond91]

Try this Google Sheet
Stock Portfolio Investment Tracker

yupp i did google search eariler on but this one looks very complicated to use lei

 

[StanleyCo]

Complicated at first but once you know how, it is able to show a summary at once and is also accessible on mobile google sheets.

Try changing the stock symbol and name under stock summary, then go to transactions and key in accordingly.