mysql db tick data script help

Hello, I'm new to the forum just signed up! So, hello to everyone!!!

And apologies if I'm posting this in the wrong area...

Anyway, I have a mysql db of tick data, which I want to use for backtesting. The idea is to create a php script to search the db with my trade details, ie:

date/time, market, orderType, entryPrice, target, stop
2009-05-04 07:00:12.000, gbpusd, buy, 1.46, 1.5, 1.44

It should then tell me if the trade was good or bad.

I have created a simple php script, however I'm confused when it comes to logic side to it. ie the bid and ask price, how to check if a stop was hit, or when a target it hit, also trailing stops and other stuff etc

So, unfortunately its turning out to be more difficult than I thought...

Can anybody point me in the correct direction, or has anyone created something similar???

Infact is a there any PHP developers here who dabble in forex, cos you will be perfect... hehe

Thanks for reading

I had the same problem...

I was coding a system in Perl / MySQL. I had the same confusion as you, heres what I figured out:

The prices in the DB are BID prices. So if the spred is say 2 (typical for EURUSD) Your ASK price is BID+2

So next you have to figure out your stoploss/takeprofit PRICE (as opposed to pips).

Then to find out when the price is hit do something like:

Hope this gives you some clues.

Hello Frink, Thanks for the reply...

Please correct me if I'm wrong.

When you buy, entry price is the bid, and the exit price (ie tp/sl) is the ask.
When you sell, entry price is the ask, and the exit price is the bid.

Is that correct, or have I lost the plot?

I did mess about with a similar query to what you posted. But ended up pulling my hair out! hehe So now I'm querying the table for all records, then looping through the recordset with php whilst checking each record to see if any prices where hit...

Also, when it comes to the bid and ask price my tick data varies between 2-7 pips...

Do you have php installed? Can I upload a working script, and will you have a look? No need for mysql - I've hardcoded some test arrays...

Bye