Suggestion:
1. Instead of exporting from the Scanner (and other areas) to CSV, export directly to Excel format (or provide that option). The reason is the current CSV format is not parsed automatically by Excel using semicolins, which means there is an extra step required to import into Excel. Small change, but would be useful.
2. Also, it would be nice if the code used to generate the CSV results could also be exported so you could see what code generated the results. This could be done to a seperate CSV file, or in Excel, to a separate sheet.
// Variables to calculate and then plot the standard deviation of price from BB mean
varBBMeanLen = 30;
varBBMean = sma(varBBMeanLen);
varCloseMinusBBMeanArray = Close - varBBMean;
varStdDev = varCloseMinusBBMeanArray / stddev(Close);
// Filter based on variables
var1 = varATR_Pct > varMinATR_Pct;
var2 = varAvgVolume > 2000000;
var3 = Close > varMinPrice;
var4 = varStdDev > varStdDevMin;
// Display a few columns of data
AddColumn("ATR%", varATR_Pct);
AddColumn("AvgVolume",varAvgVolume);
AddColumn("BB Mean",varBBMean);
AddColumn("Close - BB Mean",varCloseMinusBBMeanArray);
AddColumn("StdDev",varStdDev);
By default Excel expects the separator in a .csv (comma separated values) file to be a comma - go figure. Actually it is a little more complex - On American Windows versions, the comma is set as default for the "List Separator", which is okay for CSV files. But on European Windows versions this character is reserved as the Decimal Symbol and the "List Separator" is set by default to the semicolon.
A future Quantshare enhancement to be considered would be to simply add a new first line to each file:
sep=;
Workaround 1 - open the file with a text editor and add the line above.
Workaround 2 - change the file type to .txt. Open the file within excel which should bring up the import wizard (select delimited-next-semi colon-finished)
Trading financial instruments, including foreign exchange on margin, carries a high level of risk and is not suitable for all investors. The high degree of leverage can work against you as well as for you. Before deciding to invest in financial instruments or foreign exchange you should carefully consider your investment objectives, level of experience, and risk appetite. The possibility exists that you could sustain a loss of some or all of your initial investment and therefore you should not invest money that you cannot afford to lose. You should be aware of all the risks associated with trading and seek advice from an independent financial advisor if you have any doubts.
0
