Jump to content

Welcome to the new Traders Laboratory! Please bear with us as we finish the migration over the next few days. If you find any issues, want to leave feedback, get in touch with us, or offer suggestions please post to the Support forum here.

  • Welcome Guests

    Welcome. You are currently viewing the forum as a guest which does not give you access to all the great features at Traders Laboratory such as interacting with members, access to all forums, downloading attachments, and eligibility to win free giveaways. Registration is fast, simple and absolutely free. Create a FREE Traders Laboratory account here.

CTMAN

Calculations on Contracts

Recommended Posts

I have a few questions on some calculations I am using in an excel I am creating.

 

How do I figure out the:

 

Expected gross profit

Expected net Profit

Realized trade fees

 

I have attached a spreadsheet with the data that I have. Could someone please take a look and provide me with how to calculate this data so that I can convert it to VBA and automate.

 

I need the calculations per product not overall.

 

Thanks.

traderslab.xls

Share this post


Link to post
Share on other sites
The issue I am having is calculation assuming I close any open position at the provided settlement prices.

 

No one knows how to calculate the above formulas?

 

 

No one replied because your question is either ridiculously simple, or not clear. It appears that you ask how to calculate your profit/loss when you close a position. Do you really not know how to calculate that? This is just basic math. If you buy/short something for x and sell/cover it for y, your gross profit/loss is the difference between x and y. Your net is your gross minus whatever trading costs you have incurred, commissions for example.

Share this post


Link to post
Share on other sites

I know how to calculate my P&L but if you looked at my spreadsheet and subsequent comments you can see that I am having an issue not just with my P&L but with my expected gross profit and net profit by assuming I close any open position at the provided settlement price (J3:J6 in the excel I provided.

Share this post


Link to post
Share on other sites

Sorry, I don't open Excel or Word documents from unkown sources on the internet. Sounds however that you already know the definitions which you asked about, but need some help to calculate that in Excel. You might be better off asking for help on that in an Excel forum.

 

However, I don't see the difference between using the settlement price or any other random price you pull out of thin air. The formula to calculate your P/L is the difference between your opening and closing price, regardless of where the closing price comes from.

Share this post


Link to post
Share on other sites

I know the definition but If you look at the excel file you will understand what I am asking...

 

If I knew how to calculate it I could write the excel easily.

 

Anyone who "opens" excel files have an idea?

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Topics

  • Posts

    • I'm still a dove regarding crypto trading. Not because of the instruments traded, but because of the lack of market centralization. It reminds me of the early days of forex trading where no broker-dealers offered trade clearing via the interbank market. This is basically betting against "the house" which is its own captive market-maker, has its own one-off price feed, and has its own one-off trade execution policies. As a side note, I always opt out of broker-dealers' arbitration clauses within 30 days of account opening pursuant to the U.S. Federal Arbitration Act. Unscrupulous broker-dealers and platform sellers don't even provide opt-out terms in their trading/subscription agreements, but it still exists pursuant to federal statutes and federal court precedent. Sierra Chart also collects unspent platform subscription deposits from traders in their website's online "wallet." This subjects them not only to FINRA liability but CFPB liability as well. I figuratively atom bombed Sierra Chart with this info and they refunded all platform fees and data fees that I ever paid to them before I closed my Sierra Chart account. On a more general note, virtually all broker-dealers are either partnered with, or straight up are, Wall Street investment banks and hedge funds. These are the folks that refer to retail traders as "cannon fodder" and "fish food." To me, any broker-dealer is nothing more than a counterparty to a series of my transactions. If I find any reason not to trust a broker-dealer, I'm out. Crypto trading, as it presently exists, fits the bill. Crypto owning/investment might be a different story, but I'm strictly a trader.
    • Consider this... While a human trader has emotions, a bot does not. All a human trader needs to do to code a statistically profitable strategy on a good emotional day. And it can be coded for any timeframe, intraday or overnights.
    • Well said. Broker-dealers that aren't connected to centralized exchanges or the prime interbank exchanges are, in fact, casinos--where nothing extends beyond "the house."
    • My latest trick... After successfully live trading forex for years, switch to trading futures in the U.S. Chicago Mercantile Exchanges. Futures spreads are generally 1 or 2 ticks with no swaps, and data fees and commission fees are fixed. As a caveat, leverage changes throughout every day based on international sessions, so this is not for small accounts. 
    • @analyst75, I am just dying for you to write a sequel... Why Some Young People Prefer to Live Alone.😂
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.