Forum Discussion
Excel formulas not calculating
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...
See the attached workbook; I removed the protection. Be careful - it is now easy to mess things up.
You should be able to change values in for example column D or column I, and see column M change.
- 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. That looks to me as if it was created for options trading: is that right?
In any event, since you're having trouble with it anyway, why not create your own? Create it to do your own tracking as you want it to. If you're still relatively speaking a beginner with Excel, one of the best ways to learn Excel is to create a spreadsheet that tracks something you care about. Come here to ask for help if you come up against a wall of some kind. But tracking options trades -- I do it too -- is relatively easy.
I'm afraid I cannot help with this - I have no idea what the formulas should do...