Well if you go to the MonthsTip sheet and go to columns AQ and AR you should have
32 tippers
218.08 Average
167.38 St Dev
So tomorrow morning once you know the Dow is closed (Check MonthsTips C6) and it should say "Dow Has Closed". In E24 which is to the right of Mon 26 March put in the figure at D6 (Red = Down - Green = Up) that figure is the closing difference from last close.
As the Dow is open now, hit the Data tab on the ribbon then Refresh All... watch D6 and it will update the current up/down price. Remember when you open the file in the morning the refresh will automatically happen.
So tomorrow once closed, place in the figure, hit the 2nd Macro (2 books) come to the DJPIN thread, change to BB code editor and paste.
