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)
Thanks for the kind words, vvhg. The importer is merely a helper tool. What is the useful thing here is the journal ant it's statistics itself.
As for the migration, this is precisely what I would like to have. Two button clicks (load old, click import).
It is work in progress:-)) I am not promising any deadline though.
OK, I found out why the old journal is visible while migrating. To make it invisible, I would have to create an other instance of excel and open it there. As this slows down the process a lot, I will leave it as is....
That's more or less what I do with the journal, while trading I only enter 'thoughts', 'grades' and if I didn't follow my rules the 'followed rules' field as well. All the rest comes later...
So every tool where I had to enter more than that would actually slow me down...
If you can make it quicker than that, I'm all yours.
Perhaps we could make extensive use of the tab or enter key(jump from field to field and after last field save and jump to field1 of next entry)
....and stick in predefined values (the most likely ones), like grades or followed rules so you could frequently jump these fields...
Sounds perfect. So if you write the importer in a way that I can call it with all desired settings from within excel, we would be very close.
Ideally you would press a button in excel, choose to edit settings or not (I think we would need that...also to set them initially and there might always be a reason to change that), choose file dialog pops up, select, done.
By all means I would try to avoid working with Microsoft API for excel. I used to use it a couple of years ago. It is badly designed, inefficient, slow and one has to be very careful not to run in some memory leak.
:-(
This is where I admire your patience to play with the VBA macros...
Another thought; a new data grid / form within NT could be created and setup with the exact data fields and format you need. Then have it form export the data to CSV file. After that a import function could be created in excel that would populate the fields in the journal with the data.