How to Get Stock Market Data Into Excel

How to Get Stock Market Data Into Excel

In this blog post, we will learn how to get stock market data in excel. In many situation, we need share market data for further analysis to make some decisions. We have different sources for importing share price data but in every scenario, we get this data in CSV format and then copy it in some excel and this process is very time-consuming. For better time management I have created a tool for importing share price data by which we can fetch stock market data for daily, weekly, and yearly time frames. This tool uses yahoo finance as source data .

In the below snapshot of the tool, we can see that … Continue Reading

How to use MATCH function in Excel

How to use MATCH function in Excel

In this blog, we will be discussing MATCH function in excel. MATCH function basically helps in finding the position of a value. It will not fetch any number but will provide only the position of the lookup value in excel. This function is very helpful when it works with other functions like OFFSET/INDEX.

Let us understand the anatomy of excel MATCH function. It requires 3 input values as can be seen in the below picture.

match_type can be explained as below:

In example 1: we will try to find out the position of USA in the country … Continue Reading

How to use HLOOKUP in Excel

How to use HLOOKUP in Excel

HLOOKUP is one of the functions provided by Microsoft Excel which helps us find a value for a particular reference value. Its functions are the same as VLOOKUP, just the difference exists in terms of fetching data horizontally instead of vertically.

This formula also requires 4 inputs as mentioned below:

We will take an example to understand this in a better way. As we see in the below table we have data for student’s marks achieved in different subject. Now if I wanted to fetch data for a particular student for a particular subject then we will use HLOOKUP to … Continue Reading

How to use VLOOKUP function in excel

Excel Vlookup is the most sought formula in excel and is widely used by everyone. It is used basically for looking up values vertically means from the column.

Before learning how to use vlookup excel we need to understand about different inputs of excel vlookup formula. As we can see below picture there are 4 different inputs required for using excel vlookup function.

The explanation of values are given as given below:

Let us understand this by and example.

In the below table we can see the name of the person and sales done by them on the month on month basis. Now we wanted … Continue Reading

Different COUNT functions in Excel

Excel COUNT function is a very important function in excel and it is being used very frequently. There are five COUNT functions in excel(count, counta, countblank, countif,countifs) that are being used in excel. I will explain every function one by one how to use the count function in excel and have also shared a video with a full explanation.

Count: This function counts the number of numeric entries in a list. It will ignore blanks, text, and errors.Syntax: =COUNT(Range1,Range2,Range3……………….,RangeN)

Counta: This function counts the number of numeric and text entries in a list. It will ignore blanks.Syntax: =COUNTA(Range1,Range2,Range3……………….,RangeN) 