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)
And I agree with your comments above. I think the summary stats are most useful when presented by PRODUCT and then by month within that PRODUCT. The separation might not be that important in the financials or the metals, but as you know, futures prices and implied volatility can be very different across a three or four month range in the ags or energies.
In your working version, what happens if you have Sugar transactions across three brokerage accounts? Can you still summarize by Sugar, i.e. irrespective of brokerage account?
Can you help answer these questions from other members on NexusFi?
Well essential you can have as many sections or headers as you like and have the same position listed in more than one section. It would be just an issue of managing it which is why thework in the interace and user interactivity. Make it a easy as possible to do complex things quickly. So you could have 3 brokerage accounts with all your trades and then headers by product, and on you could go...so one of the each things to do is to copy a trade and then past it multiple times in different locations. (in my file this is not a copy paste as you would do normally in excel...it is storing values to variables, reapplying them and then running trackselect or trackspread on each past refreshed.)
I'm just using the basic PC-SPAN program and for some reason I can no longer get it to calculate my margins. The data loads without an issue (files are the right size), but when I hit the calculate button nothing populates. Pretty sure it isn't the contract - I even tested front month regular ES futs to no avail. Tried rebooting the computer but no luck there.
Ever wonder why CME can't get out of 1991 and build some real software? Or perhaps just post their calcs on the website like ICE, LIFFE and everyone else
Trading: Primarily Energy but also a little Equities, Fixed Income, Metals, U308 and Crypto.
Frequency: Many times daily
Duration: Never
Posts: 5,059 since Dec 2013
Thanks Given: 4,410
Thanks Received: 10,226
Interestingly ICE have rewritten SPAN and now have their own version with is far easier to use and much more intuitive. It's also a lot easier to set up portfolio's and what if scenario's and to automate batch process's. The result files are also a lot easier to read.
Unfortunately it only works for ICE contracts though as it requires a new type of SPAN file (SP5 or SP6).
I had the same message over the weekend. The only way I got Avast to stop auto-deleting the Excel file was to put it in the exclusions list for the FileShield.
You can only put directory paths rather than a single file in the exclusions list. I reported it as a false positive to Avast, but so far their updates haven't taken that into account yet. Hopefully, it will resolve with some further definition updates from Avast.