<- Back to Tasks

Cannot read MT4 history files for analysis

Cannot read saved and downloaded MT4 historyfiles from live running tradingsystems. Stops with error, this is the log:



13:10:53.322 [SwingWorker-pool-2-thread-6] INFO  DateTimeParser - Date format recognized "yyyy.MM.dd HH:mm:ss"
13:10:55.119 [SwingWorker-pool-2-thread-6] ERROR StatsComputer - Failed to compute stats for combination: stats[direction:long|pl:$|sample:all|special:-], message: Unsolved dependency detected. Missing values required by some other snippet:
NumberOfProfits
NumberOfLosses
NumberOfProfits
NumberOfLosses
TotalTradingDays
TotalTradingMonths
TotalTradingYears
AvgTradesPerMonth
CAGR
AvgLoss
NumberOfTrades
AvgTradesPerMonth
TotalTradingDays
TotalTradingMonths
TotalTradingYears
AvgLoss
NumberOfTrades
AvgTradesPerMonth
AvgTrade
ZScore
AvgTrade


The problem could be either circular dependency (A depends on B, B depends on C, C depends on A)
or missing / uncompiled stats value snippet. Check if all the StatValues snippets were successfuly compiled.
java.lang.Exception: Unsolved dependency detected. Missing values required by some other snippet:
NumberOfProfits
NumberOfLosses
NumberOfProfits
NumberOfLosses
TotalTradingDays
TotalTradingMonths
TotalTradingYears
AvgTradesPerMonth
CAGR
AvgLoss
NumberOfTrades
AvgTradesPerMonth
TotalTradingDays
TotalTradingMonths
TotalTradingYears
AvgLoss
NumberOfTrades
AvgTradesPerMonth
AvgTrade
ZScore
AvgTrade


The problem could be either circular dependency (A depends on B, B depends on C, C depends on A)
or missing / uncompiled stats value snippet. Check if all the StatValues snippets were successfuly compiled.
at com.strategyquant.core.stats.StatsComputer.computeStatValues(StatsComputer.java:213) [QuantAnalyzer4.exe:na]
at com.strategyquant.core.stats.StatsComputer.computeStatValues(StatsComputer.java:218) [QuantAnalyzer4.exe:na]
at com.strategyquant.core.stats.StatsComputer.computeStatValues(StatsComputer.java:218) [QuantAnalyzer4.exe:na]
at com.strategyquant.core.stats.StatsComputer.computeForCombination(StatsComputer.java:163) [QuantAnalyzer4.exe:na]
at com.strategyquant.core.stats.StatsComputer.computeAllCombinations(StatsComputer.java:110) [QuantAnalyzer4.exe:na]
at com.strategyquant.lib.results.SQResultsGroup.computeResultsStats(SQResultsGroup.java:277) [QuantAnalyzer4.exe:na]
at com.strategyquant.lib.results.SQResultsGroup.computeResultsStats(SQResultsGroup.java:261) [QuantAnalyzer4.exe:na]
at com.strategyquant.plugin.Loader.EAALoaderClass.finishLoad(EAALoaderClass.java:67) [QuantAnalyzer4.exe:na]
at com.strategyquant.plugin.Loader.core.ReportLoader.finishLoad(ReportLoader.java:133) [QuantAnalyzer4.exe:na]
at com.strategyquant.plugin.Loader.core.ReportLoader.loadFile(ReportLoader.java:108) [QuantAnalyzer4.exe:na]
at com.strategyquant.plugin.Loader.core.ReportLoaderDialog$Importer.doInBackground(ReportLoaderDialog.java:123) [QuantAnalyzer4.exe:na]
at com.strategyquant.plugin.Loader.core.ReportLoaderDialog$Importer.doInBackground(ReportLoaderDialog.java:1) [QuantAnalyzer4.exe:na]
at javax.swing.SwingWorker$1.call(SwingWorker.java:295) [na:1.8.0_31]
at java.util.concurrent.FutureTask.run(FutureTask.java:266) [na:1.8.0_31]
at javax.swing.SwingWorker.run(SwingWorker.java:334) [na:1.8.0_31]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [na:1.8.0_31]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [na:1.8.0_31]
at java.lang.Thread.run(Thread.java:745) [na:1.8.0_31]
13:10:55.134 [SwingWorker-pool-2-thread-6] ERROR EAALoaderClass - Failed to load report. Exc: 
java.lang.Exception: Failed to compute stats for combination: stats[direction:long|pl:$|sample:all|special:-], message: Unsolved dependency detected. Missing values required by some other snippet:
NumberOfProfits
NumberOfLosses
NumberOfProfits
NumberOfLosses
TotalTradingDays
TotalTradingMonths
TotalTradingYears
AvgTradesPerMonth
CAGR
AvgLoss
NumberOfTrades
AvgTradesPerMonth
TotalTradingDays
TotalTradingMonths
TotalTradingYears
AvgLoss
NumberOfTrades
AvgTradesPerMonth
AvgTrade
ZScore
AvgTrade


The problem could be either circular dependency (A depends on B, B depends on C, C depends on A)
or missing / uncompiled stats value snippet. Check if all the StatValues snippets were successfuly compiled.
at com.strategyquant.core.stats.StatsComputer.computeForCombination(StatsComputer.java:168) ~[QuantAnalyzer4.exe:na]
at com.strategyquant.core.stats.StatsComputer.computeAllCombinations(StatsComputer.java:110) ~[QuantAnalyzer4.exe:na]
at com.strategyquant.lib.results.SQResultsGroup.computeResultsStats(SQResultsGroup.java:277) ~[QuantAnalyzer4.exe:na]
at com.strategyquant.lib.results.SQResultsGroup.computeResultsStats(SQResultsGroup.java:261) ~[QuantAnalyzer4.exe:na]
at com.strategyquant.plugin.Loader.EAALoaderClass.finishLoad(EAALoaderClass.java:67) ~[QuantAnalyzer4.exe:na]
at com.strategyquant.plugin.Loader.core.ReportLoader.finishLoad(ReportLoader.java:133) [QuantAnalyzer4.exe:na]
at com.strategyquant.plugin.Loader.core.ReportLoader.loadFile(ReportLoader.java:108) [QuantAnalyzer4.exe:na]
at com.strategyquant.plugin.Loader.core.ReportLoaderDialog$Importer.doInBackground(ReportLoaderDialog.java:123) [QuantAnalyzer4.exe:na]
at com.strategyquant.plugin.Loader.core.ReportLoaderDialog$Importer.doInBackground(ReportLoaderDialog.java:1) [QuantAnalyzer4.exe:na]
at javax.swing.SwingWorker$1.call(SwingWorker.java:295) [na:1.8.0_31]
at java.util.concurrent.FutureTask.run(FutureTask.java:266) [na:1.8.0_31]
at javax.swing.SwingWorker.run(SwingWorker.java:334) [na:1.8.0_31]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [na:1.8.0_31]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [na:1.8.0_31]
at java.lang.Thread.run(Thread.java:745) [na:1.8.0_31]
Caused by: java.lang.Exception: Unsolved dependency detected. Missing values required by some other snippet:
NumberOfProfits
NumberOfLosses
NumberOfProfits
NumberOfLosses
TotalTradingDays
TotalTradingMonths
TotalTradingYears
AvgTradesPerMonth
CAGR
AvgLoss
NumberOfTrades
AvgTradesPerMonth
TotalTradingDays
TotalTradingMonths
TotalTradingYears
AvgLoss
NumberOfTrades
AvgTradesPerMonth
AvgTrade
ZScore
AvgTrade


The problem could be either circular dependency (A depends on B, B depends on C, C depends on A)
or missing / uncompiled stats value snippet. Check if all the StatValues snippets were successfuly compiled.
at com.strategyquant.core.stats.StatsComputer.computeStatValues(StatsComputer.java:213) ~[QuantAnalyzer4.exe:na]
at com.strategyquant.core.stats.StatsComputer.computeStatValues(StatsComputer.java:218) ~[QuantAnalyzer4.exe:na]
at com.strategyquant.core.stats.StatsComputer.computeStatValues(StatsComputer.java:218) ~[QuantAnalyzer4.exe:na]
at com.strategyquant.core.stats.StatsComputer.computeForCombination(StatsComputer.java:163) ~[QuantAnalyzer4.exe:na]
... 14 common frames omitted
13:10:55.150 [SwingWorker-pool-2-thread-6] ERROR StrategyReportsLoader - Failed to load report Y:\Dropbox\Calmus boekhouding\2018\Overzichten\History Calmus 10% 2100173965 20170206-20180731.htm
com.strategyquant.lib.loader.LoadException: Failed to load report. Exc: Failed to compute stats for combination: stats[direction:long|pl:$|sample:all|special:-], message: Unsolved dependency detected. Missing values required by some other snippet:
NumberOfProfits
NumberOfLosses
NumberOfProfits
NumberOfLosses
TotalTradingDays
TotalTradingMonths
TotalTradingYears
AvgTradesPerMonth
CAGR
AvgLoss
NumberOfTrades
AvgTradesPerMonth
TotalTradingDays
TotalTradingMonths
TotalTradingYears
AvgLoss
NumberOfTrades
AvgTradesPerMonth
AvgTrade
ZScore
AvgTrade


The problem could be either circular dependency (A depends on B, B depends on C, C depends on A)
or missing / uncompiled stats value snippet. Check if all the StatValues snippets were successfuly compiled.
at com.strategyquant.plugin.Loader.EAALoaderClass.finishLoad(EAALoaderClass.java:75) ~[QuantAnalyzer4.exe:na]
at com.strategyquant.plugin.Loader.core.ReportLoader.finishLoad(ReportLoader.java:133) ~[QuantAnalyzer4.exe:na]
at com.strategyquant.plugin.Loader.core.ReportLoader.loadFile(ReportLoader.java:108) ~[QuantAnalyzer4.exe:na]
at com.strategyquant.plugin.Loader.core.ReportLoaderDialog$Importer.doInBackground(ReportLoaderDialog.java:123) [QuantAnalyzer4.exe:na]
at com.strategyquant.plugin.Loader.core.ReportLoaderDialog$Importer.doInBackground(ReportLoaderDialog.java:1) [QuantAnalyzer4.exe:na]
at javax.swing.SwingWorker$1.call(SwingWorker.java:295) [na:1.8.0_31]
at java.util.concurrent.FutureTask.run(FutureTask.java:266) [na:1.8.0_31]
at javax.swing.SwingWorker.run(SwingWorker.java:334) [na:1.8.0_31]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [na:1.8.0_31]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [na:1.8.0_31]
at java.lang.Thread.run(Thread.java:745) [na:1.8.0_31]
Caused by: java.lang.Exception: Failed to compute stats for combination: stats[direction:long|pl:$|sample:all|special:-], message: Unsolved dependency detected. Missing values required by some other snippet:
NumberOfProfits
NumberOfLosses
NumberOfProfits
NumberOfLosses
TotalTradingDays
TotalTradingMonths
TotalTradingYears
AvgTradesPerMonth
CAGR
AvgLoss
NumberOfTrades
AvgTradesPerMonth
TotalTradingDays
TotalTradingMonths
TotalTradingYears
AvgLoss
NumberOfTrades
AvgTradesPerMonth
AvgTrade
ZScore
AvgTrade


The problem could be either circular dependency (A depends on B, B depends on C, C depends on A)
or missing / uncompiled stats value snippet. Check if all the StatValues snippets were successfuly compiled.
at com.strategyquant.core.stats.StatsComputer.computeForCombination(StatsComputer.java:168) ~[QuantAnalyzer4.exe:na]
at com.strategyquant.core.stats.StatsComputer.computeAllCombinations(StatsComputer.java:110) ~[QuantAnalyzer4.exe:na]
at com.strategyquant.lib.results.SQResultsGroup.computeResultsStats(SQResultsGroup.java:277) ~[QuantAnalyzer4.exe:na]
at com.strategyquant.lib.results.SQResultsGroup.computeResultsStats(SQResultsGroup.java:261) ~[QuantAnalyzer4.exe:na]
at com.strategyquant.plugin.Loader.EAALoaderClass.finishLoad(EAALoaderClass.java:67) ~[QuantAnalyzer4.exe:na]
... 10 common frames omitted
Caused by: java.lang.Exception: Unsolved dependency detected. Missing values required by some other snippet:
NumberOfProfits
NumberOfLosses
NumberOfProfits
NumberOfLosses
TotalTradingDays
TotalTradingMonths
TotalTradingYears
AvgTradesPerMonth
CAGR
AvgLoss
NumberOfTrades
AvgTradesPerMonth
TotalTradingDays
TotalTradingMonths
TotalTradingYears
AvgLoss
NumberOfTrades
AvgTradesPerMonth
AvgTrade
ZScore
AvgTrade


The problem could be either circular dependency (A depends on B, B depends on C, C depends on A)
or missing / uncompiled stats value snippet. Check if all the StatValues snippets were successfuly compiled.
at com.strategyquant.core.stats.StatsComputer.computeStatValues(StatsComputer.java:213) ~[QuantAnalyzer4.exe:na]
at com.strategyquant.core.stats.StatsComputer.computeStatValues(StatsComputer.java:218) ~[QuantAnalyzer4.exe:na]
at com.strategyquant.core.stats.StatsComputer.computeStatValues(StatsComputer.java:218) ~[QuantAnalyzer4.exe:na]
at com.strategyquant.core.stats.StatsComputer.computeForCombination(StatsComputer.java:163) ~[QuantAnalyzer4.exe:na]
... 14 common frames omitted

Attachments
No attachments
  • Votes 0
  • Project StrategyQuant X
  • Type Bug
  • Status Refused
  • Priority Normal

History

g
#1

gcraenen

01.08.2018 13:15

Task created

MF
#2

Mark Fric

02.08.2018 09:30

Status changed from New to Waiting for information

what is the error exactly? You write that you cannot read saved and downloaded MT4 historyfiles from live running tradingsystems, but what do you mean?


What kind of files are you trying to read? Do you want to import history data from MT4?


Please attach an example of the file and describe what exactly you want to do.

g
#3

gcraenen

08.08.2018 13:12

Attachment History Calmus 5 2100175199 20180801.htm added

I export the trade history from MT4 and save it as a report (not detailed report). The exported HTML-file is loaded in quant analyzer, an example is added. Quant analyzer cannot process this file and throws the mentioned errors.
MF
#4

Mark Fric

10.08.2018 14:41
toto je task ku QA, nie k SQ. Prosim ta vytvor novy task v projekte QA a prekopiruj tam tu chybu aj prilozeny report. ja to v rychlosti teraz nestiham. 


Tento task potom oznac ako refused.

TT
#5

Tamas

21.08.2018 16:19

Status changed from Waiting for information to Refused

Task is related to QA here

https://roadmap.strategyquant.com/tasks/qa4_0046

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