Forum Discussion

Johnny490's avatar
Johnny490
Copper Contributor
Nov 03, 2023

Excel formulas not calculating

Hi everyone,

I'm a trader and I use Excel for my trading journal. I'm currently facing an issue where Excel is not calculating my total contracts anymore. I input my entry price, stop loss, 1% risk, and take profit. Previously, Excel would automatically calculate the number of contracts I could use, but it's not doing that anymore. Any suggestions on what I can do to fix this issue?

My thoughts: I have a few lines where I only enter data for take profit 2 and trade 3. This shouldn't be causing the error, right? Additionally, I've attempted to resolve it by going to Formulas and changing the 'calculation options' to 'automatic,' but that doesn't seem to solve the problem.

Any guidance or advice would be much appreciated. Thanks!

Edit: It's the words:  Aantal contracten

  • Johnny490 

     

    to make it easier for myself, since you guys have more knowledge, which tutorial is the best for this situation to learn the specifics of Excel to create such a trading journal?

     

    Rather than a tutorial--Exceljet.net is a good resource (and it does have some  tutorials) for free references on various formulas and functions. What you're talking about for tracking options trades is mostly very basic, unless you get to the point of high level summaries of, say, a year's trades. But even that, if you design well, can be pretty basic.  There are many YouTube video tutorials on basic and advanced Excel techniques. And of course there are basic books. Any bookstore, or Amazon, can be a source of books.

     

    I'd begin with whatever you do on paper, just automating some aspects of it...

     

     

  • Johnny490 

    Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?

    • Johnny490's avatar
      Johnny490
      Copper Contributor

      HansVogelaar 

       

      First time using this method. Curious to see if it works. Since the file is currently vulnerable, I'll delete it once the issue is resolved. I suspect the file is meant to be online to investigate the issue. Otherwise, I'd appreciate an explanation of what you mean exactly. There arent much personal things here for me.

      • HansVogelaar's avatar
        HansVogelaar
        MVP

        Johnny490 

        Thanks, I was able to download the workbook (I'll delete it as soon as possible).

        The worksheet is protected by a password. Could you provide that password? If you'd rather not post it in public, you can send it to me in a private message (click on my user picture).

  • Johnny490's avatar
    Johnny490
    Copper Contributor

    Thanks, HansVogelaar, for all the help and time. I had hoped it was a small issue that might be easily resolved, but unfortunately.

    mathetes, thanks for the info. Indeed, I engage in options trading. I think I'll create my own trading journal in Excel. I found this one ideal, but unfortunately, it's having issues now. However, with some effort, I can make my own.

    I'm going to do some research on Google, but to make it easier for myself, since you guys have more knowledge, which tutorial is the best for this situation to learn the specifics of Excel to create such a trading journal? Thanks in advance.

    • mathetes's avatar
      mathetes
      Silver Contributor

      Johnny490 

       

      to make it easier for myself, since you guys have more knowledge, which tutorial is the best for this situation to learn the specifics of Excel to create such a trading journal?

       

      Rather than a tutorial--Exceljet.net is a good resource (and it does have some  tutorials) for free references on various formulas and functions. What you're talking about for tracking options trades is mostly very basic, unless you get to the point of high level summaries of, say, a year's trades. But even that, if you design well, can be pretty basic.  There are many YouTube video tutorials on basic and advanced Excel techniques. And of course there are basic books. Any bookstore, or Amazon, can be a source of books.

       

      I'd begin with whatever you do on paper, just automating some aspects of it...

       

       

      • Johnny490's avatar
        Johnny490
        Copper Contributor
        Just wanted to drop a quick note to say thanks for pointing me in the right direction regarding my Excel challenge. Your suggestions did the trick.

        Following your advice, I've set up a trading journal in Excel, automating some of the stuff I used to scribble down on paper. Thanks for taking the time to share your insights.

Resources