File format support for fund nav data

I have some fund's NAV, like strategy equity. 



Only date, and nav, 2 columns. QA can analyze it's max drawdown, MaxDrawDownDuration, and so on,


In particular, I want to calculate the correlation between the movements of the NAV of these funds.



First let QA recognize and import this kind of data, very simple data, just date and equity.



However, it should be noted that these fund NAV disclosure is not necessarily a fixed date, 


most of them are once a week,but not necessarily the same date. 


When comparing correlation, it is also necessary to consider the way of data filling or alignment.






nav sample.csv - error loading using ForexTester loader - Failed to parse order. Line: 2018-04-25,1 - error loading using ZuluTrade loader - Automatic detection of date format failed. Reason: Incorrect trade definition!? Line: 2018-04-25,1 - error loading using MetaStock loader - Automatic detection of date format failed. Reason: No trades found. - error loading using Myfxbook loader - Incorrect Myfxbook file or format unrecognized. Automatic detection of date format failed. Reason: Wrong file format. Different columns count. 2 < 15 - error loading using MT4ReportLoader - Loading CSV settings failed. Invalid values length. Expected: 14, got: 2 - error loading using NinjaTrader loader - Failed to parse order. Line: 2018-04-25,1 - error loading using GeneralCsv loader - Incorrect csv file or format unrecognized. Failed to parse order. Line: 2018-04-25,1 - error loading using FxBlue loader - Failed to parse order. Line: 2018-05-10,1.004 - error loading using Tradestation loader - Failed to load Tradestation report file: nav sample.csv - Loading CSV settings failed. Invalid values length. Expected: 12, got: 2


Attachments
nav sample.xlsx
(30.11 KiB)
  • Votes +1
  • Project QuantAnalyzer
  • Type Feature
  • Status New
  • Priority Low

History

e
#1

eastpeace

06.04.2023 16:09

Task created

E
#2

Emmanuel

20.12.2023 19:41
Voted for this task.

Votes: +1

Drop files to upload

or

choose files

Max size: 5MB

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

...
Wait please