ARUN M
dsiarun1@gmail.com
LIVE SHARE PRICE
TO WORKSHEETS
Overview
About the Project: How to link live share prices to worksheets
Enhancing financial analysis, I successfully incorporated live share prices directly into spreadsheets. Both
Google Sheets and Excel provide tools to simplify this integration. The main goal is to track stocks from
diverse industries efficiently for easier filtering and informed investment decisions. Instead of manually
adding stock prices from various industries, we can access them via the Data tab in Excel but involves
more amount of time and effort, to avoid we have utilized add-on for Excel and for Google Sheets with In-
built function.
About Live Share Prices
Does the solution provide immediate updates, or is there a time lag between the market price and the
data reflected in the spreadsheet?. Can users tailor the information displayed, allowing them to focus
on specific stocks and relevant financial metrics beyond just the price? Are there any
subscription fees associated with accessing live data, or is the service offered free of charge?
The Project
Problem: Manual stock price research is time-consuming and increases the likelihood of errors when
selecting promising stocks. Failures to promptly update prices may result in missed investment prospects
or flawed analysis.
Goals
1. How important is it for you to have access to real-time share prices in your spreadsheets?
2. How do you currently obtain share prices for your financial analysis?
3. How often do you typically make investment decisions based on financial analysis?
Objectives
Enhance Financial Understanding: My objective is to assist users in understanding financial
concepts, analyzing data, and identifying potential opportunities or risks.
Support Financial Research: This can be a valuable tool for researchers by processing large
datasets, performing calculations, and generating reports.
Provide Educational Tools: Can be used to create educational content and simulations to help
users learn about financial concepts and decision-making processes.
Target Audience
User Persona Individual investors actively managing their portfolios.
Financial analysts and professionals requiring real-time market data for
research and decision-making.
Demographic Traits 1. Young Investor Base
2. Rising Middle Class
Goals How do you currently obtain share prices for your financial analysis?
How will they 1. Excel spreadsheets displaying live share prices alongside other
perceive or use this financial data.
project's outputs? 2. Automated updates reflecting real-time market movements.
3. Improved efficiency and accuracy in financial analysis and investment
decision-making.
Cost No cost Involved for getting stock price
Deliverables
Designed by Deliverables Specification
Google Sheets Provides share prices Tend to have 4000+ BSE stocks
delayed up to 20mins which are similar to NSE by built in
function of google sheets
Tends to provide live stocks price by
Microsoft Excel Provides Live Share Price
add-ons provide real-time stock data
Requirements
Step 1 :- Get data in CSV from BSE website https://www.bseindia.com/corporates/List_Scrips.html
Save as Macro-Enabled Workbook
Only filter with Active Group
Other requirements
Google Sheets Excel
No Demant Account Demat Account
No add-on Software Add-on Software
Use of Formulas No formulas used
Pivot Table No pivot Table
No Cell Referencing Cell Referencing
Google Sheet-Share Price
Step 1:-
=IF(ISBLANK($A$1),"",A1&":")&A4
Use Cell reference for A1
Step 2:-
Go to Google Finance
Now the last step
Drag both Stock ID and Live Share Price
Other attribute that can be used
Select all & Add a PIVOT Table
Add Required ROWS
Security Code
Security Name
Live Share Price
ISubgroup Name
Uncheck totals
Select Column Required
Here we want Sector and ISubgroup Name
We can now use a slicer to filter by Sector and Subgroup, enabling us to accurately evaluate Share Price
and make Investment Decisions. Additionally, we can incorporate other attributes such as EPS and PE to
enhance our analysis.
Google Sheets have mentioned that usually there will be delayed up to 20mins but when we search
through delay attribute for NSE there is no delay.
Excel-Share Price
Download FYERS and Get Verified with your Demat Account through Mobile
Then Download FYERS ONE in PC
To access the website and download the PC application, simply double-click on the post above.
After Installing the software into PC
Give User Control Access-YES
Login through Mobile Number or Client ID
Link to EXCEL
Excel- Run as Administrator and Rename & Save As the file in Macro-Enabled Workbook
Again go to Link to Excel and Paste here
Now we have an Excel which contains Nifty 50 Stocks with live prices
Contact Information
For any questions or clarifications, please reach out to the project lead:
Arun M
Aru722671@gmail.com
dsiarun1@gmail.com
