Spreadsheet Tips & Tricks for the Do-It-Yourself Investor

Posted on by

SYNOPSIS

Volatility (as measured by VIX) is back to near all time lows. Investors are apparently unconcerned about there being a loose cannon in the White House. It’s as if they expect him to be gone very soon. Perhaps they’re right. Trump set two records in his first 100 days in office: (1) First US president to not pass a single piece of legislation during that period, and (2) He holds the lowest approval ratings of any US president after 100 days in office at 39%. Corporate tax reductions, if they ever happen, may finally boost stock prices, but who knows when that will happen. Meanwhile Canadian stocks and the Loonie are suffering from Trump’s tariff threats.

PTP… Our ProfiTrend Portfolio APAR (annualized price appreciation rate) continued to improve this past week to 55%. The S&P 500 APAR improved by a few points, while the TSX APAR declined by a point over the previous week.

wpid-bar_speedo_170428s-2017-05-1-21-37.png

Last Week in the Indexes… The Canadian small cap indexes (S&P/TSX Small Cap Index and S&P/TSX Venture Index) continued to decline substantially last week, while most of the US indexes improved between 1.5% and 2.3% over the week.
These thin blood cheap viagra veins do not carry sufficient blood to male genital area during sensual stimulation. The order tadalafil from india drug becomes active within 20 to 30 minutes prior to sexual intercourse. The tadalafil purchase online examination group endeavoured to discover a connection between arousal in ladies and pelvic blood stream in ladies. After widening the vessel with angioplasty, your vascular surgeon sometimes pdxcommercial.com generic discount levitra inserts a stent depending upon the circumstances.
PTA Perspective… Spreadsheet Tips & Tricks for the Do-It-Yourself Investor

wpid-url-2017-05-1-21-37.png

 

This week we diverge from studying the markets to discuss some useful, but relatively little known, techniques that should help investors make the most of using spreadsheets for investment planning and tracking. Even those using more advanced investment analysis software should find something useful here, since even high-end data modelling often starts with spreadsheet files.