Forum Discussion
Excel formulas not calculating
- Nov 05, 2023
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...
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...
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.