Page 3 of 5

Re: Pick 3 - Expert Lotto - MetaTrader 4 Platform

PostPosted: Sun Dec 01, 2013 12:38 am
by winsumloosesum
The final window indicates the game was successfully created.

I clicked the "Yes" button to Open the lottery game now.

Re: Pick 3 - Expert Lotto - MetaTrader 4 Platform

PostPosted: Sun Dec 01, 2013 12:43 am
by winsumloosesum
The Georgia Pick 3 Combined Draw lottery game is now created.

Our next step is to create the database and import the draw history into Expert Lotto 5

Re: Pick 3 - Expert Lotto - MetaTrader 4 Platform

PostPosted: Sun Dec 01, 2013 12:49 am
by winsumloosesum
I created an Excel file that contains the Georgia Pick 3 Midday and Evening draws.

I also created a text file using Notepad and copy and pasting the draw history into Notepad.

Here are the download links if you would like to follow along:

https://app.box.com/s/47bgs8h8x1658pogbimj

Re: Pick 3 - Expert Lotto - MetaTrader 4 Platform

PostPosted: Sun Dec 01, 2013 12:54 am
by winsumloosesum
Next we have to Import the draw history database into Expert Lotto 5.

At the Main Menu at the top we would select Winning Numbers > Import Winning Numbers

The Import Winning Numbers window will open

Re: Pick 3 - Expert Lotto - MetaTrader 4 Platform

PostPosted: Sun Dec 01, 2013 12:59 am
by winsumloosesum
Step 1: Data Source

In this step I would select "text file" radio button and click the browse button.

The name of the Georgia Pick 3 draw history text file is located on my Desktop. The name of the file is "GA Pick 3 Draw History.txt"

I click the Next button at the bottom.

Re: Pick 3 - Expert Lotto - MetaTrader 4 Platform

PostPosted: Sun Dec 01, 2013 1:04 am
by winsumloosesum
Step 2: Lines to Import

In Step 2 we can see from the screen shot the drawing numbers, dates, and position 1 through position 3 draws

Click the Next button at the bottom.

Re: Pick 3 - Expert Lotto - MetaTrader 4 Platform

PostPosted: Sun Dec 01, 2013 1:10 am
by winsumloosesum
Step 3: Field Conversion

In Step 3 we need to "Convert columns as:"

You should notice the small drop-down arrows for each of the columns. Click each of the drop-down arrows for each column and select the correct heading for each.

See screen shot below

Click the Next button

Re: Pick 3 - Expert Lotto - MetaTrader 4 Platform

PostPosted: Sun Dec 01, 2013 1:14 am
by winsumloosesum
Step 5: Draws to Import

In Step 5 I kept the default settings

Add new draws only.

Click the Finish button at the bottom.

Re: Pick 3 - Expert Lotto - MetaTrader 4 Platform

PostPosted: Sun Dec 01, 2013 1:18 am
by winsumloosesum
The final step indicates that all the Georgia Pick 3 drawings were added.

See screen shot below.

Click the OK button

Re: Pick 3 - Expert Lotto - MetaTrader 4 Platform

PostPosted: Sun Dec 01, 2013 1:22 am
by winsumloosesum
If you do not see the "Summary History" tab just go to the Main Menu at the top and select History > Summary

See screen shot below

Re: Pick 3 - Expert Lotto - MetaTrader 4 Platform

PostPosted: Sun Dec 01, 2013 1:28 am
by winsumloosesum
Next we need to select 1000 past draws

Click the Select button:

Summary History 2 Select 1000 Draws,jpg.jpg


The Select Draws window will open. Enter 1000 in the box to the left of "Latest Draws".

Summary History 2 Select 1000 Draws 2,jpg.jpg


Click the OK button

Re: Pick 3 - Expert Lotto - MetaTrader 4 Platform

PostPosted: Sun Dec 01, 2013 1:35 am
by winsumloosesum
In the Summary History Tab we need to make the following 3 selections:

1. Click the Sums (to the right of Segmentation)

2. Show as: History Only (click the drop-down arrow and select "History Only")

3. Click the "Date" heading. Make sure the most current drawing is at the very top. When you click the "Date" heading this will toggle the date from most current to oldest.

Summary History 2 Select 1000 Draws 3jpg.jpg

Re: Pick 3 - Expert Lotto - MetaTrader 4 Platform

PostPosted: Sun Dec 01, 2013 1:42 am
by winsumloosesum
In the next step we need to create a new folder on our hard drive for the new MetaTrader 4 Georgia Pick 3 Game

In the screen shot below I created a new folder and named it MetaTrader4 Pick 3 GA

I then copied all the files from my MetaTrader4 Pick 3 PA folder into the MetaTrader Pick 3 GA folder

New GA Folder Copied Files 1.jpg

Re: Pick 3 - Expert Lotto - MetaTrader 4 Platform

PostPosted: Sun Dec 01, 2013 1:50 am
by winsumloosesum
In this next Step we will transfer the Sums History data from Expert Lotto 5 to MetaTrader 4 History folder

The Main Menu at the top select Tools > MetaTrader 4

The "Export Statistics to MetaTrader 4 Window will open

Step 1: Output Folder

We click the browse button and select the folder where we will transfer the History Sums data. In the screen shot below the folder location is C:\MetaTrader4 Pick 3 GA

Click the Next button

Re: Pick 3 - Expert Lotto - MetaTrader 4 Platform

PostPosted: Sun Dec 01, 2013 2:00 am
by winsumloosesum
Step 2: Draws

Here we need to click the "Select" button and a window will open.

MetaTrader 4 Data Transfer Step 2 Draws.jpg


We need to change the "Select draws to export:" from 10 to 1000

Click the OK button

MetaTrader 4 Data Transfer Step 2B Draws.jpg


You should now see pn the "Select draws to export" 1000

Click the Next button.

MetaTrader 4 Data Transfer Step 2C Draws.jpg