Recent content by ajcode

Possible Option 4: Since Norgate provide a DLL plugin only for use in Amibroker, maybe the DLL functions from this same plugin could be called from Excel macros to gain access to the data. Probably not, but if not, maybe Norgate could in future provide a generic DLL for people that don't use...

Gday, I have now added two buttons to my spreadsheet called "Run Cmd" and "Update Last Prices". As can be seen in the following image: As you can see, above the buttons is a non editable cell labelled "Shell Cmd" and next to it is an editable cell containing the words "python.exe...

Thought I'd write a python script to convert a MT4 htm statement containing your closed trade history to a nicely formatted csv file. Note: you need to install python for this to work. Attached is a zip file containing python script mt4htm2csv.py. Extract to where you store your Statement.htm...

I have now updated the script with some much needed changes/additions. Firstly, the Date column is now the index in the dataframe and dates are sorted from oldest to most current. If you get an error message like: ValueError: time data '2017-03-23' does not match format '%d/%m/%Y' Then it...

I've noticed that when I run the script in my previous post, sometimes there are duplicate consecutive rows in the data downloaded. For example, today I found the following entry: SFL,2018-08-06,0.075000,0.075000,0.075000,0.075000,286 SFL,2018-08-06,0.075000,0.075000,0.075000,0.075000,286 I...

Attached is zip file yhquotespy20180802.zip, which contains the following 2 files: symlist.csv - input file containing symbols from https://www.asx.com.au/asx/research/ASXListedCompanies.csv yhquotes.py - updated python script for downloading asx yahoo finance data. Only changes here are that...

No worries Jason, "quotes.csv" follows the format of symbol, date, open, high, low, close and volume. If you can download the EOD data in that exact csv format and rename the file to quotes.csv then yes it is possible. If format similar, but in multiple files then a little bit of programming is...

Probably cause they may not contain metastock files. What's the error message?

This thread is End of Day (EOD) Data Only not Intraday.

Realised in my last post that the database load time was so high because I included the print statements in the timing. Having commented the print statements out and a couple of other useless variables, I only got it down to 0.6 seconds which was roughly 3.5 times slower. I am now blaming doing...

I was able to split the quotes.csv file (in first post) into nearly 2000 symbol files and these have been zipped into the attached file mfquotes.zip. The csv file format is the same as csv files in previous post ("sptmcsv20170805.zip"). I have done this so similar comparisons can be made with...

Just wondering, how are you executing the script? On windows 7 you click on start button/all programs/accessories/command prompt. Navigate to directory where the files are and type "perl ms2mt4.pl" or "python ms2mt4.py", then look at the errors and post a screen shot. Surely there is a command...

Got any screen shots of the command prompt window and error message? I haven't run it on windows 10, but that hopefully shouldn't be the problem.

I have attached file SymbolScanPCV20170818.zip that contains the percent change of volume over the last n-periods mql4 script. Dialog Inputs when run are "PerChangeVolPeriod" and "PerChangeVolThreshold". Shouldn't be too hard to code other scans as the symbol is passed into symbol scan and you...

When running the script "yhquotes.py" (in previous post) on a bigger list of symbols in symlist.csv, you might come across the following error: File "yhquotes.py", line 135, in <module> p_open = float(p_openstr); p_high = float(p_highstr) ValueError: could not convert string to float...