external data

[nichjoht]

Chris,

I have a data file called QLD_B.csv that contains the columns as defined in the ASCII Text File Provider: Name, Symbol, Date, Open, High, Low, Close, Volume.

The data in the file has a header column and the second data line looks like this:
QLD Breath,QLD_B,7/11/2014,15,15,15,15,15
All the values for open, high, low, close, volume repeat because in reality this is the Breath Summation Data that I receive from a data service.

I also tried the workbook functions, but could not figure out how they work. What would be the best way to get this data into Edgerater?

- John

[Chris White]

Hi John,

Can you attach the file and I will take a look.

Thanks,
Chris.

[nichjoht]

I keep getting extension is not allowed, even if there is no extension.

The file has the name of QLD_B.csv, should it have a different extension?

The first few lines copied from the csv file are:
Name,Symbol,Date,Open,High,Low,Close,Volume
QLD Breath,QLD_B,7/10/2014,-5,-5,-5,-5,-5
QLD Breath,QLD_B,7/11/2014,15,15,15,15,15
QLD Breath,QLD_B,7/14/2014,57,57,57,57,57
QLD Breath,QLD_B,7/15/2014,29,29,29,29,29
QLD Breath,QLD_B,7/16/2014,46,46,46,46,46
QLD Breath,QLD_B,7/17/2014,-25,-25,-25,-25,-25
QLD Breath,QLD_B,7/18/2014,68,68,68,68,68
QLD Breath,QLD_B,7/21/2014,34,34,34,34,34
QLD Breath,QLD_B,7/22/2014,73,73,73,73,73
QLD Breath,QLD_B,7/23/2014,84,84,84,84,84

- John

[Chris White]

Okay, I'll try with that. BTW you can post it if you zip it up to a .zip file.

[nichjoht]

Chris,

attached is the zip file. It is a csv file of Breath data for the QLD etf.

I am trying to make a simple system that buys when the breath has risen for the past 3 days and sell when it drops one day.

- John

[dan2fl]

Hi,
You might try saving the CSV file to a TXT file by using a text editor such as Notepad.
I have found that Edgerater often does not accept a CSV file.
Dan