Reply

Import report from Multicharts RINA xml file

6 replies

Vincent

Subscriber, bbp_participant, community, 4 replies.

Visit profile

7 years ago #115850

I’m trying to get the analyzer to work with Multicharts reports. I’m using Chinese version(Taiwan), so first I try with excel format and it didn’t work. It shows such kind of exception.

TXF1  BBR-3.xls

– error loading using Multicharts loader – org.apache.poi.openxml4j.exceptions.InvalidFormatException: Package should contain a content type part [M1.13]
 
I think this maybe the excel have Chinese character inside, so I tried to export as xml file then import into the analyzer. But after I import the xml file, there is input box for point value, then I type 200 in that field.
Good, the result did import into analyzer. But the profit is far from the same with the origin price. So I check with list of trades. I found out the profit is calculated by point size 100 instead of 200. 
 
The other issue the open time is not get imported correctly, it always show 1970.
 
Attach the file I tested with analyzer.
 
How can I get this to work? Thanks for any advice.
 
Vincent
 

0

Tamas

Customer, bbp_participant, community, sq-ultimate, 73 replies.

Visit profile

7 years ago #140265

To load Multicharts report you need to import xls or  xlsx file (excel file) and not xml file.

 

Tomas

0

Vincent

Subscriber, bbp_participant, community, 4 replies.

Visit profile

7 years ago #140267

The issue is when I tried to import the xls file, there is an exception

 

TXF1  BBR-3.xls

– error loading using Multicharts loader – org.apache.poi.openxml4j.exceptions.InvalidFormatException: Package should contain a content type part [M1.13]

0

Tamas

Customer, bbp_participant, community, sq-ultimate, 73 replies.

Visit profile

7 years ago #140268

Please attach the report or send it to our email to reproduce the issue.

 

Tomas

0

Vincent

Subscriber, bbp_participant, community, 4 replies.

Visit profile

7 years ago #140277

Hello Tomas

 

          Thanks for reply. Here is the xls file export from Multicharts. Here is my environment

Multicharts 8.5 Chinese version.

Windows 7. 

Office 2003.

 

Thanks

Vincent

 

0

Tamas

Customer, bbp_participant, community, sq-ultimate, 73 replies.

Visit profile

7 years ago #140296

It works for me when I save the file as Excel xlsx instead of xls.

 

Tomas

0

Vincent

Subscriber, bbp_participant, community, 4 replies.

Visit profile

7 years ago #140328

Thanks, it works as charm when I converted as xlsx.

 

Vincent

0

Viewing 6 replies - 1 through 6 (of 6 total)