Dashboard for open orders ( with SQL )

[grat001]

Hi,

maybe you will throw this EA.

Based from the indicator iExposure.

Shows a summary of open trades. Buy,Sell, Pending

It also displays the evolution of the individual pairs for the last hour, 4h and 24h.Saves the data on the development of (profit) to the circular buffer (csv ). Fully functional is therefore up to 24 hours.

Any improvements and comments welcome.

EA does not open or does not close any deal. Only reads orders.

csr01.png

edit: 2014/09/30 - new version, i had bug in buffer

edit: 2016/04/08 - new version. Total from first to last rows.

edit: 2016/04/20 - new version. This version store value into SQLITE.
Wrapper i'm found: http://www.shmuma.ru/wiki/index.php/Empty4-sqlite

Parameters:
time period for save .... how often save in the minute
first is 60 minute back ... first column 60 minute back for each symbol
show the 24 hours back ... second column show the 24 hour back

Install:
file: sqlite3_wrapper.dll into library
sqlite.mqh and x4corheader.mqh into include
x4cor_ddr.ex4 into experts

must be allow DLL imports

any comments welcome...

[bourgenot]

Well done! I'll try tomorrow and I'll tell you what happens. thank you for this great work !!

[grat001]

Hi friends,

i return back and have for you the new version my dashboard.

Snímek obrazovky 2016-04-08 v 13.39.50.png

If somebody want the source send PM.

If somebody have any idea, i can make a modification.

This EA I use, because is better to see status of the account. I see on the first look,
* where is more LONG or SHORT,
* where is open pending order

so what u see,

1. column - Name of symbol
2. Profit - green is better color
3. Profit in the 1 hour back
4. Profit in the 24 hour back ( I plan make indicator, where you see evolution on the account )
5. Orders on market - GREEN -> more LONG orders, RED -> more SHORT orders ( long / short )
6. the same like 5, but for BuyStop AND SellStop
7. for the BuyLimit AND SellLimit

Milan