Forum Discussion
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
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...
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?
- Johnny490Copper Contributor
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.
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).
- Johnny490Copper 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.- mathetesSilver 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...
- Johnny490Copper 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.