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...
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.
- mathetesNov 05, 2023Silver Contributor
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...
- Johnny490Nov 13, 2023Copper ContributorJust 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.