It should be pretty straight forward.
Under data, go to text to columns, delimit by what ever separates your data.
The profit and loss per trade is just sale proceeds less original cost. Say your original costs was in C2 and sale proceeds was in F2, in a free cell to the right of that row, add the formula =F2-C2. Add a heading above this, like profit/loss.
You can then copy down by just double clicking on the bottom right of that screen.
Probably just as easy to work out profit and loss by summing that column.
If you want to to see profit per investment, you can use a pivot table. Just select the top left to select everything, go to insert > pivot table. Create in a separate sheet.
Once done, just drag the investment name/code and add to the row, the bottom left box on right of screen and drag the profit/loss heading to the formula box, bottom right on the right of the screen.
It will probably automatically coumt in the formula, so right click on the profit/loss heading and select sum. This will now work out the profit/loss per asset.
Its all pretty simple once you know how, however if you can't sort it out, let me know.
Probably be quicker to actually do it then write this post.
- Forums
- ASX - By Stock
- Accounting
It should be pretty straight forward. Under data, go to text to...
- There are more pages in this discussion • 9 more messages in this thread...
You’re viewing a single post only. To view the entire thread just sign in or Join Now (FREE)
Featured News
Add ARL (ASX) to my watchlist
(20min delay)
|
|||||
Last
69.5¢ |
Change
0.040(6.11%) |
Mkt cap ! $138.6M |
Open | High | Low | Value | Volume |
65.0¢ | 69.5¢ | 56.0¢ | $363.8K | 598.9K |
Buyers (Bids)
No. | Vol. | Price($) |
---|---|---|
2 | 34342 | 63.0¢ |
Sellers (Offers)
Price($) | Vol. | No. |
---|---|---|
69.5¢ | 1399 | 1 |
View Market Depth
No. | Vol. | Price($) |
---|---|---|
2 | 34342 | 0.630 |
1 | 50000 | 0.600 |
1 | 15603 | 0.590 |
1 | 8650 | 0.565 |
1 | 15006 | 0.555 |
Price($) | Vol. | No. |
---|---|---|
0.695 | 1399 | 1 |
0.700 | 30000 | 1 |
0.750 | 50008 | 1 |
0.800 | 45000 | 2 |
0.830 | 1324 | 1 |
Last trade - 16.10pm 03/05/2024 (20 minute delay) ? |
|
|||||
Last
67.5¢ |
  |
Change
0.040 ( 0.75 %) |
|||
Open | High | Low | Volume | ||
62.0¢ | 67.5¢ | 56.0¢ | 183666 | ||
Last updated 15.47pm 03/05/2024 ? |
Featured News
ARL (ASX) Chart |