Pages

Sunday, November 19, 2017

Zeefreaks investagrams trading cup


Amazing trades from Zeefreaks trading history from investagrams trading cup posted last October 31, 2017 where he ranked #2.





How to enable macro.

If Developer tab did not show on menu bar, follow steps on image#1 , else, follow steps on image#2
1-Click file
2-Click Customize ribbon
3-Check the Developer check box
4-click OK

image#1



1-Click on developer tab
2-Click Macro security
3-Enable all macro or you can select "Disable all macros with notification".
4-Click OK
5- Important step : Re-OPEN the worksheet file.
image#2




Thursday, September 28, 2017

Risk Management Calculator version 3

For latest version go to Risk Management Calculator version 4



Risk management calculator will help you find the approximate volume of shares to buy or sell to control your maximum risk per position.

Step 1 : Enter your intended account size per trade.
Step 2 : Set a percentage of your account you’re willing to risk on each trade.
Step 3 : Select calculation option, if Exact value or based on Board lot.
Step 4 : Enter your entry price and the cut loss price for this particular trade.
Step 5 : Select 'Shares to buy' option, if base on maximum shares you can buy from your account size or based on Risk calculation.

 SPREADSHEET  DOWNLOAD: 
AAES-Risk Management.03
https://goo.gl/WwhCnu

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

Match Current Portfolio to PSE Trading Journal.



If your lazy enough to retrieve all your trade history and want to begin with your current portfolio, you can match PSE-trading journal with Portfolio with these 3 steps guide.

 SPREADSHEET  DOWNLOAD: 
UserGuide -Match Portfolio.ver01


Related Post:

Retrieving Col financial Monthly Ledger

Convert Colfinancial Ledger data to Excel table.
 




Can retrieved Buy/Sell transactions, Account Deposit/withdrawal & Cash dividends (Limited to one year transactions).

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