Excel for mass monitoring of the bond market.

An Excel calculator for connecting to the QUIK information and trading system for processing bond parameters and automatically calculating the yield of debt securities to maturity. Works only on a computer or laptop. There is no mobile version.

With the help of this table, an investor can simplify the process of choosing the most profitable bonds. In Excel, filters and sorting are implemented that allow you to conveniently set the parameters of securities for selection. The table immediately analyzes the entire market of debt financial instruments at the current moment.

Excel consists of several sheets. Most of the work is done on the "Bonds" sheet. An investor can create for himself lists of bonds with monthly coupon payments or by face value. Further, you only need to review the preliminary calculations of yield to maturity and double-check the information.

Implementing a strategy taking into account the investment horizon with the help of this excel will be a fairly simple task. It is enough to use filters by duration to maturity. Excel will generate a list of securities that meet the specified condition. This function is widely used by experienced investors when forming their portfolios on IIAs of the first and second types.

On the STOP LIST tab, the investor independently enters information about unreliable companies. This approach allows you to save time when analyzing higher-quality bonds by ignoring bad securities in advance.

Using the PORTFOLIO sheet, an investor can implement a strategy for averaging positions when buying shares of a particular company, as well as control the amount of assets at his disposal. There is a cross-check between the PORTFOLIO and BONDS sheets. With the help of this function, the investor can buy new securities every time and not intersect with those bought earlier. In this way, two tasks are simultaneously implemented: diversification through securities with a higher yield. Ultimately, this approach allows the entire portfolio to overtake the average market return.

The practical application of this Excel calculator does not exclude the investor´s understanding of the essence of the selected bond. In any case, before buying a particular security, you need to independently clarify its yield to maturity. The presence of a variable type of coupon and depreciation of the face value distorts the final indicator of future profit. Excel was created solely as an auxiliary tool that allows the investor to take a broad look at the stock market.