I need a program to be able to gather and track forex stats from generated alerts.
The alrets will come to an g-mail email address.
Alerts
Incoming address - alert*[login to view URL]
*=@
alert bodys
BUY AUD/NZD at 1.2995, Target: 1.3030, Stop: 1.2940(beginning either Buy/sell)
AUD/NZD (D - 34303) Executed
AUD/NZD (D - 34294) closed with -45 pip loss.(ending in either profit or loss)
*there is also one for a canceled alert that i will add on too
save the data to an excel spread sheet with the following data
type(D/S) depending on first letter in the alert
time executed
time closed
length- how long trade was open in hours and minutes
symbol(AAA/BBB)
Entry
Target
Stop
Profit/loss(readings taken every 15 mins starting at midnight, headers=time)
-calculated based of bid/ask price
-if waiting to execute put a number x after number of pips away from execution(10x)
-if possible use data from [login to view URL] quotes, if not possible use any source
-collect data till trade is closed
-new spreadsheet for every day(12am-12pm EST), but continue to collect data till trade closes
any questions just ask