On Balance Volume (formula in Excel)

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 moreOn Balance Volume (formula in Excel)

Time Value of Money (Excel Formula – Calculator)

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 moreTime Value of Money (Excel Formula – Calculator)

Financial Ratio Analysis in Excel (Download Excel Template)

Ratio Analysis, also known as Financial Statement Analysis, involves evaluating the financial statements of companies, and comparing those results to similar companies; typically within the same sector or industry. Because ratios are most useful when compared to other ratios, and it is important to compare relevant ratios. Example; Ratio Analysis would not be useful in … Read moreFinancial Ratio Analysis in Excel (Download Excel Template)

Real Time Stock Option Pricing in Excel (Any version)

 Option Pricing with Quotemedia’s AddonUse MarketXLS to stream real time or delayed live Pricing (Last, Bid, Ask and so on) for getting Stock Option Prices in Excel. You will need any version of plan of MarketXLS along with a data subscription for Options Pricing.  See the pricing page at the link below for further details… https://marketxls.com/pricing This article … Read moreReal Time Stock Option Pricing in Excel (Any version)

How to Build an Understanding of Cryptocurrencies

How to Build an Understanding of Cryptocurrencies There are plenty of articles on the internet that talk about cryptocurrencies in-depth. Yet, it is easy to get turned off by the jargon that at first can be hard to follow. If you’re searching for a starting point for your education on cryptocurrencies, this is a good … Read moreHow to Build an Understanding of Cryptocurrencies

Stock Market API in Excel – with MarketXLS API -(VBA & Google Sheets)

Stock Market Data API

With MarketXLS Stock Market API, you can use VBA and Javascript code to run access Stock Market API with a few lines of code. You can use any language you want like Python, c# or VB.net to create your own applications for any platform (Android, Windows, or Mac). Access all US Historical and live data … Read moreStock Market API in Excel – with MarketXLS API -(VBA & Google Sheets)

Thinking of a takeover…Well how about ‘The Acquirer’s Multiple’

The Acquirer’s Multiple – BackgroundMany people have heard of the infamous Magic Formula documented by Joel Greenblatt in his book “The Little Book That Beats the Market” which is a direct quantitative value investment model in ranking stocks by price and ROIC. In a similar nature, The Acquirer’s Multiple founded by Tobias Carlisle is a … Read moreThinking of a takeover…Well how about ‘The Acquirer’s Multiple’

Monthly Dividend Stocks (3 good monthly dividend stocks)

Why Monthly Dividend Stocks Seasoned investors interpret dividends as the cash payments disbursed to shareholders monthly, quarterly, semi-annually, or annually; or frankly the system for reinvestments. As for the beginning investor – dividends can be treated as passive income. It is pretty straightforward – corporate earnings not used for expansion are issued to shareholders periodically. … Read moreMonthly Dividend Stocks (3 good monthly dividend stocks)

Modern Portfolio Theory (Application with MarketXLS portfolio)

Modern Portfolio Theory

Modern Portfolio Theory Harry Markowitz introduced Modern Portfolio Theory  in 1951 in his paper “Portfolio theory”. This theory has completely revolutionized the way of what we know of investment philosophy. This theory builds on the foundation that every set of investors, be it risk verse or risk averse, wants to optimize returns with minimum risk as … Read moreModern Portfolio Theory (Application with MarketXLS portfolio)