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,...
  • 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...

     

     

Resources