Top Indian Stocks: Market Insights Dataset
Stocks Market Insights
@kaggle.rameshmaity_top_indian_stocks_market_insights_dataset
Stocks Market Insights
@kaggle.rameshmaity_top_indian_stocks_market_insights_dataset
Top Indian Stocks: Financial Metrics Dataset
This dataset offers a comprehensive view of key financial indicators for the top-performing stocks in India. With insights into valuation, profitability, and performance, this dataset is a perfect tool for investors, analysts, and data enthusiasts to explore stock market trends.
๐ Columns Overview
S.No.
๐น Description: The serial number for each stock.
๐ก Use: Index for easy row reference, not a financial indicator.
Name
๐น Description: The stock's name or ticker symbol.
๐ก Use: Identifies each company for further analysis.
CMP (Current Market Price) Rs.
๐ฐ Description: The latest trading price of the stock in Indian Rupees (โน).
๐ก Use: Critical for assessing the current market valuation of the stock.
P/E (Price-to-Earnings Ratio)
๐ Description: Ratio of the companyโs stock price to its earnings per share.
๐ก Use: A key indicator to determine if a stock is over- or under-valued.
MarCap (Market Capitalization) Rs.Cr.
๐ข Description: The companyโs total market value, in crores of Indian Rupees.
๐ก Use: Helps categorize companies as large-cap, mid-cap, or small-cap.
DivYld (Dividend Yield) %
๐ธ Description: The dividend income as a percentage of the stock price.
๐ก Use: Useful for investors seeking steady income through dividends.
NPQtr (Net Profit for the Quarter) Rs.Cr.
๐ Description: The companyโs net profit for the latest quarter in crores.
๐ก Use: A measure of recent profitability and financial health.
QtrProfitVar (Quarterly Profit Variation) %
๐ Description: Percentage change in profit from the previous quarter.
๐ก Use: Helps evaluate the companyโs growth or decline in profitability.
SalesQtr (Quarterly Sales) Rs.Cr.
๐ผ Description: Total revenue generated by the company during the quarter.
๐ก Use: Useful to gauge the business's short-term performance.
QtrSalesVar (Quarterly Sales Variation) %
๐ Description: Percentage change in sales compared to the previous quarter.
๐ก Use: Highlights revenue growth or contraction over time.
ROCE (Return on Capital Employed) %
โ๏ธ Description: Measures the companyโs profitability relative to the capital used.
๐ก Use: A higher ROCE shows better efficiency in using capital for profits.
PATAnn (Profit After Tax for the Year) Rs.Cr.
๐
Description: Net profit after taxes for the entire year.
๐ก Use: Key to understanding long-term profitability and financial performance.
Why Use This Dataset?
With a variety of financial metrics covering stock performance, this dataset is perfect for:
๐
Time-Series Analysis: Forecast stock price movements using historical data.
๐ Investment Research: Analyze market trends and evaluate stock performance.
๐ค Algorithmic Trading: Develop machine learning models to create automated trading strategies.
๐ Financial Forecasting: Build predictive models to anticipate stock prices and market shifts.
This dataset offers rich financial insights and is a must-have for anyone looking to dive deep into Indiaโs stock market landscape. Explore trends, develop predictive models, and take your financial analytics to the next level! ๐ฅ๐
CREATE TABLE stock_data (
"s_no" DOUBLE -- S.No.,
"name" VARCHAR,
"cmp_rs" DOUBLE -- CMP Rs.,
"p_e" DOUBLE,
"marcap_rs_cr" DOUBLE -- MarCap Rs.Cr.,
"divyld" DOUBLE -- DivYld %,
"npqtr_rs_cr" DOUBLE -- NPQtr Rs.Cr.,
"qtrprofitvar" DOUBLE -- QtrProfitVar %,
"salesqtr_rs_cr" DOUBLE -- SalesQtr Rs.Cr.,
"qtrsalesvar" DOUBLE -- QtrSalesVar %,
"roce" DOUBLE -- ROCE %,
"patann_rs_cr" DOUBLE -- PATAnn Rs.Cr.
);Anyone who has the link will be able to view this.