Forum Discussion

Johnny490's avatar
Johnny490
Copper Contributor
Nov 03, 2023
Solved

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,...
excel
Formulas and Functions
  • mathetes's avatar
    mathetes
    Nov 05, 2023

    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
Nov 03, 2023
Are you sure there's a password on it? I didn't put a password on it. When I go to the file and check access management, your name, Hans Vogelaar, is listed. Next to your name, it says 'can edit.' It should work fine, right? Otherwise, please let me know where I can find that password because I don't see it anywhere.
HansVogelaar's avatar
HansVogelaar
MVP
Nov 03, 2023

Johnny490 

This is what I see in the Review tab of the ribbon:

When I click Unprotect Sheet:

I don't know the password, obviously.

  • Johnny490's avatar
    Johnny490
    Copper Contributor
    Nov 04, 2023
    I took a look. I didn't personally create this Excel file. The admin doesn't know how to resolve this either, that's the reason i came to this forum.. He doesn't share the password. So, this means it's not possible. Are there any other options for me to resolve it on my own?
      • Johnny490's avatar
        Johnny490
        Copper Contributor
        Nov 05, 2023
        Huh, how did you manage to remove the protection?

        Anyway, it still doesn't work for me. When I enter my entry, stop loss, 1% risk, and finally my TP1, it still doesn't calculate my order size and number of contracts.

        From what I gather, it does calculate automatically for you? Not for me. Or maybe I misunderstood you. Yesterday, I ensured that my decimal symbol in the control panel matches the one in Excel options. But everything seems correct. What's odd is that other people use a comma in the P&NL collum, and I can use both points and commas, and both work for me. Could this be the issue? They all find it strange, and it shouldn't be like this.