İş tamamlandı


İş Gereklilikleri
Dashboard- Distance of Current Price From Previous Day High & Low; & Alert when Equal
Requirement # 1: You have to create a dashboard Table for All pairs related to : AUD, CAD,CHF,EUR,GBP,JPY,NZD, USD (Total 28 pairs)
Requirement # 2: The Dashboard will show the Previous Day High (Column A) & (Column C) Low for Each Pair
Requirement # 3: It will continuously count and Show the Current Price (Column B)
Requirement # 4: It will continuously calculate and show the Price Distance in pips between Today's current price to the previous Day's high (Column D) (Font colur will be black)
Requirement # 5: It will continuously calculate and show the Price Distance in pips between Today's current price to the previous Day's high (Column E) (Font colur will be black)
Requirement # 6: If today's Price is within the Candle of Previous Day, it will Show "Potential" ( in Green Colour in Column F) for the pair in the table. (Check the Table values For AUDCAD below)
Requirement # 7: If the Today's Current Price is Outside of the Previous Day's Candle, It will Show "Missed" ( in Red Colour in Column F) (Check the Table values For AUDCAD below)
Requirement # 8: If the Today's Price is Equal to the Previous Day's Candle's High , it Will Show " Buy". " ( in BLUE Colour in Column F) (Check the Table values For EURAUD below)
Requirement # 9: If the Today's Price is Equal to the Previous Day's Candle High it Will Show " Sell".".( in BLUE Colour in Column F )(Check the Table values For GBPAUD below)
Requirement # 10: When the Today's Current price = Yesterday's High, it will Give Sound and Message Alert " Buy Signal For EURAUD "( Please note: The colour of the Font Will be Blue)
Requirement # 11: When the price crosses Down the Yesterday's Low it will Give Sound and Message Alert " SELL Signal For GBPAUD"( Please note: The colour of the Font Will be Blue IN THE MESSAGE)
Requirement # 12: When the Distance Between Price and Yesterday's High is = 10 pips then will Give Sound and Message Alert " Prepared FOR Buy AUDJPY"( Please note: The colour of the Font Will be Blue IN THE MESSAGE)
Requirement # 13: When the Difference Between Price and Yesterday's Low is= 10 pips then will Give Sound and Message Alert " Prepared FOR SELL AUDNZD"( Please note: The colour of the Font Will be Blue IN THE MESSAGE)
Explanatory Table:
Pair |
(A)Yesterday's High |
(B)Current Price |
(C)Yesterday's Low |
(D) Distance to Yesterday's High=A-B |
(E) Distance to Yesterday's Low= B-C |
(F) Status
|
AUDCAD |
1.26000 |
1.24000 |
1.20000 |
200 |
400 |
Potential |
AUDCHF |
1.26000 |
1.28000 |
1.2000 |
200 |
800 |
MISSED |
EURAUD |
1.25000 |
1.25000 |
1.2400 |
0 |
200 |
BUY |
GBPAUD |
1.25000 |
1.20000 |
1.2000 |
500 |
0 |
SELL |
AUDJPY |
1.50 |
1.40 |
1.0 |
10 |
40 |
Prepared for BUY |
AUDNZD |
.89000 |
.87500 |
.874 |
150 |
10 |
Prepared for SELL |
Requirement # 15: Background of the Table Must be White.
Requirement # 16: When I will click the Currency Pair, the existing chart will be changed to the currency pair that I have clicked on.