Scribd
Upload
27 views5 pages

SQL - Stock Market Analysis

The document outlines stock market analysis for six companies, detailing buy and sell opportunities, stock trends, and percentage changes in stock value over a specified period. Eicher Motors, TCS, and TVS Motors show declining trends, while Bajaj Auto and Infosys indicate potential for returns. The final report suggests buying Bajaj Auto and Infosys, while recommending selling Eicher Motors, TVS Motors, Hero Motocorp, and TCS.

Uploaded by

D3K P
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPTX, PDF, TXT or read online on Scribd
27 views5 pages

SQL - Stock Market Analysis

The document outlines stock market analysis for six companies, detailing buy and sell opportunities, stock trends, and percentage changes in stock value over a specified period. Eicher Motors, TCS, and TVS Motors show declining trends, while Bajaj Auto and Infosys indicate potential for returns. The final report suggests buying Bajaj Auto and Infosys, while recommending selling Eicher Motors, TVS Motors, Hero Motocorp, and TCS.

Uploaded by

D3K P
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPTX, PDF, TXT or read online on Scribd
You are on page 1/ 5

SQL- Stock Market Analysis

- 6 Data sets
- As a submission part →
- You have to submit
- 1. You have to do analysis in SQL (SQL file)
- 2. You have to create a PDF for your insights..(PDF file)
- 3. Upload a video
• Eicher Motors
➢ Eicher’s Stock could have been bought 6 times, sold 7 times in the provided time
period.
➢ Eicher’s Stock Trend as of 06-06-2018 is shifting down.
➢ Date: 31-07-2018: 27820.95, 01-01-2015: 15239.15 results in 82.5% increase in stock
value.
• Bajaj Auto
➢ Bajaj Auto Stock could have been bought 12 times, sold 11 times in the provided
time period.
➢ Bajaj Auto Stock’s trend as of 21-06-2018 is shifting up.
➢ Date: 31-07-2018 :2700.7, 01-01-2015 :2454.1 results in 10% increase in stock value.
• TCS
➢ TCS Stock could have been bought 12 times, sold 13 times in the provided time
period.
➢ TCS Stock’s Trend as of 05-06-2018 is shifting down.
➢ Date: 31-07-2018 : 2548.20, 01-01-2015 :2454.1 results in 23.8% decrease in stock
value.
• TVS Motors
➢ TVS Stock could have been bought 8 times, sold 8 times in the provided time period.
➢ TVS Stock Trend as of 17-05-2018 is shifting down.
➢ Date: 31-07-2018: 517.45, 01-01-2015: 276.85 results in 86.9% increase in stock
value.
• Hero Motocorp
➢ Hero Motocorp Stock could have been bought 9 times, sold 9 times in the provided
time period.
➢ Hero Motocorp Stock Trend as of 22-05-2018 is shifting down.
➢ Date: 31-07-2018: 3293.8, 01-01-2015: 3107.3 results in 6% increase in stock value.
• Infosys
➢ Infosys Stock could have been bought 9 times, sold 9 times in the provided time
period.
➢ Infosys Stock Trend as of 07-05-2018 is shifting up.
➢ Date: 31-07-2018: 1365, 01-01-2015: 1975.8 results in 3% decrease in stock value.
Final Report:
➢ Stocks that can be bought in likelihood of returns are Bajaj Auto, Infosys.
➢ Stocks that can be sold in likelihood of returns are Eicher Motors, TVS Motors, Hero
Motocorp, TCS

You might also like