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...
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.
I'm afraid I cannot help with this - I have no idea what the formulas should do...