Accounting and Summaries

Top  Previous  Next

Here you can let the magic of SQL let you understand how you have actually performed in the market. With this tool, you can do things that are not possible with spreadsheets like Excel, or simple databases like Access.

 

To open this window, press Tables | Accounting on the main form, or Alt + A. You can also do this from the Contracts Table, by pressing Contracts | Accounting.

 

First, you enter trading data. Currently, this is done manually, but it is planned to permit importing data from other formats.

 

Enter the stock, number of shares (+ for a buy, - for a sell, 0 if it is a dividend), price per share, date, commission, dividend. In additon, you may choose an account. You may have a real account and an IRA account, and your trading strategies are different for these accounts. You may have simulated accounts. This guy is telling you all kinds of things, with promises to make money. Well, do what he says, but trade in the simulated account, and you will see what actually happens.

 

When you buy, it automatically updates Shares Remaining to the number of shares bought. When you sell, it calculates the profit and loss (P&L) by looking at previous trades, and adjusts the Shares Remaining.

 

Accounting Misc

 

Press Update. It will get the current values of the stocks from the Contracts Table. These values are either updated by MyTrack, or else you entered new CSI data files, and the table was updated with the new values. (This is done by Run | Add Volume in the Contracts Table.) The program will then calculate the Unreal P&L, which is the profit and loss had you sold everything, and list them along with the Total P&L.

 

You can press Add to add another trade with the same stock quickly.

 

When you double click on a stock, the chart comes up. If you wish to disable it, uncheck Chart in the menu shown above.

 

If you do not wish to see the grids colored, uncheck Colored Rows.

 

When entering dates, a pop-up calendar will appear, making it easy to add dates. This is if Use Date Time Picker is checked, which is the default. You can uncheck it, if you prefer entering dates as a string, or if you wish to copy and paste dates.

 

The settings are remembered for future sessions.