How to Find the Fair Market Value of Shares as on 31 January 2018 NSE Excel Download
If you are an investor or a taxpayer who owns shares in a company, you may need to know the fair market value of those shares for various purposes. For example, you may need to report the fair market value of your shares for capital gains tax calculation, or you may want to compare the fair market value with the market value to decide whether to buy or sell your shares. But how do you find the fair market value of your shares? And how can you use the data from the National Stock Exchange (NSE) of India to do so?
In this article, we will explain what fair market value is and why it is important, what NSE is and how to download data from it, and how to calculate fair market value of shares as on 31 January 2018 using NSE data. We will also provide an example of calculating fair market value of shares using NSE data and answer some frequently asked questions.
fair market value of shares as on 31 january 2018 nse excel download
Download: https://tiurll.com/2vxsuw
What is fair market value and why is it important?
Definition of fair market value
Fair market value is the estimated price at which an asset would sell in a competitive and open market. It assumes that both the buyer and seller are reasonably knowledgeable about the asset, are acting in their own best interests, are free of undue pressure, and are given a reasonable time period for completing the transaction. Given these conditions, an asset's fair market value should represent an accurate valuation or assessment of its worth.
Importance of fair market value for taxation and investment purposes
Fair market value is important for taxation and investment purposes because it helps determine the taxable income or capital gain or loss from selling an asset. For example, if you sell your shares in a company, you need to know the fair market value of those shares as on 31 January 2018, which is the date when the long-term capital gains tax rate for equity and equity-related mutual funds was increased from 0% to 10% in India. By knowing the fair market value, you can calculate your grandfathered value of shares, which is the higher of your actual cost or the fair market value as on 31 January 2018. This grandfathered value will help you reduce your taxable capital gain or increase your capital loss when you sell your shares.
Fair market value is also important for investment purposes because it helps you evaluate whether an asset is overvalued or undervalued in the market. For example, if you want to buy or sell your shares in a company, you need to compare the fair market value with the market value, which is the price at which an asset trades in the marketplace. If the fair market value is higher than the market value, it means that the asset is undervalued and may be a good buy. If the fair market value is lower than the market value, it means that the asset is overvalued and may be a good sell.
What is N What is NSE and how to download data from it?
Overview of NSE and its products and services
The National Stock Exchange of India Limited (NSE) is the leading stock exchange in India and the second largest in the world by number of trades in equity shares. It was established in 1992 as the first demutualized electronic exchange in the country. It offers trading, clearing and settlement services in various segments, such as equity, equity derivatives, debt, currency derivatives, commodity derivatives, mutual funds, exchange traded funds, indices, and securities lending and borrowing.
NSE also provides various data products and services to its members, investors, researchers, and other stakeholders. These include historical data, market statistics, corporate actions, indices data, live market data, and end-of-day data. NSE data can be accessed through various modes, such as web-based applications, file transfer protocol (FTP), application programming interface (API), or direct market access (DMA).
How to calculate grandfathered value of shares using FMV on 31 Jan 2018 NSE data
Download BSE and NSE fair market price list for stocks as on 31 January 2018 in excel format
LTCG tax calculation for equity and mutual funds with FMV of stocks on 31 Jan 2018 NSE
Complete list of NSE and BSE fair market value of all stocks as on 31 January 2018 for LTCG
NSE and BSE highest price of stock on 31 Jan 2018 for fair market value calculation
Excel sheet download for fair market value of shares as on 31 January 2018 NSE and BSE
Grandfathering clause for LTCG tax and FMV of stocks on 31 Jan 2018 NSE
NSE and BSE fair market value of stocks on 31 January 2018 for equity trading
How to find the fair market value of shares as on 31 January 2018 NSE in excel
NSE and BSE bhav copy as on 31 Jan 2018 for fair market value of shares
Fair market value of shares as on 31 January 2018 NSE for capital gains tax
Download NSE and BSE fair market value of stocks on 31 January 2018 in excel file
How to use NSE and BSE data to determine the fair market value of shares as on 31 January 2018
Fair market value of shares as on 31 January 2018 NSE and BSE for grandfathering clause
Excel download for NSE and BSE highest price of stock on 31 Jan 2018 for FMV calculation
LTCG tax rate and FMV of stocks on 31 Jan 2018 NSE and BSE
Fair market value of shares as on 31 January 2018 NSE for equity and mutual fund investors
Download excel sheet for fair market value of shares as on 31 January 2018 NSE and BSE
How to calculate LTCG tax using FMV of stocks on 31 Jan 2018 NSE data
Fair market value of shares as on 31 January 2018 NSE and BSE for equity trading
Excel file download for fair market value of shares as on 31 January 2018 NSE and BSE
How to find the FMV of stocks on 31 Jan 2018 NSE and BSE in excel format
Fair market value of shares as on 31 January 2018 NSE for capital gains tax calculation
Download NSE and BSE data for fair market value of shares as on 31 January 2018 in excel sheet
How to use the grandfathering clause for LTCG tax with FMV of stocks on 31 Jan 2018 NSE
Fair market value of shares as on 31 January 2018 NSE and BSE for LTCG tax calculation
Excel download for fair market value of shares as on 31 January 2018 NSE and BSE data
How to calculate the grandfathered value of shares using the FMV on 31 Jan 2018 NSE and BSE
Fair market value of shares as on 31 January 2018 NSE for equity and mutual fund trading
Download excel file for fair market value of shares as on 31 January 2018 NSE and BSE data
How to calculate LTCG tax using the FMV of stocks on 31 Jan 2018 NSE and BSE data
Fair market value of shares as on 31 January 2018 NSE and BSE for capital gains tax calculation
Excel sheet download for fair market value of shares as on 31 January 2018 NSE and BSE data
How to find the FMV of stocks on
Steps to download data from NSE website
One of the easiest ways to download data from NSE is through its website. Here are the steps to download data from NSE website:
Go to the NSE website at .
Click on the "Products & Services" tab and select "Data and Reports".
Choose the type of data you want to download from the available options, such as historical data, bhavcopy, corporate actions, etc.
Select the segment, instrument, date range, and format of the data you want to download.
Click on the "Download" button and save the file to your desired location.
You can also use the "Search" option on the NSE website to find the specific data you are looking for.
How to calculate fair market value of shares as on 31 January 2018?
Methods to calculate fair market value of shares
There are various methods to calculate fair market value of shares depending on the type and availability of information. Some of the common methods are:
Comparing similar assets in the market
This method involves finding the prices of similar or comparable assets in the market and using them as a basis for estimating the fair market value of the asset in question. For example, if you want to find the fair market value of a share in a company, you can look at the prices of shares in other companies that operate in the same industry and have similar characteristics. This method is also known as the market approach or the comparable sales method.
Estimating expected earnings of the asset
This method involves projecting the future earnings or cash flows of the asset and discounting them to their present value using an appropriate discount rate. The present value of the expected earnings or cash flows represents the fair market value of the asset. For example, if you want to find the fair market value of a share in a company, you can estimate its future dividends or earnings per share and discount them using its cost of equity or required rate of return. This method is also known as the income approach or the discounted cash flow method.
Determining the cost to replace the asset
This method involves estimating how much it would cost to acquire or reproduce an asset that is identical or equivalent to the asset in question. The cost to replace the asset represents its fair market value. For example, if you want to find the fair market value of a share in a company, you can estimate how much it would cost to buy a similar share in the market or to start a similar company from scratch. This method is also known as the cost approach or the replacement cost method.
Using professional appraisal services
This method involves hiring a qualified and independent appraiser who can provide an expert opinion on the fair market value of the asset based on various factors, such as the condition, quality, features, and marketability of the asset. The appraiser may use one or more of the above methods or other methods to arrive at the fair market value. For example, if you want to find the fair market value of a share in a company, you can consult a professional appraiser who specializes in valuing shares and has access to relevant data and information. This method is also known as the appraisal method or the valuation method.
Example of calculating fair market value of shares using NSE data
To illustrate how to calculate fair market value of shares using NSE data, let us take an example of a share in Reliance Industries Limited (RIL), which is one of the largest and most diversified companies in India. Suppose you own 100 shares of RIL and you want to find their fair market value as on 31 January 2018.
Downloading the NSE data for 31 January 2018
The first step is to download the NSE data for 31 January 2018 from the NSE website. You can follow the steps mentioned above to download the data. Alternatively, you can use this link to directly download the data in CSV format: .
After downloading and extracting the file, you will get a CSV file with the following columns: Symbol, Series, Open, High, Low, Close, Last, PrevClose, TotTrdQty, TotTrdVal, and Timestamp. You can open this file in Excel or any other spreadsheet software.
Finding the highest price of the stock on that date
The next step is to find the highest price of the RIL stock on 31 January 2018. You can do this by filtering or sorting the CSV file by Symbol and High columns. You will find that the highest price of RIL on that date was Rs. 980.65 per share.
Applying the relevant adjustments for interest, dividends, etc.
The next step is to apply any relevant adjustments for interest, dividends, splits, bonuses, rights, or any other corporate actions that may have affected the fair market value of the RIL share as on 31 January 2018. You can find this information from the NSE website or from other sources such as company websites or annual reports.
In this case, we find that there were no such adjustments for RIL share as on 31 January 2018. Therefore, we do not need to make any changes to the highest price of Rs. 980.65 per share.
Comparing the fair market value with the market value
The final step is to compare the fair market value with the market value of the RIL share as on 31 January 2018. The market value is simply the closing price of the share on that date. You can find this information from the CSV file or from other sources such as NSE website or financial websites.
In this case, we find that the closing price of RIL share as on 31 January 2018 was Rs. 971.40 per share. Therefore, we can conclude that:
The fair market value of RIL share as on 31 January 2018 was Rs. 980.65 per share.
The market value of RIL share as on 31 January 2018 was Rs. 971.40 per share.
The difference between fair market value and market value was Rs. 9.25 per share.
The percentage difference between fair market value and market value was (9.25/971.40) x 100 = 0.95%.
This means that RIL share was slightly undervalued in the market as on 31 January 2018 and may have been a good buy opportunity for investors.
Conclusion and FAQs
In this article, we have explained what fair market value is and why it is important, what NSE is and how to download data from it, and how to calculate fair market value of shares as on 31 January 2018 using NSE data. We have also provided an example of calculating fair market value of shares using NSE data and answered some frequently asked questions. We hope that this article has helped you understand how to find the fair market value of shares as on 31 January 2018 NSE Excel download. If you have any queries or feedback, please feel free to contact us or leave a comment below. Here are some FAQs that may be useful for you: Q1: What is the difference between fair market value and book value?
A1: Book value is the value of an asset as recorded in the books or accounts of a company. It is usually based on the historical cost or the original purchase price of the asset. Book value may not reflect the current market conditions or the true worth of the asset. Fair market value is the estimated price at which an asset would sell in a competitive and open market. It is based on the current demand and supply of the asset and its expected future performance. Fair market value may differ from book value due to various factors, such as depreciation, appreciation, obsolescence, or impairment.
Q2: How to find the fair market value of shares for other dates?
A2: You can use the same methods and steps as explained in this article to find the fair market value of shares for other dates. You just need to download the NSE data for the date you are interested in and apply the relevant adjustments for interest, dividends, etc. You can also use other sources of data, such as financial websites, newspapers, magazines, or reports, to find the prices of similar or comparable assets in the market.
Q3: How accurate is the fair market value calculated using NSE data?
A3: The fair market value calculated using NSE data is an estimate based on certain assumptions and methods. It may not be exact or precise due to various factors, such as errors, omissions, biases, or uncertainties in the data or the methods. Therefore, it is advisable to use more than one method to calculate fair market value and compare the results. You should also consult a professional appraiser or a financial advisor if you need more guidance or accuracy.
Q4: How often should I calculate the fair market value of my shares?
A4: The frequency of calculating the fair market value of your shares depends on your purpose and need. If you are a taxpayer who needs to report the fair market value of your shares for capital gains tax calculation, you should calculate it at least once a year or whenever you sell your shares. If you are an investor who wants to evaluate your portfolio performance or make investment decisions, you should calculate it at least quarterly or monthly or whenever there is a significant change in the market conditions or the company performance.
Q5: Where can I find more information about fair market value and NSE?
A5: You can find more information about fair market value and NSE from the following sources:
The official website of NSE at .
The official website of Income Tax Department of India at .
The official website of Securities and Exchange Board of India (SEBI) at .
The official website of Investopedia at .
The official website of The Economic Times at .
44f88ac181