In our daily routine of looking at investments – Returns, Liquidity, Volatility, and Predictability matters. People might be wondering about this approach but there is nothing wrong with it, instead, those who successfully employed and get much of this right are better than 99% investors in the whole market. Due to our busy daily schedule, we only look at what investments are instead of looking at a deeper meaning of what they are.
A debt instrument is issued at a fixed coupon which varies on the market condition at the issue time and is paid on a regular basis until maturity. When there is a fall in interest rate, the debt securities value gains, resulting in mark-to-market gains. The opposite happens when the rate of interest goes up, the value of debt security go down, making mark-to-market loss.
Gilt Funds are those funds of debts that invest 80% of their investments in securities of government. For issuance of golden-edged certificates, these government securities or bonds can be used. The Gilt originated from the nickname of gilded edge certificates. As per SEBI norms, gilts funds must invest at least 80 per cent of their funds or assets in government securities.
Looking for ways to do basic backtesting in Excel. It’s very funny as we all have love/hate sort of relationship with Excel. It is a very good way of doing some quick and dirty testing. Along with Excel being very convenient because of its easy availability, it has some limitations too. However, the learning curve will be pretty short and quick; so you would be able to run some basic backtesting in a matter of no time.