profit & loss

  1. M

    VBA for a Profit Calculation

    Date Type Stock Price Quantity Amount VBA Correct 04-01-2024 Bought MINM 3,960 10 39,60 04-01-2024 Sold MINM 3,900 10 39,00 -0,60 -0,60 04-01-2024 Bought MINM 4,060 10 40,60 - 04-01-2024 Bought MINM 3,760 10 37,60 - 04-01-2024 Sold MINM 4,130 20 82,60 7,40 4,40...
    • mollerrr
    • Thread
    • profit & loss trading trading spreadsheet vba & code
    • Replies: 2
    • Forum: Excel Questions
  2. T

    Blank cell cant make calculations !

    Hello Forum! I have this data and I would like to calculate the profit loss,( entry value - exit value) or the other way around it depend if is a long or a short. The problem I am facing is that I can't make the calculation because the data in not linear but shifted, what's the best solution ...
  3. S

    Formatting Account Number to the right place

    Hi All, I export a P&L file from MYOB, however all my account/job numbers appear in the same coulmn as the account headings. I was wondering is there any way of sticking in a formula that can place these account numbers beside the relevant account categories for that account. So currently...
  4. E

    Excel Table Design, Budget vs Actual

    I am working on a Budgeting spreadsheet that will include actual and budget amounts for about 20 items (revenue & expenses). My problem is the budget figures for the year are by "Period" of either 4 or 5 weeks, and the actual data will be entered by week. My thought is each row of the table...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top