Money market Daily yield formula

[Bolanders]

I am trying to figure out a formula that will calculate daily yields on a money market account where the yield is calculated daily but the rate also changes daily. In a perfect world column A would have the days listed (for example Apr 16 to May 15 which means ~30 rows. Column B would have the balance for each day (30 rows). Column C would have the interest rate (which is expressed in a yearly yield but is paid daily so the amount is not as simple as just multiplying the balance X rate) and the interest rate changes daily so I would enter the rates in for each day. Finally the calculated column would be D which would have the formula in it to give me the exact amount of wild in $ per day.

[6StringJazzer]

Welcome to the Forum Bolanders!

With questions like this it would be helpful to provide a concrete example, such as an Excel file set up exactly what you describe. Many people will not take the time to create a file from scratch and add test data so they can answer a question. But most people will be willing to use your file to ensure their solution works before offering it.

Also we might need a little more detail in your description. Is the yearly yield the 360-day bond equivalent yield? Is the yearly yield a continuously compounded rate? The daily yield might use the annual yield / 360, or it might require the compounding to be calculated in reverse.

The Excel part isn't too hard but we need to know more context.

Also assuming that "exact amount of wild" should be "exact amount of yield".