CSE-Price&Volume Tracker| Weekly Up & Down Counters

nuwandwo
Member
Member
Posts: 58
Joined: Sat Nov 25, 2017 1:12 pm
Flag: Sri Lanka

CSE-Price&Volume Tracker| Weekly Up & Down Counters

Postby nuwandwo » Sat Jan 27, 2018 11:38 am

Fellow Members ,

I have formulated a tracker based on price & volume starting from 2nd Jan. I will post the Price Up & Down counters for each sectors ( some sort of dashboard) weekly basis , but you can find the daily prices in my excel . Hope someone will get benefit from this. Following assumptions were considered when formulating the tracker.

Assumptions:-
* Price is calculated based End Day price
* If particular stock didn't trade in that week , i have considered last week price
* Weekly Growth is calculated based to 1st week that particular counter traded in 2018.

P.S :- At the same time , guys if you found any mismatches in my data , please do correct me.

Bank Finance & Insurance UP & Down
BFI Up.JPG
BFI Down.JPG


Beverage Foods & Tobaco UP & Down
BF Up.JPG
BF Down.JPG


Construction & Engineering UP & Down
C& E.JPG


Footwear & Textile UP & Down
F&T.JPG


Healthcare UP & Down
H.JPG


Hotels & Travels UP & Down
H&T Up.JPG
H&T Down.JPG


Excel - Tracker
https://drive.google.com/open?id=1Y6AiH ... koJ8E09HEq


Cheers.
P.S :- I can only attach 10 images, can we remove this limitation. Thanks
You do not have the required permissions to view the files attached to this post.

User avatar
Blue Whale
Equity Analyst
Equity Analyst
Posts: 7384
Joined: Mon Oct 26, 2015 7:14 am
Location: Asia
Flag: Sri Lanka

Re: CSE-Price&Volume Tracker| Weekly Up & Down Counters

Postby Blue Whale » Sat Jan 27, 2018 12:24 pm

Very well done Nuwan. We are looking forward people like you here more and more. Please carry on.
Value Invest Profit

User avatar
SHARK
Savant
Savant
Posts: 14605
Joined: Sun Jan 11, 2015 10:03 pm
Location: Abu Dhabi
Flag: Sri Lanka
Contact:

Re: CSE-Price&Volume Tracker| Weekly Up & Down Counters

Postby SHARK » Sun Jan 28, 2018 1:00 am

Thanks nuwan.
Great contribution
Price is what you pay. Value is what you get.”

User avatar
NC+
Moderator
Moderator
Posts: 2626
Joined: Wed Oct 12, 2016 3:43 pm
Flag: Sri Lanka

Re: CSE-Price&Volume Tracker| Weekly Up & Down Counters

Postby NC+ » Sun Jan 28, 2018 6:36 am

Thanks Nuwan... Keep up the good work.. :-bd
"Letting your emotions over-ride your plan or system is the biggest cause of failure."

User avatar
GB
Top Contributor
Top Contributor
Posts: 938
Joined: Fri Aug 26, 2016 3:23 pm
Flag: Sri Lanka

Re: CSE-Price&Volume Tracker| Weekly Up & Down Counters

Postby GB » Sun Jan 28, 2018 7:40 am

Thanks nuwan. Good presentation ...

nuwandwo
Member
Member
Posts: 58
Joined: Sat Nov 25, 2017 1:12 pm
Flag: Sri Lanka

Re: CSE-Price&Volume Tracker| Weekly Up & Down Counters

Postby nuwandwo » Mon Feb 05, 2018 1:43 pm

Dear Members,

Please find the update for week ending 2/2/2018 .

Price Up Counters ( More than 10%) - Compared to Jan 1st Week Traded
10%Counters.JPG


Price Down Counters ( More than 10%) - Compared to Jan 1st Week Traded
10%Counters_Down.JPG


Price Up Counters ( More than 10%) - WoW Change - Compared to Last Week Traded
WoW_UP Counters.JPG


Price Down Counters ( More than 10%) - WoW Change - Compared to Last Week Traded
WoW_Down Counters.JPG



Tracker - https://drive.google.com/open?id=1Y6AiH ... koJ8E09HEq
Cheers
You do not have the required permissions to view the files attached to this post.

User avatar
Blue Whale
Equity Analyst
Equity Analyst
Posts: 7384
Joined: Mon Oct 26, 2015 7:14 am
Location: Asia
Flag: Sri Lanka

Re: CSE-Price&Volume Tracker| Weekly Up & Down Counters

Postby Blue Whale » Tue Feb 06, 2018 7:27 am

Many thanks Nuwan for your effort.
Value Invest Profit

PAT
Moderator
Moderator
Posts: 6275
Joined: Sun Nov 15, 2015 4:40 pm
Flag: Australia

Re: CSE-Price&Volume Tracker| Weekly Up & Down Counters

Postby PAT » Wed Feb 07, 2018 7:35 am

Thanks nuwan

Continue the good work
Live Today........
Without compromising your ability to Live Tomorrow……… :)

nuwandwo
Member
Member
Posts: 58
Joined: Sat Nov 25, 2017 1:12 pm
Flag: Sri Lanka

Re: CSE-Price&Volume Tracker| Weekly Up & Down Counters

Postby nuwandwo » Sun Feb 11, 2018 8:13 pm

Dear All,

Please find the update for the week ending 2/9/2018 .

ASI Movement
ASI.JPG


Top Counters( Growth more than 10% compared to 1st week traded in 2018)
10%Counters_2nd Week.JPG

10%Counters_2nd Week_2.JPG


Worst Performing Counters( Growth less than 10% compared to 1st week traded in 2018)
10%Counters_Down_2nd Week.JPG


Excel File :- https://drive.google.com/open?id=1Y6AiH ... koJ8E09HEq

Thanks,
nuwandwo
You do not have the required permissions to view the files attached to this post.


Return to “Stock Market Talkz”

Who is online

Users browsing this forum: Google [Bot] and 1 guest