Export and reimport trades from ONE using Excel

S

Stephane

Member
I found a way to export, but especially to re-import the transactions made with ONE. I use an Excel template, always the same, to build my import file which will be of "Interactive Brokers Flex Query" type.

I made a Youtube tutorial (and a new channel!) that shows you how to do it:

Now we will be able to exchange our trades to better understand our ways of trading! :)

Attached is the Excel template I use in the video to build the ONE import file.
 

Attachments

Stephane, excellent job!

It is very unfortunate that ONE does not have those options included.
Mechanism you described can be used to share trades between users of ONE, but also, with some modifications, to share trades between ONE and other platforms - which may be very practical and helpful. A better way of sharing full history of a trade. Better than just by pics (which has it's value as well, off course).

The workflow you described can be seen as quite complicated, you may want to write some VBA scripts to automate some steps.

If you want to develop this method/workflow farther and are interested in cooperation - let me know.
 
Thank you @Marcas,

Writing a web application that is capable of converting One Export file to one of the supported import format used by ONE is something i have the ability to do. That's the way I would choose rather than a VBA script. And we could see if we could join our expertises ;).

I will see if people use my Excel template and see how it goes. If no one has interest in this, I'll do nothing. But if there is an interest, here are my plan:

The Excel file is dependant of the columns you choose to export (in ONE) and the order in which you place them. The Excel template formulas depends of the choice of every user. This is why I explain how each of the columns are built to help people make their own template.

If I'd write a VBA Script or an application, it would be capable of reading the header row of the exported ONE file to know what information is in each of the columns. It would be generic and the end user could export the columns in the order they choose, the program would work in every case.
 
Yes, I found the IB file format pretty simple :).

It is very difficult to find documentation on internet about the format of all these input files. ONE doesn't give enough details on these formats in its documentation. We can find the name of the fields we need but not how they should be formatted. And they don't detail all the formats below.

Import Settings Files format


If I go further in this project of converting to any format, I would need examples of others files format from this community ;). But that's later on.
 
Stephane, we are on the same page regarding Excel. This is rather not the way to go but can be a start and point of experimenting.

I think your plan is sound. Find if there is interest first, then do a liitle, then gather feedback, add more functionality, and so on.
I jumped from assumption that such app would be in demand. Was wrong with those assumptions often...

If you move on... I have some ideas that seems interesting (at least to me...) but wait with them for later.
I do not have ONE anymore. In the past I did some Py code to automatically convert TOS files (or TOS-like) ONE import. Code wasnt quite finished because I lost interest in developing it. There was some issue with monthly expirations - if I'm not mistaken ONE marked them in specific way - don't really remembr now. I can dig it out (I hope). I didn't try to work with other sources.

I think IB and TOS are most popular out there. Other formats can be added, if there is such demand. Add to this OptionVue (if possible) and your app can became an universal trade-format converter... :)

Find out if there is real interest and later, if you wish, I can share my experience. Be glad if you drop a note about progress of this project from time to time.

All the best.
 
Yes! A universal converter would be good! I have other cool ideas of what we could do. Ok let's keep interest in this ;)
 
Stick to the plan and find if there is real interest :)
Unless you want to do it anyway :D
Project can be a rather simple or grow to full blown app with graphs and other functionalities...
What lang are you planning to use (as primary at least)?
 
Thanks. I'm unfamiliar with this one. Actually I had to goggle it :) Not sure what are the deployment options with PL/SQL but you know what you are doing.
I do think that ONE-IB converter, even if in minimal form, will be welcome by traders. You can add a lot of functionality to it even to the point that ONE wont be necessary.
In the past I'd would jump right in into the project but I've learned that what I think does not always reflect reality. Even if you see posts looking for this type of functionality here and there it does not mean that there is high demand for it or even any demand beside individual cases.
If you decide to go, as I said before, I be happy if you post smth about project development.
 
You must log in or register to reply here.
Top
Contact Us