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

    • SWI SolarWinds stock attempting to move higher off the 11.59 triple+ support area, https://stockconsultant.com/?SWI
    • SOUN SoundHound AI stock watch for upside break of the short term downtrend, https://stockconsultant.com/?SOUN
    • MYGN Myriad Genetics stock attempting to move higher off the 22.28 support area, https://stockconsultant.com/?MYGN
    • ISRG Intuitive Surgical stock beautiful breakout, from Stocks To Watch, https://stockconsultant.com/?ISRG
    • Date: 5th June 2024. US Job Vacancies Fall to Their Lowest Level In 3 Years.     US Job Vacancies fell to their lowest level in more than 3 years adding to fears of economic contraction. This week US PMI data falls and there are now lower job vacancies. Has the US economy passed its peak and is now in a downfall? Analysts advise if bond yields drop below 4.300%, yields can fall as low as 4.00% in the near term. Stocks rise to a weekly high as investors predict earlier rate hikes. A pause in September has fallen to a 35.00% possibility (5.00% lower) according to the Chicago Exchange. USA500 – US Job Vacancies Fall to Their Lowest Level In 3 Years! The SNP500 on Tuesday struggled due to poor investor sentiment and fear of economic slowdown. However, the price rose due to the latest US JOLTS Job Openings which shows less job vacancies within the US economy. This is due to investors changing their view on future interest rate cuts. Investors are evaluating whether the poorer economic data will tempt the Federal Reserve to lower rates, which supports the economy and makes stocks more attractive. However, analysts advise a strong stock market needs a balance between the economy and monetary policy. If investors fear a recession, shareholders may opt to lower exposure to the stock market regardless of lower interest rates. In order to monitor investor sentiment, the market will continue to monitor the VIX which has risen over the past week. In addition to this, investors will also monitor if the High Low Index falls from recent highs. The JOLTS Job Openings has fallen from 8.49 million to 8.06 million and is 700,000 lower than the 6-month average. Investors will now give more importance to today’s ADP Employment Change and tomorrow’s Weekly Unemployment Claims. If both also significantly fall, stocks can gain upward momentum due to potentially lower rates or can collapse on recession fears. This will also depend on today’s ISM Services PMI. Analysts advise investors will ideally want to see lower employment data and a positive PMI or visa versa. We can see here there is a thin line between lower rates and a harsh landing. Over the past week bond yields have significantly fallen which is positive for the stock market. However, the 10-Year Treasuries are 0.013% lower now. If bond yields fall below 4.300%, the yields can fall as low as 4.000% which is known to be positive for stocks in general. Oil prices have fallen almost 9% in 5-days which could also improve sentiment and weaken inflation over the next 2-months. European stocks open higher as we approach the European Cash Open. However, investors will monitor the price movement after the US news releases. The SNP500’s price is currently trading above the main sentiment lines and Moving Averages which is a positive indication. Now the price is slightly lower but if it rises above $5,306.83 without forming a lower low beforehand, buy signals will become stronger.   USDJPY – The Japanese Yen Witnesses The Largest Currency Decline! The day’s worst performing currency is the Japanese Yen while the best performing is the US Dollar. Even though the US Dollar is being pressured by a higher chance of lower rates, the Fed’s policy is still more competitive than most Central Banks. In addition to this, the Dollar’s safe haven element may also play a part. The exchange rate is witnessing buy signals on most indicators, but technical analysts are cautious after already seeing a 0.72% climb this morning.   Bank of Japan (BoJ) Deputy Governor Ryozo Himino stated today that officials should closely monitor yen movements due to their potential significant impact on the national economy. Consequently, currency weakness will be a crucial factor in deciding the timing and extent of the next increase in borrowing costs. BoJ Governor Kazuo Ueda also emphasized that the regulator’s primary objective is to allow the market to set long-term interest rates while retaining the capability to scale back large-scale bond purchases in the short term. Always trade with strict risk management. Your capital is the single most important aspect of your trading business. Please note that times displayed based on local time zone and are from time of writing this report. Click HERE to access the full HFM Economic calendar. Want to learn to trade and analyse the markets? Join our webinars and get analysis and trading ideas combined with better understanding on how markets work. Click HERE to register for FREE! Click HERE to READ more Market news. Michalis Efthymiou Market Analyst HFMarkets Disclaimer: This material is provided as a general marketing communication for information purposes only and does not constitute an independent investment research. Nothing in this communication contains, or should be considered as containing, an investment advice or an investment recommendation or a solicitation for the purpose of buying or selling of any financial instrument. All information provided is gathered from reputable sources and any information containing an indication of past performance is not a guarantee or reliable indicator of future performance. Users acknowledge that any investment in FX and CFDs products is characterized by a certain degree of uncertainty and that any investment of this nature involves a high level of risk for which the users are solely responsible and liable. We assume no liability for any loss arising from any investment made based on the information provided in this communication. This communication must not be reproduced or further distributed without our prior written permission.
×
×
  • Create New...

Important Information

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