Match Portfolio Tutorial

*For those who traded within 1 year, please go to Retrieving Col financial monthly ledger tutorial.

*For those who traded more than a year in COL Financial please follow the steps below to match your portfolio and trading journal.

"Match your COL Financial Group, Inc. portfolio to "PSE trading journal" with the available 1 year trade data from Colfinancial ledger."

A - The concept is we need to match first the oldest month available in our ledger to the trading journal by using User-Guide Match Portfolio spreadsheet ,  for example the oldest month available is October 2016 (see image below) , the Cash balance and Stock positions for that month should match the trading journal.

B-Then we retrieve all our trade history from November 2016 to the current month September 2017 (see image below) using Col Ledger Data spreadsheet... and copy paste to the trading journal.

4- Download User-Guide Match Portfolio Spreadsheet @ https://goo.gl/xLHPF8

4.1 - Enter the following the from image above 

(Total Portfolio trade value, Total equities gain/loss, Cash balance)

5- Open PSE Trading Journal and Enter current stock positions (see image above) to trade log sheet.

5.1- Disregard Current shares with 0 value.

5.2 Follow steps in Match portfolio tutorial STEP 2. 

 SPREADSHEET  DOWNLOAD: 
UserGuide -Match Portfolio.ver01
https://goo.gl/xLHPF8

COL Ledger data.ver04
https://goo.gl/DaAzVZ