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...
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?
- Johnny490Nov 03, 2023Copper 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.
- HansVogelaarNov 03, 2023MVP
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).
- Johnny490Nov 03, 2023Copper ContributorAre you sure there's a password on it? I didn't put a password on it. When I go to the file and check access management, your name, Hans Vogelaar, is listed. Next to your name, it says 'can edit.' It should work fine, right? Otherwise, please let me know where I can find that password because I don't see it anywhere.