Friday, January 8, 2016

Singaporecoins Stock Portfolio Tracker - updated 2016-01-09

https://docs.google.com/spreadsheets/d/1kfnTf4yaioJA7RNhdzxszjZSePhEHUoNFl7cgCY1T8M/pub?single=true&gid=0

Cost%Current Value%Unrealised Gains/Losses%Realised Gains/LossesDividends CollectedExpected Annual DividendsExpected Annual Dividend Yield
Cash Register$805.2326.55%$805.2328.27%$0.000.00%$0.00$0.00$0.400.05%
Unlisted Securities$0.000.00%$0.000.00%$0.000.00%$0.00$0.00$0.004.00%
Base Currency Securities$2,228.0373.45%$2,043.0071.73%-$185.03-8.30%$0.00$33.00$166.847.49%
USD Securities in Base Currency$0.000.00%$0.000.00%$0.000.00%$0.00$0.00$0.00#DIV/0!
HKD Securities in Base Currency$0.000.00%$0.000.00%$0.000.00%$0.00$0.00$0.00#DIV/0!
Total$3,033.26100.00%$2,848.23100.00%-$185.03-6.10%$0.00$33.00$167.245.51%
Legend
Cells users fill in own values
Cells Stock Portfolio Tracker Auto Calculates
Base CurrencyYour home currency
CashUndeployed Liquid Asset Class
Unlisted SecuritiesAssets and instruments that are not listed, or hard to frequently update. They form your Wealth Portfolio so its best you manually track them

CategoryStock NameGoogle QuoteGoogle PriceYahoo QuoteYahoo PriceManual PriceLast PriceLast DPUYield on CostLast Price YieldUnitsCostCost (Per Unit)Unrealised Gain/LossUnrealised Gain/Loss (%)Realised Gain/LossDividends CollectedTotal Gain/LossMkt Value52 Wk Low52 Wk High50 Day MA200 Day MA
Dividend
Second Chance PropertiesSGX:528#N/A528.SI528.SI+0.2450.3280.2450.03610.81%14.49%400$131.320.328-$33.32-25.37%$0.00$0.00-$33.32$98.00AboveBelowBelowBelow
Dividend
APTTSGX:S7OU#N/AS7OU.SIS7OU.SI+0.650.7260.650.08311.36%12.69%1200$871.660.726-$91.66-10.52%$0.00$20.00-$71.66$780.00AboveBelowBelowBelow
Dividend
Ascendas REITSGX:A17U#N/AA17U.SIA17U.SI+2.252.2562.250.1466.47%6.49%100$225.552.256-$0.55-0.24%$0.00$0.00-$0.55$225.00AboveBelowBelowBelow
Dividend
Singapore Press HoldingsSGX:T39#N/AT39.SIT39.SI+3.784.0403.780.2004.95%5.29%100$404.014.040-$26.01-6.44%$0.00$13.00-$13.01$378.00NearBelowBelowBelow
Growth
STI ETFSGX:ES3#N/AES3.SIES3.SI+2.812.9572.810.0973.28%3.45%100$295.742.957-$14.74-4.98%$0.00$0.00-$14.74$281.00NearBelowBelowBelow
Growth
Nikko STI ETFSGX:G3B#N/AG3B.SIG3B.SI+2.812.9982.810.0933.12%3.32%100$299.752.998-$18.75-6.26%$0.00$0.00-$18.75$281.00NearBelowBelowBelow

1 comment:

  1. Hey, Thanks for sharing this Tips About Financial Planning. I just see your blog and impressed. keep the same alltime. I am looking daily Yes Bank news.

    ReplyDelete