We take pride in announcing that marketXLS isn’t limiting itself to just excel sheets. Our focus lies on providing the best value for your money and hence we are constantly innovating. We are thrilled to announce the launch of our stock screener on the website along with tonnes of other features. Key Updates – Get Started … Read more
MarketXLS offers you simple commands to fetch historical and live option prices, but have you wondered how options contracts are priced? Any option’s premium consists of two components: the contract’s intrinsic and extrinsic value. The intrinsic value signifies the difference between the strike price of an option and the current market price of the underlying … Read more
What is The Altman Z Score? Altman Z-Score is a score that indicates the solvency and debt repaying capacity of a company listed on a public exchange. This technique/template is usually used for publicly traded companies in the manufacturing sector. It is a barometer of the credit strength of a particular company. New York University’s … Read more
A leverage ratio is a financial measurement to check out what proportion of capital comes within in the kind of debt (loans) and assess the ability of a corporation to satisfy its financial obligations. The leverage ratio category is vital because companies rely on a mix of equity and debt to finance their operations, and … Read more
Introduction The dividend yield, expressed as a percentage, is a financial ratio (dividend/price) that shows how much a company pays out in dividends each year relative to its stock price. The dividend yield is a way to measure how much cash flow you are getting for each dollar invested in an equity position. In the … Read more
Discounted cash flow or DCF is the method for estimating the current value of an investment by taking into account its future cash flows. It can be used to determine the estimated investment required to be made in order to receive predetermined returns. In short, DCF analysis attempts to figure out the value of an … Read more
In this article, we will look at how we estimate the volatility based on the history of a stock price movement. With MarketXLS, you can simply use the stock volatility function to turn Excel into the stock volatility calculator. Volatility comes in various forms and what MarketXLS volatility functions return is the simplest form of … Read more
In this article, we will look at how you can use MarketXLS’s portfolio beta calculator template to easily calculator Beta of your portfolios. MarketXLS has a very strong portfolio analytics engine that can get you all kind of analysis of your portfolio with easy to use Excel functions What is Beta? Beta is a way … Read more
On Balance Volume in Excel MarketXLS.com offers On Balance Volume excel based utilities to enhance your personal spreadsheets. Utilizing the security identifier and a date rage, we can generate OBV trend lines allowing us to enhance our charting capabilities by provide a powerful analytical tool. Historically the On Balance Volume indicator has been a valuable … Read more
Time value of money is the change in value or purchasing power of money with the time. In the period of inflation purchasing power of money is going down day by day. If we invest or deposit some money in the bank, then we receive a return or interest on such money. Such return or … Read more
