Suppose I have today current duration of a bond and it's historical daily prices. How from that I can calculate the historical duration? e.g. the value of duration I would saw if yesterday, week ago, 43 days ago I checked?
(I know the exact formulas for duration are not trivial, but let's say reasonable approximation I can enter as formula to Excel).