Failed to compute Open Balances

This is the error message that I'm asked to report to you:



java.lang.Exception: Failed to load data. Reason: 1
at com.strategyquant.plugin.Analyzer.impl.OpenBalances.logic.DataLoader.readData(DataLoader.java:61)
at com.strategyquant.plugin.Analyzer.impl.OpenBalances.logic.DataLoader.load(DataLoader.java:89)
at com.strategyquant.plugin.Analyzer.impl.OpenBalances.logic.OpenBalancesTask.loadSymbolsData(OpenBalancesTask.java:321)
at com.strategyquant.plugin.Analyzer.impl.OpenBalances.logic.OpenBalancesTask.doInBackground(OpenBalancesTask.java:107)
at com.strategyquant.plugin.Analyzer.impl.OpenBalances.logic.OpenBalancesTask.doInBackground(OpenBalancesTask.java:44)
at javax.swing.SwingWorker$1.call(SwingWorker.java:295)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at javax.swing.SwingWorker.run(SwingWorker.java:334)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
Caused by: java.lang.ArrayIndexOutOfBoundsException: 1
at com.strategyquant.plugin.Analyzer.impl.OpenBalances.logic.DataLoader.readData(DataLoader.java:44)
... 10 more


It was generated when I tried to compute Open Balances for a strategy that runs on 5 pairs. The M1 data were exported to the proper folder by StrategyQuant using Generic Bar (CSV) format.
The JAVA update on my computer is the latest available (just updated to the last version before I run the compute).


Yaron



Attachments
Attempt to compute Open Balances.png
(330.83 KiB)
  • Votes 0
  • Project QuantAnalyzer
  • Type Bug
  • Status Refused
  • Priority Low

History

d
#1

Yaron Lidor

08.05.2021 08:45

Task created

TT
#2

Tamas

28.06.2022 08:00

Status changed from New to Refused

To make it work you have to use data file in correct format date,time,o,h,l,c,v

eg. 

2006.01.03,02:01:00,0.85208,0.8522,0.85208,0.8522,8


If you still have a problem with loading the data please attach the problematic file.

TT
#3

Tamas

28.06.2022 08:11

Attachment image-0.png added

image-0.png
(715.50 KiB)
I just tried it with exported data from SQX and it works fine. One change was needed, the date format must be changed on SQX/Export dialog to yyyy.MM.dd.

Votes: 0

Drop files to upload

or

choose files

Max size: 5MB

Not allowed: exe, msi, application, reg, php, js, htaccess, htpasswd, gitignore

...
Wait please