FREE PSE STOCKS WEEKLY-DAILY SCREENER TOOL
Hi Traders,
Thanks for visiting my Blog!
I'm RDC, stocks investor/trader just like you. I've been trading stocks for few years now, not claiming to be an expert already... still learning : )
Let me share to you my tool and I really hope that it will somehow help you in your trading journey just like it helps me with mine.
Let me share to you my tool and I really hope that it will somehow help you in your trading journey just like it helps me with mine.
This blog is about my PSE Stocks Weekly-Daily Screener Tool (Excel), although still under development, its a working usable version already. I developed this tool mainly because of my interest in stocks trading and driven by my eagerness to master the art of Technical/Chart Analysis.
Personally, I believe in the power and success of chart analysis in trading especially when done correctly with the right indicators/oscillators like the macd, rsi, stochastics, cci, moving averages, fibonacci golden ratios, ichimoku cloud, etc. These indicators help us decide in choosing the right stock to buy at the right time. However, with more than 250 stocks active in the PSE Market today, it could be very laborious to scan and analyze all the stocks just to look for bullish signals in the hope that we can ride and would not miss any uptrend or breakout - not to mention the time you would spend to do such tedious exercise. What a waste of your precious time right? Luckily nowadays, there are many trading websites, blog sites, mobile apps, etc. that offer stocks screening tool for free. In my opinion, I would say Investagram is one of the most popular out there, because apart from being free, it is easy to use and with interactive trading platform and contents which are really helpful to the traders in many ways.
Don't get me wrong, but unfortunately sometimes even the best screener there is available online, it still doesn't seem to cater to all our needs (for free) specially when it comes to our personal screening preferences. Desperately, I have tried many times to search to find a site or app that offers a complete and comprehensive stocks screener that provides option for the trader to screen base on fibonacci ratios, ichimoku clouds and lines, and screen through weekly chart, but to my surprise I found nothing. I don't think nobody has thought of this or nobody has done some screener like this before. Maybe there is, but the author is just not willing to share it to the trading public, let alone for free.
I know for sure that there are growing number of traders (me included) who use these mentioned indicators/criteria in their day-to-day chart analysis. So, I can only imagine how they will be delighted to find these in a screener tool and help them cut the chase of going through the normal process of scanning through hundreds of charts. Take for example an Ichimoku trader who would want to filter stocks with TS crossed above KS, stocks with price above cloud, stocks with cloud flat top, stocks with price just broken above cloud resistance, and many other ichimoku bullish signals. How about filtering stocks with prices currently sitting at fibonacci pullback supports 38.2%, 61.8%, 78.6% which are as we know a very strong signal for bullish reversal? How about MA/Price crosses, AOTS, Zues' Strike, 123System, Breakouts, and more in just one click in a screener? Moreover, how about screening through the WEEKLY chart with all the criteria mentioned above? Weekly Chart? Are all these even possible? What about knowing if a stock is a Bluechip, Top-Liner, Mid-Liner, or Zubaru in one glance? Well, let's find out. See screenshots below:
Sample 1: Stocks on a daily chart filtered by MA9 crossed above MA50 inside Ichimoku cloud/kumo >> the result are stocks candidate for bullish reversal rally soon.
I know for sure that there are growing number of traders (me included) who use these mentioned indicators/criteria in their day-to-day chart analysis. So, I can only imagine how they will be delighted to find these in a screener tool and help them cut the chase of going through the normal process of scanning through hundreds of charts. Take for example an Ichimoku trader who would want to filter stocks with TS crossed above KS, stocks with price above cloud, stocks with cloud flat top, stocks with price just broken above cloud resistance, and many other ichimoku bullish signals. How about filtering stocks with prices currently sitting at fibonacci pullback supports 38.2%, 61.8%, 78.6% which are as we know a very strong signal for bullish reversal? How about MA/Price crosses, AOTS, Zues' Strike, 123System, Breakouts, and more in just one click in a screener? Moreover, how about screening through the WEEKLY chart with all the criteria mentioned above? Weekly Chart? Are all these even possible? What about knowing if a stock is a Bluechip, Top-Liner, Mid-Liner, or Zubaru in one glance? Well, let's find out. See screenshots below:
Sample 1: Stocks on a daily chart filtered by MA9 crossed above MA50 inside Ichimoku cloud/kumo >> the result are stocks candidate for bullish reversal rally soon.
Now, I ask you again... Are all these possible?
And so you figured, the answer is a big YES! It is very possible!
My minimalistic screener can perform just that. You can do all these and more with the PSE STOCKS WEEKLY-DAILY SCREENER!
Try it now! Download the excel file absolutely free!
Usage Instructions & Guidelines:
1. Download the file from below link. Updated daily as possible.
2. Open in MS Office Excel (recommended), other excel software or app may disable the filtering feature.
3. Filter listed stocks (currently 128 stocks) depending on your chosen criteria or combination/set of criteria from the screener heading.
4. Streamline the results using other bullish signals also provided in the screener like macd, sthocastics, cci, etc.
4. Streamline the results using other bullish signals also provided in the screener like macd, sthocastics, cci, etc.
5. Confirm and validate your stock choice by checking the actual stock chart from your favorite trading chart platform (ex. Investagram, Tradingview, Tsupetot app, etc.)
6. Decide on your entry of your chosen stock.
7. As always, apply due diligence in executing your actual trade.
7. As always, apply due diligence in executing your actual trade.
By using this screener, it is assumed that the user is knowledgeable or at least familiar with the bullish signals of all the mentioned indicators.
P.S. Feel free to comment/report any flaw found, suggest/recommend on possible improvement, and request for your favorite stocks not included in the list.
Disclaimer:
This is a personal weblog. The opinions expressed here represent my own and not those of any of my affiliations. In addition, my thoughts and opinions change from time to time is considered a necessary consequence of having an open mind. This weblog is intended to provide help or assistance to those trading in PSE Stocks Market through the Screener being offered here for free download and use.
This screener is aimed to cut your time scanning through all the stocks just to look for possible bullish play signals. By using this screener, a trader can pin point exactly what play (or criteria) he/she wants to get into. The author does not guarantee positive result(s). Due diligence in actual trading is still required. Although the Screener is developed through hard work, dedication, and to the best knowledge of the author, it is still considered a work in progress and may show some flaws or irregularities on chart of some stocks when compared to other trading chart platform. Nevertheless, the author endeavours to make this screener as much as accurate and effective. The author holds no liability in any form whatsoever to the outcome as a result of user's action in actual trading. Use at your own risk.
This blog disclaimer is subject to change at anytime without prior notification.
Updated file as of trading close 19Sep17
ReplyDeleteFile update: 20Sep2017
ReplyDeleteFile update: 21Sep2017
ReplyDeleteFile update: 22Sep2017
ReplyDeleteSir, may button po ba ito na isang pindot auto update from PSE servers? Thanks
ReplyDeleteUnfortunately wala po... the system machinery is with me. This is how I do it: database >> automatic formula feeder >> excel summary a.k.a Screener. Don't worry I'm updating it daily (2hrs after market close).
DeleteFile update: 25Sep2017
ReplyDeleteScreener Update: 26Sep2017
ReplyDeleteScreener Update: 27Sep2017
ReplyDeleteScreener Update: 28Sep2017
ReplyDeleteScreener Update: 29Sep2017
ReplyDeleteScreener Update: 02Oct2017
ReplyDeleteScreener Update: 03Oct2017
ReplyDeleteScreener Update: 04Oct2017
ReplyDeleteScreener Update: 05Oct2017
ReplyDeleteScreener Update: 06Oct2017
ReplyDeleteScreener Update: 09Oct2017
ReplyDeleteScreener Update: 10Oct2017
ReplyDeleteScreener Update: 11Oct2017
ReplyDeleteScreener Update: 12Oct2017
ReplyDeleteScreener Update: 13Oct2017
ReplyDeletepag sinasabi na last 2 traded values or 3 traded values,
Deletevalues ng 2 or 3 trading days ba?
Yes.. trading days.
Deletefinally meron na akong pg kukunan na screener.. first timer and newbie here...
ReplyDeleteThank you for this sir...
Welcome po... just read usage instruction/guide to better use the screener. Pre-knowledge on indicators is required though. Also apply due diligence on your actual trade.
DeleteScreener Update: 17Oct2017
ReplyDeleteScreener Update: 18Oct2017
ReplyDeleteScreener Update: 19Oct2017
ReplyDeleteScreener Update: 20Oct2017
ReplyDeleteScreener Update: 23Oct2017
ReplyDeleteScreener Update: 25Oct2017
ReplyDeleteScreener Update: 26Oct2017
ReplyDeleteScreener Update: 27Oct2017
ReplyDeleteScreener Update: 30Oct2017
ReplyDeleteScreener Update: 02Nov2017
ReplyDeleteScreener Update: 03Nov2017
ReplyDeleteScreener Update: 06Nov2017
ReplyDeleteScreener Update: 07Nov2017
ReplyDeleteScreener Update: 08Nov2017
ReplyDeleteScreener Update: 09Nov2017
ReplyDeleteBat di napo naupdate since nov 9?
ReplyDeleteSorry but this is due to some unfortunate personal events that happened lately. I will update it as soon as I can. Thanks for understanding.
DeleteScreener Update: 15Mar2018
ReplyDeleteScreener Update: 16Mar2018
ReplyDeleteCheck Google Drive Link for daily file update.
ReplyDeleteThank you sa screener Bossing? are the date based on PSE or Investagram?
ReplyDeleteHi sir. Thank you very much for this screener. However noticed that the latest date was September 7, 2018. Would like to an updated one for 2019. Is there a way for me to update on my own the data automatically?
ReplyDeleteApologies.. check it out again its now updated
DeleteHello sir. Downloaded ko yun feb 19. pero pano po i-update to the latest date parang di naman updated sir. Salamat! Newbie trader lang po
ReplyDeleteSalamat sir sa walang sawang pagbigay ng screener.. very helpful to us newbies.. will incorporate this to my trading routine.. :)
ReplyDeleteMr. Slot - Drmcd
ReplyDeleteThis is your chance to 오산 출장안마 play the 광명 출장마사지 most popular slot machine games 충청북도 출장마사지 online from the comfort of your own home. Our award-winning 태백 출장마사지 jackpot slot is the best. 공주 출장안마