<- Back to Tasks

Entry/exit data to .csv



Hello


Entry/exit indicators fall off when downloaded to a .csv. More specifically, only the first indicator is downloaded to the .csv when prompted. 


Please see the attached file for clarification. For example, for the first system, the indicators used are EMA, momentum, and SMA. Out of these, only EMA made it to the .csv. The same issue holds true for all following systems as illustrated on the pic. 


Would appreciate a fix. 


Thanks.

Attachments
copy to csv falling off.png
copy to csv falling off.png
(25.08 KiB)
  • Votes +1
  • Project StrategyQuant X
  • Type Bug
  • Status Fixed
  • Priority Normal

History

AE
#1

Phronesis

02.09.2019 11:17

Task created

AE
#2

Phronesis

02.09.2019 11:17
Voted for this task.
TT
#3

Tamas

02.09.2019 12:31

Status changed from New to Waiting for information

Attachment data.jpg added

It works for me. Please open the file in some text editor and make sure that the data are not there.


If the data are really missing please send me the csv and the problematic strategies to fix it.

AE
#4

Phronesis

02.09.2019 12:57

Attachment csv problem entries exits.csv added

The data is missing. Attaching .csv.
AE
#5

Phronesis

02.09.2019 13:07

Attachment Strategy 1 entryexit etc.sqx added

Attached example strategy. All my strategies have the same issue.


TT
#6

Tamas

02.09.2019 13:08

Status changed from Waiting for information to Fixed

Attachment the data are there.jpg added

Attachment text import office.jpg added

No, the data are there.  See the attachments


You need to set correct settings while you importing the data to your office app

especially semicolon separator and quoted texts

AE
#7

Phronesis

02.09.2019 13:17
Sorry, I do see this now. 


Really weird - in the raw .csv file, this data disappears. So separators etc won't matter, because the data is simply gone. But if opened as .txt the data is there!

TT
#8

Tamas

02.09.2019 13:21
I still believe that you just need to set the correct settings.


What app do you use to open csv files exactly ? 

AE
#9

Phronesis

02.09.2019 13:31

Attachment csv raw data.png added

Only excel. And when I do so, only the first indicator makes the cut. See screenshot with unformatted data (ie before separators etc). The data looks like it has been cut off.
TT
#10

Tamas

02.09.2019 13:42
second step.. choose semicolon as delimiter and uncheck comma, text qualifier set to " (Quotation mark)


then it will work



AE
#11

Phronesis

02.09.2019 14:01
I realize that this is not a SQ issue, so first of all thanks for your help.


Also, following the steps above makes no difference unfortunately. The entries are already missing in the first step, so it makes no difference what you do in the second step I'm afriad (since the data isn't there per the screenshot).


Really weird... unless I am missing something very obvious.


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