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)
If you see the resulting file it damages text in some header cells in journal tab. I am skipping them in the program so I have no idea why they look so bad.
The cells are formatted to show two lines even though there is just one cell. That is probably the issue.
Those which fit one line are not damaged by the import.
vvhg, could you please add in more instruments in the excel? I will then update the program with newer version.
im gunna go ahead and say that we should just add all the eminis, currencies, bonds, softs, metals, etc, otherwise will forever have requests.. here is another issue, maybe in your program @petrmac you can add an option to omit sim trades from the import to the journal?
dont believe anything you hear and only half of what you see
If you aren't backtesting, there is exactly the same grid in the Ninja control panel -> Account performance tab - > Trades tab.
Then use the same way to export the results as described earlier.
I'll try to change the format of those cells to sth more compatible, and if that is not possible, I will write a fix for that into the sheet VBA.
I could easily add loads of instruments, but there is one disadvantage: the manual selection in the corresponding instrument fields will take considerably more time if you use the drop down list (you have to scroll there).
If you type into these fields everything stays the same (I use Auto Fill, which makes life quite easy with the journal).
But I think this price we sure can pay, and users can always delete the symbols they don't need.
Shall I get the commissions from a broker or do you want me to leave them blank?
Could you both please revise your posts where you mention the symbols and see if the list is "complete"?
@madLyfe I'm not searching for all the symbols myself, forget it.
If you want all metals, bonds softs, minis and what not included, tell me at least the symbols (don't even think about posting a screenshot of all NT available instruments!), also could you post your current list so I can copy/paste that?
Well, it's actually not that hard to add an instrument, any below average excel user even without expert programming skills should manage....
You can omit them when you export the list: Account Performance > Advanced > deselect the sim accounts.
thanks that worked! things im noticing:
- for some reason the inputted date isnt taking on the journals formatting
- it is writing to the comment cells which should be user selectable like the method cells are..
- i dont think the 'minutes in the trade' in the trade are working properly.. if in a trade for under 1 minute should = 1 as well im thinking, just an idea..? my trades im testing were longer than 1min but showing 0 min.
- we are going to need some type of notification that alerts the user if they have already inputted those trades for us forgetful/clumsy traders..
im sure youve have already thought of this but cant you just have the inputter skip the top cells and start with row 3? im not a programmer so if that sounds to simple and dumb its prolly because it is..
and other than the top cells issue thats what im noticing right now..
after looking over it, NT uses the standard naming scheme for instruments as youd expect, 6E = 6E, CL = CL, etc.. we shouldnt actually need to add an overwhelming amount of instruments for people.. maybe just a few more of the common ones for people and everything should work as expected.. plus that can be towards the end of this once we get everything running smoothly..
dont believe anything you hear and only half of what you see