How to Get Stock History for Multiple Stocks in Excel? Getting stock history in Excel for multiple stocks can be a great way to track progress or analyze trends. To get started, you will need to download a data file from an online source such as Google Finance or Yahoo Finance. Once you have downloaded … Read more
Historically speaking, small-capitalization companies have often outperformed larger companies even after considering the additional risks that smaller companies carry. This is why they have attracted investors’ attention for a long time. The attraction in small caps is due to their potential to become large companies, with their share price appreciating in the process. With numerous … Read more
Guru Screen Functions are used to filter out stocks based on the winning investment strategies of stock market legends such as Warren Buffet, Benjamin Graham, Robert Piotroski etc. They are a part of MarketXLS since its foundation has been laid down. These screens are of immense value to the customers and users of MarketXLS. These … Read more
Overview of the Sector The basic materials sector is made up of businesses involved in the development, discovery, and processing of raw materials. This sector consists of companies engaged in metal refining and mining, oil, forestry products, and chemical products. The raw materials they develop are purchased by nearly all other industry sectors. This sector … 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
Magic formula investing is intended to beat the benchmark Index returns with the help of value investing. It mainly relies on various quantitative screens that are relatively simple and usually follows a rule based disciplined strategy. The screen simply ranks stocks based on their price and returns, however it only factors large cap stock and … Read more
The New Player in Town Jane Street Capital, also known as Jane Street is a global proprietary trading company established in the early 2000s in Manhattan, New York. This underdog of the trading world was well-hidden under the shadows of Wall Street until after years of minting money by trading in ETFs is now pitching … Read more
The DuPont method is an essential analysis used to assess a company’s performance in detail. Donaldson Brown, a DuPont Corporation salesman, found the DuPont equation in 1920. The DuPont analysis is an expansion of the Return on Equity (ROE) which is broken down into a more detailed and complex equation. Many investors use the ROE … Read more
Introduction The dividend discount model, also known as the Gordon Growth Model, is used to determine a stock’s intrinsic value based on a future series of dividends that grow at a constant rate. It is a popular and straightforward variant of the dividend discount model (DDM). This method disregards current market conditions. Companies belonging to a diverse … Read more
Everyone in the investment world has heard of Warren Buffet– one of the world’s wealthiest people, consistently ranking high on Forbes’ list of billionaires. Known as the “Oracle of Omaha,” Warren Buffett is one of the most successful investors of all time. Investors revere his investing strategies across the globe. He follows the Benjamin Graham … Read more
