Scatter plot is a graph that shows the relationship between two sets of continuous numerical data. For example, the relationship between a group of people's weight and height or their salary and years of working experience. In this tutorial we are going to look at the way to use Python…

On June 5th 2019, Microsoft released a new feature to Office 365 that allows Excel users to pull real-time stock prices into their spreadsheets. In this article, we are going to look at the way to pull cryptocurrency prices in Microsoft Excel. …

Trading strategy is essential in any investment. Python offers us a fantastic opportunity to test and implement our trading idea based on historical data and observe the result. This helps us to evaluate the feasibility of our trading strategy before we adopt it in the real market. In this article…

A stock alert messaging tool can be valuable for us to keep up to date with the most recent changes of the stock market and enable us to make a prompt trading decision. Rather than staying in front of a computer screen for a long day, the alert system can…

Xlwings is an especially useful Python library that enables us to directly control Excel via Python script. Through xlwings, we can make use of Python as a backend analytic engine and render the result in Excel. This can result in many interesting use cases in financial analysis. In this article…

Both Python and Excel are useful tools in financial data analysis and visualization. Xlwings, on another hand, offers us the best of both worlds by integrating Python analysis and visualization features with Excel. Xlwings is a Python library that can be used to insert financial data and Matplotlib or Plotly…

As a software library for data analysis, Pandas offers a lot of useful statistical methods that permit us to gain statistical info from our dataset with only a one-liner code. All these statistical methods are very intuitive and can work seamlessly with Pandas Dataframe. In this article, I will demonstrate…

Pandas allows us to apply our custom Python function to one or more columns. This can be particularly useful whenever we need to transform our data or engineer new features from the existing columns. In this tutorial, I am going to cover two main approaches to apply a function on…

Pandas enable us to filter the DataFrame by selecting the rows based on one or more conditions. The filtering can be as simple as running a query based on a single condition and can also be a complex query that takes multiple conditions into consideration. This is the Part 2…