Spreadsheet: 668415d1584807270-help-balancing-my-books-shares-logbook2
Sheet: Sheet2

Account | Date | Open/Close | Short/Long | Code | Company | FOREX Code | FOREX rate | Size | Price Traded | Traded Currency | (AUD) Commissions+GST | (USD) Commission | (AUD) Dividends gained or lost | (USD) Dividends gained or lost | Net Gain (AUD) | Net Gain (USD) | Trades Net Gain (AUD) | Trades Net Gain (USD)
SXSJ4 | 2019-03-11 00:00:00 | Open | Long | ASX: PRN | Ausdrill Ltd | AUD/AUD | 1 | 3025 | 1.65 | AUD | 8
SXSJ4 | 2019-03-14 00:00:00 | Close | Long | ASX: PRN | Ausdrill Ltd | AUD/AUD | 1 | 3025 | 1.675 | AUD |  |  | 105.88
SXSJ4 | 2019-03-06 00:00:00 | Open | Long |  | Spark Infrastructure Group | AUD/AUD | 1 | 3740 | 2.27 | AUD | 8.49
SXSJ4 | 2019-03-14 00:00:00 | Close | Long |  | Spark Infrastructure Group | AUD/AUD | 1 | 3470 | 2.25 | AUD
SXSJ4 | 2019-03-15 00:00:00 | Close | Long |  | Spark Infrastructure Group | AUD/AUD | 1 | 270 | 2.25 | AUD
SXSJ4 | 2019-03-06 00:00:00 | Open | Long | ASX: ALK | Alkane Resources | AUD/AUD | 1 | 9500 | 0.205 | AUD
SXSJ4 | 2019-03-14 00:00:00 | Close | Long | ASX: ALK | Alkane Resources | AUD/AUD | 1 | 9500 | 0.22 | AUD
SXSJ4 | 2019-03-14 00:00:00 | Open | Long |  | Ironbark Capitial | AUD/AUD | 1 | 29350 | 0.51 | AUD | 14.38
SXSJ4 | 2019-04-11 00:00:00 | Close | Long |  | Ironbark Capitial | AUD/AUD | 1 | 29350 | 0.49 | AUD |  |  | 528.3
SXSJ4 | 2019-03-19 00:00:00 | Open | Long |  | Flight Centre | AUD/AUD | 1 | 337 | 44.46 | AUD | 14.98
SXSJ4 | 2019-04-08 00:00:00 | Close | Long |  | Flight Centre | AUD/AUD | 1 | 337 | 44.161009 | AUD |  |  | 704.33
SXSJ4 | 2019-03-15 00:00:00 | Open | Long |  | Westpac Banking | AUD/AUD | 1 | 222 | 26.9 | AUD
SXSJ4 | 2019-03-24 00:00:00 | Close | Long |  | Westpac Banking | AUD/AUD | 1 | 222 | 28.05 | AUD |  |  | 208.68
 | 2019-10-23 00:00:00 |  |  |  | Subscription Fee
SXSJ4 | 2019-10-31 00:00:00 | Open | Long | ASX: ALK | Alkane Resources | AUD/AUD | 1 | 6980 | 0.715 | AUD
SXSJ4 | 2019-11-04 00:00:00 | Open | Long | ASX: ALK | Alkane Resources | AUD/AUD | 1 | 6840 | 0.73 | AUD
SXSJ4 | 2019-12-27 00:00:00 | Open | Long | ASX: ALK | Alkane Resources (Rights Issue) | AUD/AUD | 1 | 1727 | 0.55 | AUD
SXSJ4 | 2020-01-17 00:00:00 | Close | Long | ASX: ALK | Alkane Resources | AUD/AUD | 1 | 15547 | 0.705 | AUD
SXSJ4 | 2019-10-29 00:00:00 | Open | Long | ASX: S32 | South32 | AUD/AUD | 1 | 2240 | 2.65 | AUD
SXSJ4 | 2020-01-15 00:00:00 | Close | Long | ASX: S32 | South32 | AUD/AUD | 1 | 2240 | 2.89 | AUD
SXSJ4 | 2019-11-26 00:00:00 | Open | Long | ASX: AMP | AMP Ltd | AUD/AUD | 1 | 516 | 1.92 | AUD
SXSJ4 | 2019-11-25 00:00:00 | Open | Long | ASX: AMP | AMP Ltd | AUD/AUD | 1 | 502 | 1.97 | AUD
SXSJ4 | 2020-01-21 00:00:00 | Close | Long | ASX: AMP | AMP Ltd | AUD/AUD | 1 | 1018 | 1.95 | AUD
SXSJ4 | 2002-01-23 00:00:00 |  |  |  | Currency Transfer | AUD/USD | 0.68090835 |  |  | AUS |  |  |  |  | -19109.77
SXSJ4 | 2020-01-23 00:00:00 | Open | Long | NASDAQ: TSLA | Tesla Motors Inc |  | 1 | 22 | 591 | USD |  | 10
SXSJ4 | 2020-01-23 00:00:00 | Close | Long | NASDAQ: TSLA | Tesla Motors Inc |  | 1 | 22 | 586.04 | USD |  | 10.27
SXSJ4 | 2020-03-06 00:00:00 |  |  |  | Currency Transfer | USD/AUD | 1.5046464625 |  |  |  |  |  |  |  |  | -12508.22
SXSJ4 | 2020-03-06 00:00:00 | Open | Long | ASX: BHP | BHP Group Limited | AUD/AUD | 1 | 605 | 32.65 | AUD
SXSJ4 | 2020-03-06 00:00:00 | Close | Long | ASX: BHP | BHP Group Limited | AUD/AUD | 1 | 605 | 32.43 | AUD
SXSJ4 | 2020-03-06 00:00:00 | Open | Long | ASX: WPL | Woodside Petroleum Ltd. | AUD/AUD | 1 | 740 | 26.84 | AUD
SXSJ4 | 2020-03-06 00:00:00 | Close | Long | ASX: WPL | Woodside Petroleum Ltd. | AUD/AUD | 1 | 740 | 26.56 | AUD
 |  |  |  |  |  |  |  |  |  |  | (AUD) Commissions | (USD) Commisions | (AUD) Total Dividends | (USD) Total Dividends | (AUD) Total Gain/Loss | (USD) Total Gain/Loss | Trades Net Gain Closed (AUD) | Trades Net Gain Closed (USD)
Currently Open:
SXSJ4 | 2019-04-12 00:00:00 | Open | Long | NASDAQ: HX | Hexindai Inc | USD/AUD | 1.40699 | 5724 | 3.706157 | USD | 161.07
SXSJ4 | 2020-03-17 00:00:00 | Close | Long | NASDAQ: HX | Hexindai Inc | USD/AUD | 1.449275362318841 | 235 | 0.390849 | USD |  | 10
SXSJ4 |  | Close | Long | NASDAQ: HX | Hexindai Inc | USD/AUD |  |  |  | USD
 |  |  |  |  |  |  | 1.724 |  | 0.36
Overall: |  |  |  |  |  |  |  |  |  |  | (AUD) Commissions | (USD) Commisions | (AUD) Total Dividends | (USD) Total Dividends | (AUD) Total Gain/Loss | (USD) Total Gain/Loss | Trades Net Gain (AUD) | Trades Net Gain (USD)
2020-03-21 00:00:00
SXSJ4
 |  |  |  |  |  |  |  |  |  |  |  |  |  | IG Website: | My Logbook: |  | Descriptions:
 |  | 2019-03-06 00:00:00 | Cash in | 500 |  |  |  |  |  |  |  |  | Open Positions | 3412.56 |  |  | Open Positions in AUD
 |  | 2019-03-06 00:00:00 | Cash in | 10000 |  | Exchange Rate: |  |  |  |  |  |  | Book Cost | 35249.41
 |  | 2019-03-07 00:00:00 | Cash in | 5000 |  |  | USD | = | 1 | AUD |  |  | Agrregate profit/loss | -31836.85
 |  | 2019-03-18 00:00:00 | Cash in | 15571 |  | 1 | USD | = | 1.724 | AUD |  |  | Funds | 5025.83 |  |  | AUD Cash available now + US in AUD
 |  | 2019-03-20 00:00:00 | Cash out | -1000 |  |  |  |  |  |  |  |  | [NAME] | 0
 |  | 2019-05-14 00:00:00 | Cash in | 5260 |  |  |  |  |  |  |  |  | Unsettled - debit | 0
 |  | 2019-05-29 00:00:00 | Cash out | -3000 |  |  |  |  |  |  |  |  | Margin | 0
 |  | 2019-08-03 00:00:00 | Cash in | 2552 |  |  |  |  |  |  |  |  | Available to withdraw | 4235.28 |  |  | AUD Cash available now
 |  | 2019-10-30 00:00:00 | Cash in | 5000 |  |  |  |  |  |  |  |  | Total Value | 8438.39 |  |  | Value if you switched all to cash right now
 |  | 2019-10-31 00:00:00 | Cash in | 5000
 |  | 2019-11-12 00:00:00 | Cash in | 993.58
 |  | 2019-11-26 00:00:00 | Cash in | 996.94
 |  | 2019-12-05 00:00:00 | Cash in | 1500
 |  | 2020-03-05 00:00:00 | Cash in | 20000
 |  | 2020-03-11 00:00:00 | Cash out | -35000
 |  | AUD |  |  | USD
 |  | Net Cash into Account:
 |  | Dividends +/- |  |  | Dividends +/-
 |  | Commissions |  |  | Commissions
 |  | Raw Gain (Buying/Selling)
 |  | Net Gain (AUD)
 |  | Idle Account Money: |  |  | Idle Account Money:
 |  | Net Shares value:
 |  | Total Gains/losses: