Nifty50 - A Detailed Report (2022-Feb-09)

Name : Industry : Weight : Ticker Symbol : Max Change
1.	Reliance Industries Ltd.	
Energy - Oil & Gas	
10.56%
NSE: RELIANCE
Max: 4,397.26%



2.	HDFC Bank Ltd.	
Banking	
8.87%
NSE: HDFCBANK
Max: 27,044.93%



3.	Infosys Ltd.	
Information Technology	
8.62%
NSE: INFY
Max: 14,904.31%



4.	ICICI Bank Ltd.	
Banking	
6.72%
NSE: ICICIBANK
Max: 19,581.37%



5.	Housing Development Finance Corporation Ltd.	
Financial Services	
6.55%
NSE: HDFC
Max: 11,002.82%



6.	Tata Consultancy Services Ltd.	
Information Technology	
4.96%
NSE: TCS
Max: 3,026.11%



7.	Kotak Mahindra Bank Ltd.	
Banking	
3.91%
NSE: KOTAKBANK
Max: 76,383.33%



8.	Larsen & Toubro Ltd.	
Construction	
2.89%
NSE: LT
Max: 10,273.22%



9.	Hindustan Unilever Ltd.	
Consumer Goods	
2.81%
NSE: HINDUNILVR
Max: 1,273.49%



10.	ITC Ltd.	
Consumer Goods	
2.63%
NSE: ITC
Max: 1,258.62%



11.	Bajaj Finance Ltd.	
Financial Services	
2.52%
NSE: BAJFINANCE
Max: 2,472.71%


12.	State Bank of India 	
Banking	
2.40%
NSE: SBIN
Max: 3,454.01%



13.	Bharti Airtel Ltd.	
Telecommunication	
2.33%
NSE: BHARTIARTL
Max: 3,589.90%



14.	AXIS Bank Ltd.	
Banking	
2.29%
NSE: AXISBANK
Max: 23,676.63%



15.	Asian Paints Ltd.	
Consumer Goods	
1.92%
NSE: ASIANPAINT
Max: 27,092.34%



16.	HCL Technologies Ltd.	
Information Technology	
1.68%
NSE: HCLTECH
Max: 863.31%



17.	Bajaj Finserv Ltd.	
Financial Services	
1.41%
NSE: BAJAJFINSV
Max: 2,472.71%



18.	Titan Company Ltd.	
Consumer Goods	
1.35%
NSE: TITAN
Max: 58,143.56%



19.	Tech Mahindra Ltd.	
Information Technology	
1.30%
NSE: TECHM
Max: 975.59%



20.	Maruti Suzuki India Ltd.	
Automobile	
1.28%
NSE: MARUTI
Max: 5,069.17%



21.	Wipro Ltd.	
Information Technology	
1.28%
NSE: WIPRO
Max: 4,026.81%



22.	UltraTech Cement Ltd.	
Cement	
1.17%
NSE: ULTRACEMCO
Max: 2,762.54%



23.	Tata Steel Ltd.	
Metals	
1.14%
NSE: TATASTEEL
Max: 1,652.77%



24.	Tata Motors Ltd.	
Automobile	
1.12%
NSE: TATAMOTORS
Max: 1,479.58%



25.	Sun Pharmaceutical Industries Ltd.	
Pharmaceuticals	
1.10%
NSE: SUNPHARMA
Max: 38,939.65%



26.	Mahindra & Mahindra Ltd.	
Automobile	
1.09%
NSE: M&M
Max: 3,953.25%



27.	Power Grid Corporation of India Ltd.	
Energy - Power	
0.96%
NSE: POWERGRID
Max: 178.26%



28.	Nestle India Ltd.	
Consumer Goods	
0.93%
NSE: NESTLEIND
Max: 628.12%



29.	Grasim Industries Ltd.	
Cement	
0.86%
NSE: GRASIM
Max: 3,554.15%



30.	HDFC Life Insurance Co. Ltd.	
Insurance	
0.86%
NSE: HDFCLIFE
Max: 74.09%



31.	Divi’s Laboratories Ltd.	
Pharmaceuticals	
0.84%
NSE: DIVISLAB
Max: 48,055.56%



32.	Hindalco Industries Ltd.	
Metals	
0.82%
NSE: HINDALCO
Max: 1,120.50%



33.	JSW Steel Ltd.	
Metals	
0.82%
NSE: JSWSTEEL
Max: 1,598.23%



34.	NTPC Ltd.	
Energy - Power	
0.82%
NSE: NTPC
Max: 114.66%



35.	Dr. Reddy’s Laboratories Ltd.	
Pharmaceuticals	
0.77%
NSE: DRREDDY
Max: 6,989.02%



36.	IndusInd Bank Ltd.	
Banking	
0.72%
NSE: INDUSINDBK
Max: 4,266.52%



37.	Oil & Natural Gas Corporation Ltd.	
Energy - Oil & Gas	
0.70%
NSE: ONGC
Max: 630.89%



38.	SBI Life Insurance Co.	
Insurance	
0.69%
NSE: SBILIFE
Max: 62.03%



39.	Adani Port and Special Economic Zone	
Infrastructure	
0.68%
NSE: ADANIPORTS
Max: 294.38%



40.	Cipla Ltd.	
Pharmaceuticals	
0.67%
NSE: CIPLA
Max: 4,020.15%



41.	Tata Consumer products Ltd.	
Consumer Goods	
0.63%
NSE: TATACONSUM
Max: 3,291.92%



42.	Bajaj Auto Ltd.	
Automobile	
0.57%
NSE: BAJAJ-AUTO
Max: 1,226.10%



43.	Britannia Industries Ltd.	
Consumer Goods	
0.57%
NSE: BRITANNIA
Max: 5,936.41%



44.	UPL Ltd. 	
Chemicals	
0.51%
NSE: UPL
Max: 64,233.33%



45.	Bharat Petroleum Corp. Ltd.	
Energy - Oil & Gas	
0.48%
NSE: BPCL
Max: 1,806.20%



46.	Shree Cement Ltd.	
Cement	
0.47%
NSE: SHREECEM
Max: 84,322.44%



47.	Eicher Motors Ltd.	
Automobile	
0.45%
NSE: EICHERMOT
Max: 215,785.25%



48.	Coal India Ltd.	
Mining	
0.43%
NSE: COALINDIA
Max: -51.49%



49.	Hero MotoCorp Ltd.	
Automobile	
0.43%
NSE: HEROMOTOCO
Max: 2,411.03%



50.	Indian Oil Corporation Ltd.	
Energy - Oil & Gas	
0.41%
NSE: IOC
Max: 581.56%



What is the eligibility criteria for selection of Nifty 50 stocks?



Eligibility Criteria for Selection of Constituent Stocks:
i. Market impact cost is the best measure of the liquidity of a stock. It accurately reflects the costs faced when actually trading an index. For a stock to qualify for possible inclusion into the NIFTY50, have traded at an average impact cost of 0.50% or less during the last six months for 90% of the observations, for the basket size of Rs. 100 Million.
ii. The company should have a listing history of 6 months.
iii. Companies that are allowed to trade in F&O segment are only eligible to be constituent of the index.
iv. A company which comes out with an IPO will be eligible for inclusion in the index, if it fulfills the normal eligibility criteria for the index for a 3 month period instead of a 6 month period. 

Tags: Investment,Management,

Stock Tips (2022-Feb-8)

Yes Bank

On Feb-9, it might go to 14.60 INR.
It can test out even 15 INR as well.

Volume is also good.
Very prospective stock for tomorrow.
It has breached 200 EMA (Exponential Moving Average).

It has attempted to come above 15 INR a couple of times before.

- - - - - 

Blue Star

It has broken 200 EMA.
25% appreciation between 31-Jan-2022 and 7-Feb-2022.

It makes even more sense to buy this stock today in February as the summers are coming (not joking).

It is a 'Cyclic Seasonal Stock'.

- - - - - 

Century Plyboards 

Good stock but showing resistance at 630 INR. 

Blue Star - 1 Month

Blue Star - Max (Since 2001)

Century Plyboards - 6 Months

Century Plyboards - 5 Years

Yes Bank - 5 Days

Yes Bank - 6 Months

Tags: Investment

Audience Around The World (Feb 2022)

Doughnut Chart Countries

World Heat Map

List of Top 20 Countries with View Counts

Top Locations

1. India
2. United States
3. Germany
4. Russia
5. United Arab Emirates
6. Kenya
7. United Kingdom
8. Singapore
9. Canada
10. Netherlands
11. France
12. Brazil
13. Ukraine
14. Philippines
15. Hong Kong
16. Australia
17. Pakistan
18. Japan
19. Poland

Past 3 Months - Daily Views

Tags: Investment,Management,

The Cube Report (A beginning)

Index of Journals

"Do not bite what you cannot chew" the saying goes, and I did just exactly that when I joined the Gurugram office of Mobileum in the summers 2015.
It was an interesting project, one of it's own kind with respect to any  previous work done using iMAS.
Projects built using iMAS were tabular reports and configuration screens, and I thought I could build an OLAP report as my first project in a proprietary technology that was completely new to me, and while not knowing it's limitations.
But that's not how it began.
It began from that morning call from Bengaluru by Sneha Kiran (my manager).
She was going to discuss a task she had in mind for me as I had bandwidth that time.

Sneha would also have the then-lead Aniket with her on such calls for discussing the technical and implemention details.

I would like to digress a bit here: But the thing about these kind of stories is that these are 'stories', and there are three versions of it. My version of the story. His or her version of the story. And the outsider's version of the story. Still, as a writer, it is my duty to end such posts on a conclusion.

I wasn't very fond of Aniket back then. He is friendly, speaks softly but that is over generalization of what Aniket is like. We can say similar things about Sneha as well that she is a nice and caring person. But it is a completely different ball game when the people you are dealing with are your manager and to-be team lead, and not your friends.

The first estimate I got for this assignment was of a week under the conditions that I was a newbie to the iMAS and in the team.

Aniket was confident that he could build that report in 2-3 days so I had to accept that week's period to finish the report.

He was not right but he was not wrong either since requirements are supposed to be discussed and not accepted as is. The requirement given to me was not feasible with the approach I had taken. Aniket's estimate was coming from a type of report they used to call 'Drill Down Reports' in the GUI team. But this task wasn't about that.

I was working day and night. I was in working on weekdays and weekends. I was working in cab and on Metro floor. I was working in office and at home. It was a two months long mayhem that ended up with me breaking down over email before Engineering Vice President of the company.

I was trying to prove that I deserved this OLAP report or Ad-Hoc Report or Cube Report assignment. Also, when I look back at myself during that phase in time, I think that the egotistic tendencies in me brought out the worse in me and put me in a bad situation with my team, colleagues and seniors at work.
I was not only new to technology but also to the soft skills of communication, reading people and personalities, and the corporate politics.
That would be the end of the beginning. The next part would start with how I had to work with two managers for this project and I ended up working with neither.
Last line is a bit strongly worded but I do think I was out of sync with both the managers.

Tags: Journal,Management,

Stock Tips 2022-Feb-7

Yes Bank

At 14.25, it has 200 EMA (Expotential Moving Average). 14.95 is it's resistance. If it breaks 15, then it might go to 18.

Kalpataru Power

It has come above 200 EMA.

Aarti Drugs Ltd.

It has come above 200 EMA in 'Hourly Candle'. For 'Daily Candle', it will try to come above 200 EMA.

Dhani Services Ltd.

It is about to break previous resistance.

Castrol India Limited

Div yield: 4.42% Very good dividend yield.

In Images:

Aarti drugs ltd - 5 Years

Castrol - 1 Days

Dhani - 5 Days

Kalpataru power - 5 Days

Yes bank - 5 Days

Nifty50 - 5 Years

Tags: Investment,

BODMAS - Step by Step Working (Grade 6A)

BODMAS: Brackets of Division, Multiplication, Addition, Subtraction

Set the difficulty level:  

To solve the problem, we are following the way Google processes our above question, i.e., left to right.
Also, to simplify calculations, we are rounding off answer from division part to the lower integer, i.e. floor function.

Tags: Mathematical Foundations for Data Science,

Stock Tips 2022-Feb-7

CDSL
% Consolidating since Oct-Nov 2020.
% It can give breakout on positive side.
% Stamp Duty, Transactional Revenue goes to CDSL.
% Volume of trading goes up every day, so CDSL is a good stock to buy.

HCL Technologies
% It has closed above 200 EMA (Exponential Moving Average).

Lux Industries
% It is attempting to come above 200 EMA, which it recently broke.

IEX
% Hold a little.
% Monopoly business.
% Good consolidation has happened in past couple of months.
% Ready to rock and roll in coming months. 

All four of these stocks are good from long term perspective.

When you think long-term, you can put 10%-15% stop-loss for a return of 25%-30%.

1. BSE - 1 Day



2. BSE - Past 6 Months



3. BSE - Past Year



4. BSE - Past 5 Years 



5. CDSL - 1 Day



6. CDSL - Past 5 Days
 



7. CDSL - Past 6 Months
 



8. CDSL - Past Year



9. CDSL - Past 5 Years



10. HCL - Past 5 Years



11. IEX - Past 5 Years



12. Lux Ind. - 1 Day
 
NSE: LUXIND 



13. Lux Ind. - Past 5 Days
  

Tags: Technology,Investment

Create Table Statement and Constraints Assignment

Table Creation and Data insertion:
Create following Tables with required constraints (as mentioned) using SQL DDL. 

Table: Student

sid (int) Primary Key	sname Varying Char (10)	sbranch Char(5)	sage (int) (not greater than 25)
1001	Kamal	IT	18
1004	Yogesh	IT	17
1011	Mani	CSE	20
1022	Farooq	EEE	21
1027	Girija	CSE	24
1030	Mousmi	CSE	22
1036	Rajanish	EEE	21
1052	Praneet	EEE	21
1059	Joseph	CSE	17
1063	Lahiri	IT	21

Table: Course

cid (int) PK	Cname (chars 4 and unique)	units (int)
10	OS	3
20	DBMS	4
30	CNW	5
40	PHY	3

Table: StudentCourse

stid PK1 and FK to sid of student	cno PK2 and FK to cid of course
1001	20
1001	30
1004	10
1004	20
1004	30
1004	40
1027	20
1027	30
1036	10
1036	30
1036	20
1059	10
1063	20

Solution

DDL: Data Definition Language
 - create 
 - alter 
 - drop

DML: Data Manipulation Language 
 - select 
 - insert 
 - update 
 - delete 

Microsoft SQL Server
How to add a "Check Constraint" on a column:
CREATE TABLE CountryList (
  Id INT IDENTITY PRIMARY KEY,
  CountryName VARCHAR(255) NOT NULL,
  CountryPopulation INT CHECK(CountryPopulation > 0)
)

ALTER TABLE student ADD CONSTRAINT CheckSage CHECK (sage > 25);

Adding a "Foreign Key"
CREATE TABLE Orders (
    OrderID int NOT NULL,
    OrderNumber int NOT NULL,
    PersonID int,
    PRIMARY KEY (OrderID),
    FOREIGN KEY (PersonID) REFERENCES Persons(PersonID)
); 

Creating a 'Composite Primary Key'
Create table StudentCourse ( stid  integer FOREIGN Key REFERENCES Student (sid) , 
cno integer Foreign Key References Course (cid),
PRIMARY KEY (stid, cno) ); 

A mistake that students make...
Create table StudentCourse ( stid  integer Primary Key FOREIGN Key REFERENCES Student (sid), 
cno integer PRIMARY key Foreign Key References Course (cid) );

Msg 8110, Level 16, State 0, Line 1
Cannot add multiple PRIMARY KEY constraints to table 'StudentCourse'. 

Oracle DB

SQL> create table student_ashish_12345 (sid int primary key, sname varchar2(10), sbranch char(5), sage int constraint stud_sage_ck check (sage <= 25));

SQL> create table course_ashish_12345 (cid int primary key, cname char(4) unique, units int);

SQL> create table studentcourse_ashish_12345 (stid int, cno int, constraint sc_pk primary key(stid, cno), constraint sc_fk1 foreign key (stid) references bits_student (sid), constraint sc_fk2 foreign key (cno) references bits_course (cid));

SQL> select table_name from tabs where table_name like '%ASHISH_12345';

Tags: Database,Technology,

Stock Tips 2022-Feb-05

Apollo Hospitals - One Day

Apollo Hospitals - Past 5 years

Apollo Hospitals - All Time

Asian Paints - 1 Day

HDFC AMC - All Time

Nifty50 - All Time

Tags: Investment,