stevehopwoodforex.com
https://www.stevehopwoodforex.com/phpBB3/
Print view

Importing stock data into Empty4
https://www.stevehopwoodforex.com/phpBB3/viewtopic.php?t=726		 Page 1 of 1
Author:  Jemook [ Mon Jul 23, 2012 4:21 pm ]
Post subject:  Importing stock data into Empty4
I'm trying to get AAPL charts imported into Empty4. I know there's a way and I've tried so many of the web's suggestions but I can't seem to get it working. Has anyone had any experience with this and can lend a hand? Surely there's some script or easy way to do it. You can grab delayed AAPL data from Yahoo:

http://download.finance.yahoo.com/d/quo ... hgv&e=.csv

But after that I can't seem to format and import it correctly. Any help will be appreciated.

Thanks,
Jem
Author:  garyfritz [ Mon Jul 23, 2012 4:31 pm ]
Post subject:  Re: Importing stock data into Empty4
Empty4 is REEEEAAAALLLYY fussy about the input data format, especially the date/time stamp. If it doesn't like your format, it fails with no error message to give you a clue what's wrong.

I wrote an indicator to dump data from Tradestation and had a heck of a time getting Empty4 to accept it. I finally got it to accept data with this format:

2012.07.16 15:05,78.84600,78.86500,78.84300,78.86400

I.e. YYYY.MM.DD hh:mm,open,high,low,close

You must use "." as date separators, space between date and time, etc. Massage it into that format and then try importing it with Tools -> History Center -> Import.
Author:  Jemook [ Mon Jul 23, 2012 4:43 pm ]
Post subject:  Re: Importing stock data into Empty4
Ok so that seems easy enough however I'd have no idea how to massage it efficiently. If you know how to do this easily and can be bothered having a go I've attached the file. Otherwise any tips on the best way to do this in Excel would be much appreciated. Cheers Gary I always appreciate your contributions.
HistoricalQuotes.csv
Author:  garyfritz [ Mon Jul 23, 2012 5:03 pm ]
Post subject:  Re: Importing stock data into Empty4
It's actually really easy in Excel.

First you need to shuffle your columns -- that data has Date,Close,Volume,Open,High,Low. Empty4 won't get that right even with the column headers. So select columns B and C (open and volume) and type Shift-DEL, or right-click -> Cut. Now select column G (right after the "low" column) and right-click -> Insert Cut Cells. Now your columns should be date,open,high,low,close,volume.

I'd get rid of the header line and that first line of data. They're likely to confuse Empty4.

Select column A (the time/date stamp), and type Ctrl-1 (or right-click on the column and select Format Cells, or probably 7 other different ways depending on your Excel version!). Select Custom in the left Category field. Under "Type:" on the right side, enter "yyyy.mm.dd hh:mm" (without quotes). Click OK. Save it as a CSV and you should be ready to go.

One challenge: I don't know how to create new symbols in Empty4. The History Center only seems to import into existing symbols / TFs.
Author:  q600 [ Tue Jan 29, 2013 7:29 pm ]
Post subject:  Re: Importing stock data into Empty4
Helo,

I've found this script on some website. The name is not original because it was written directly on website.

You have to remember that each line in csv file should look like this:

2011.03.02,00:00,139.06,139.06,139.06,139.06,0,

which means:
yyyy.mm.dd,hh:mm,open,high,low,close,volume,

You need to have csv file called APPL.D1 in files directory in your Empty4 platform. In script you overwrite OBLPL.D1 with APPL.D1 and OBLIPLUS with APPLE. In effect youll have offline chart APPLE dayly.


BTW. I need to do/have some script or EA that should download 40 excel files from website, import them into Empty4, and convert them into D2 or D3 chart. Anyone interested to help? :)
Author:  Jemook [ Tue Jan 29, 2013 10:43 pm ]
Post subject:  Re: Importing stock data into Empty4
Thanks for helping out :)
Author:  caldera [ Mon Jun 03, 2013 2:38 pm ]
Post subject:  Re: Importing stock data into Empty4
Try this,

Close Empty4, put the attached file into your Empty4 Experts/Scripts folder. Open Empty4 and execute it, make sure you allow DLL's from your settings. Then go to File/Open Offline, if everything worked correctly you should see "APPL,Daily". Double click it to open it.

Original author of script here:
http://www.forexfactory.com/showthread. ... ost5182789
Jemook wrote:I'm trying to get AAPL charts imported into Empty4. I know there's a way and I've tried so many of the web's suggestions but I can't seem to get it working. Has anyone had any experience with this and can lend a hand? Surely there's some script or easy way to do it. You can grab delayed AAPL data from Yahoo:

http://download.finance.yahoo.com/d/quo ... hgv&e=.csv

But after that I can't seem to format and import it correctly. Any help will be appreciated.

Thanks,
Jem
Author:  fire580 [ Wed Jun 05, 2013 5:17 pm ]
Post subject:  Re: Importing stock data into Empty4
Maybe someone can help with this - I have Empty4 new platform on my desktop and laptop, for some reason when using one click trading on the laptop I get the lines to move for SL and TP but on the desktop no lines to move?

Thank You
All times are UTC Page 1 of 1

Powered by phpBB® Forum Software © phpBB Limited