admin
Options Trading for Beginners As a beginner options trader, learning how to trade options can be an exciting experience, but it can also be extremely frustrating and very costly. There are some common mistakes that lead to many beginner options traders to lose large sums of money in a very short period of time. Here’s …
Read moreOptions Trading for Beginners (Management and Tracking)
Volatility surface is the plot that can help you determine the best combination of the strike and the expiry date to maximize the profits on an Options Trade. Volatility Volatility is basically the fluctuation in the price of a product or a derivative. The more is the swing, the more is the volatility. There are …
Read moreVolatility surface chart (it’s impact on the profitability of option trades)
Introduction A common investment theory is that securities that are owned by institutional investors tend to trade with a closer correlation to the financial performance of the company or, in the case of futures contracts, with the overall economy. Traders, therefore, will frequently look at volume and implied volatility to determine future price direction. Investors …
Read moreUnusual Options Activity – How to Identify, Act and Track for Success
Yahoo Portfolio is a great way to keep track of your investments and stock purchases online. Yahoo Finance portfolio has a great and intuitive way to add your transactions and then track your portfolio in real-time. And with the “Create New View” screen you can simply add many more parameters in the table and compare …
Read moreYahoo Portfolio – Export Portfolio in Excel (to use with MarketXLS)
There’s more than one way to gain exposure in and profit from the stock market. Investing in stocks as the primary asset is one, and trading contract for differences or CFDs is another. Stock trading and stock CFD trading each come with their own sets of risks and rewards and are suitable for different kinds …
Key Updates in this release 1 New Portfolio Analytics FunctionsIn this release we have added very advanced portfolio analytics functions. All these functions take a portfolio as an input and then return results. The results can be a number or result data table. A portfolio is essentially a range of cells that has the stocks in …
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 …
MarketXLS is the best way to stream reliable real-time stock quotes in excel. In this article, I will show you how you can use hundreds of MarketXLS formulas and custom functions to stream real-time live prices of stocks in your Excel sheets. How does it work? Once you install MarketXLS, a new menu will show …
Key Updates in this release 1 New Function Search UtilityTo make it easier for you to search for a function and get the details on it, in this release, we have a new Search and Help button on the extreme left of the MarketXLS menu. So, instead of browsing through the Excel-based function list, we …
Wondering what covered calls are? In this article, we are going to tell you what a covered call is, when you would use it, and how MarketXLS can help you in applying the strategy. What are Covered Calls? Covered calls are a bullish investment strategy. You would usually consider applying the covered calls strategy when …
Read moreCovered Calls – What They Are & How You Can Profit (with MarketXLS Data)
