Step#1 Asset Status_v1 Chart Structure

Chart mainly has 5 parts of the chart. Those are "Summary", "Detail", "Trend","Trend-TypeB" and Sim.

Summary

- There is table for the summary of asset status like Initial Investment Capital, Investment Assets, Profit & Loss, Realized Gain & Loss, Cash, Dividend and Total Asset.

- There is chats for regognize the current status of assets.

Detail

- There is data which is used for making data on the table in "summary" sheets

- The categories for "Detail" is same with "Summary" but it have detail data per each investment campanies which i currently have

- The data can be filtered by Year and Month by the button which is located on top and left of the sheet.

Trend

- It can be used to check the current status of each stocks or ETFs that i currently have.

 

Trend-typeB

- This is another type of the chat for checking the trend of the stocks or ETFs

- The specialty of this sheet is that it has candle chart to invesgate the trend of buying or selling stocks

- Another one is taht it has function to shawing the data on the table by clicking the stock or ETS's name on Colume E1:E50.

 

Sim

- This sheet is still on the construction. But it can be used usfully later for estimate the stock price after one month later or near future.

- The machanism of this page is that. list up the previous month grow or down percentages for the selected stock automatically by scripts. And estimate the stock price on this month based on the previous month data.

- This chart is not gurantte the profit of the stocks perfectly. But it is helpful to improve of sence for the trend of stocks