Welcome to NexusFi: the best trading community on the planet, with over 150,000 members Sign Up Now for Free
Genuine reviews from real traders, not fake reviews from stealth vendors
Quality education from leading professional traders
We are a friendly, helpful, and positive community
We do not tolerate rude behavior, trolling, or vendors advertising in posts
We are here to help, just let us know what you need
You'll need to register in order to view the content of the threads and start contributing to our community. It's free for basic access, or support us by becoming an Elite Member -- see if you qualify for a discount below.
-- Big Mike, Site Administrator
(If you already have an account, login at the top of the page)
Glad it was a help to you. SOM is short option minimum and risk is the highest risk in the risk array scenarios. The highest of the two is used for calculating initial margin. Price is the settlement price... Bid and ask prices do not show up in the risk arrays. I should have a newer spreadsheet available soon that should be even faster.
Sent from my Nexus 5 using Tapatalk
Can you help answer these questions from other members on NexusFi?
The spreadsheet uses (premium / (IM * variable)) / DTE * 30. The variable should be cell o2 on the risk tab. I think it was set to 2 when I uploaded it.
Trading: Primarily Energy but also a little Equities, Fixed Income, Metals and Crypto.
Frequency: Many times daily
Duration: Never
Posts: 5,057 since Dec 2013
Thanks Given: 4,399
Thanks Received: 10,225
I would like to thank everybody who has contributed to that thread but especially @ron99 and @Dudetooth.
This thread is one of the most helpful and useful threads I've seen in years of watching forums like this.
Primarily because of this thread I have decided to upgrade to an elite membership (hoping there are other threads as valuable behind the elite gates.)
Thanks @ron99 and @Dudetooth again.
I downloaded v3 earlier today and so far, so good. I put in a couple of sample trades and a data date of Friday, January 17th and the results look right to me. So, a big thank you in advance because I think this tool can improve capital allocation and risk management and it's also a quick and easy way to compare which of my brokers is running at or close to SPAN. I know IB gets a bad rap from option sellers, and sometimes it's deserved; other times they are very close or lower than RJO, which seems to be fairly close to SPAN minimum).
Anyway, one question: I'm pretty sure I can change the cell formatting - fonts, text color, cell shading, column width, etc - without messing up any of your code behind the scenes, but what about conditional formatting? For example, if I enter a list of real positions, maybe I want all "Cs" (calls) to be in bold red text (cuz' that's where I usually get screwed) or maybe I want to color code (traffic light) the delta column for various ranges. Will conditional formatting screw anything up?
SMCJB, on the first one I have no idea. What browser are you using and is it running something when you are running the script?
On the second one I'm not sure either. I see you have the different elements in different folders. I have everything in one folder. The Bin folder. I do output reports to a different folder.
I use SaveCalcSummary. You are just using Save. I don't know if that is a problem.
I haven't used that utility in a few months, so I've forgotten quite a bit already. You batch and script look the same as the last versions I used. I set up a test and got the same error as your second (error saving the log). I still got the reports, but the rptBatch.log was not saved, nor the rptBatch.err. I'm pretty sure I had seen that error before, but I'm afraid I can't remember why it was happening or if I was able to fix it. CME's help file on it didn't really help other than to list the default locations where the reports and logs go.
If it were me, I'd just ignore the error ... your still getting the reports. Sorry, that probably wasn't much help either.