Google spreadsheet used to create online portfolio. To see the sample follow the link below.
Link to Stock Portfolio
Open the link, login to your google account, and make a copy of the file and save.
Use Google Finance codes for NSE stocks to add any new stock in to "SumS" sheet, and add Buy/ Sell transactions to "TrxS" sheet. You can track your holdings Live (may be 1 min interval) during market hours. Can see daily gain/loss, total unrealised gain/loss, realised gain/ loss etc. You can modify it further to suite your personal requirements.
Link to Stock Portfolio
Open the link, login to your google account, and make a copy of the file and save.
Use Google Finance codes for NSE stocks to add any new stock in to "SumS" sheet, and add Buy/ Sell transactions to "TrxS" sheet. You can track your holdings Live (may be 1 min interval) during market hours. Can see daily gain/loss, total unrealised gain/loss, realised gain/ loss etc. You can modify it further to suite your personal requirements.
No comments:
Post a Comment