Pivot & Psychological Price Points Dashboard

Hi,

You have to develop a "Multicurrency Pivot Dashboard" for me.

Please  my requirement:
1) The Pivot Dashboard will be fixed for only GBP Pairs.

2) At the top there will be calculation for Daily Range, Average 5 days Daily range & Yesterday's Daily Range rows for each pair.

3) At the middle there will be always current Price (CURRENT).

.4) Now relative Current Price you have to show the different price points as below with their distances from current price (CURRENT):

a) be a Point called Day open line (in your pivot in the middle is Pivot line) (This line will be fixed ) This is the Opening Price of the day

b) Monthly Pivot line points ( MR1, MR2, MR3, M Pivot, MS1, MS2, MS3) and their distances from current price.

c)Weekly Pivot line points ( WR1, WR2, WR3, W Pivot, WS1, WS2, WS3) and their distances from current price.

d) Daily Pivot line points (R1, R2, R3, PIVOT, S1, S2, S3) and their distances from current price.

e) Daily High (HIGH)  or Low point (LOW) PRICE points and their distances from Current price. Remember this High and Low will change their position over time as the daily range increases.

f) Psychological line points (PSL) :

   For All pairs other Than GBPJPY:

              i) All five Decimal points are zero = 1.0000

              ii) All four decimal points from left are zero =1.40000

            iii) All three decimal points from left are zero =1.41000

   For GBPJPY:

            i) All three decimal points from left are zero =1.000

            ii) All two decimal points from Left are Zero = 1.400

Special Notes regarding digit of price points:

            You have to show:

                        1) Up to 5 Decimal points (1.00000, 1.45890, .894570) for all pairs other than GBP JPY

                        2) Up to 3 Decimal Points for GBPJPY (1.300, 1.450 etc)

Special Notes for regarding the position of Different price points to show:

Please remember that only Current Price Point will be Fixed Positioned in the middle of the Dashboard. According to its position other price points will vary. Say, sometimes Opening price, depending on the Current Price sometimes it will remain up for while and sometimes it will go to below to Current Price. For other price points the same rule is applicable according to their relative position CURRENT Price Point.

You have to show the all the price points up to 300 pips above and 300 pips below from CURRENT price. if you need, provide a scrolling facility for the Dashboard.

Summary List of price points to calculate:

You have to calculate following price points:

1) CURRENT PRICE (continuous basis).

2) Daily Open price ( Once per day)

3) Daily Pivot (Daily Pivot) , Support (S1, S2, S3) & Resistance(R1,R2,R3) ( Once per day)

4) Weekly Pivot (Weekly Pivot) , Support (WS1, WS2, WS3) & Resistance (WR1, WR2, WR3) (Per week basis)

5) Monthly Pivot (Monthly Pivot) , Support(MS1, MS2, MS3)  & Resistance (MR1, MR2, MR3)  (Per month basis)

6) Psychological price points (PS). See the above explanation for Psychological price points as the price roams around others you have continuously show new Psychological price points each time.

7) Daily High & Low.

Summary List of Ranges to calculate:

You have to calculate following price points:

1) Today's Range

2) 5 Day's Average Daily Range (ADR)

3) Yesterday's range.

These ranges are to be shown at the top below the headings of each currency related to GBP.

Summary of total number of rows to show in the Pivot table:

1) At the top heading (1 row)

2) Below these range related rows ( 3 rows)

You also have to calculate following price points:

1) CURRENT PRICE (continuous basis) ( 1 row)

2) Daily Open price ( Once per day) ( 1 row)

3) Daily Pivot (Daily Pivot) , Support (S1, S2, S3) & Resistance(R1,R2,R3) ( Once per day) ( 7 rows)

4) Weekly Pivot (Weekly Pivot) , Support (WS1, WS2, WS3) & Resistance (WR1, WR2, WR3) (Per week basis) ( 7 rows)

5) Monthly Pivot (Monthly Pivot) , Support(MS1, MS2, MS3)  & Resistance (MR1, MR2, MR3)  (Per month basis) ( 7 rows)

6) Psychological price points (PS). See the above explanation for Psychological price points as the price roams around others you have continuously show new Psychological price points each time. ( 1 PS / 100 pips , so 300 up and 300 below  total rows will be : 3+3 =6 rows)

7) Daily High & Low. ( 2 rows)

==============================================================================

In my calculation 35 lines to be on the screen.

Special Notes for regarding the colour of Different price points and  to show and the background of the dashboard:

1) Background of the Dashboard will be black.

2) Today's Range, 5 Day's ADR and Yesterday's range will be white in font.

3) Opening Line will be yellow color in font.

4) All Pivot points will be Orange in colour in fonts.

5) All the Psychological points (PSL) will be Deep blue color in fonts.

6) All the resistance line points will be green fonts.

7) All the resistance line points will be red colour fonts.

8) Current Price Point will be shown as White in colour.

9) Daily High & Low will be shown as White in colour.

Please note that the Appearance of the Dashboard Table will be exactly same as I have presented in the Excel sheet name "Table Design".

Thanks.