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:

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.