HiGuys
After spendingquite a good amount of time and subscription money on various websites, I havefound that most of the time they are as good as our own selves. If we have right information on daily basis and if wecan put it in to context of what is happening around the world i.e. macro-economicevents, govt regulations, dollar movement, commodity movements, we can makereasonable decisions quickly and can not miss many opportunities. So, over last 2-3 years since started investing in to stocks and fine tuning what I need to make effective decisions regularly, we have created a simple tool and can fine tune it down the line to add more relevant features to assist people on choosing right stock at right price and right time.
All info you need to narrow down and create your watch list – on ONE excel tab
- All ASX equities list by GICS Industry group and further sub-group(customized by us)
- If equity is part of Vanguard+Blackrock small index fund as per their latest report and how did their position change compare to last report or report in June, July etc..We can add more publicly available leading fund positions.
- Average 7 days, 30 days and 12 weeks compound return.
- How many times stock closed higher than previous days over last 30 trading days
- How many time average closing price for a week was higher than average closing price of previous week over last 20 weeks
- Average Closing price over last 5 days compare to average closing price month ago, 3 months ago, 6 mths ago and 12 mths ago (helps with spotting hockey stick curve when compared with 52 wk low)
- Average closing price over last 2 days vs 52 weeks low ( 0% shows most recent price ~ 52 wk low, 100% shows most recent price is 52 wk high – Basically lower % indicates price is close to 52wk Low)
- Last 2 days average closing price trend – proximity to High price of the day. i.e. if stock closes near to High over last 2 days,
- Average Closing price performance by month for last 24 months(+/- in %)
- Average closing price performance by Week for last 30 weeks (+/- in %)
- Average closing price performance by Day for last 30 days (+/- in %)
- Average price, volume and VPM (Price* Volume) for last 3 days, last 15 days (to filter between micro, macro, small, mid, large caps),
- Average price 30 days ago, 90 days ago, 180 days ago and 365 days ago
- Min and max over last 365 days (52 weeks)
- Other general information like EPS, Market cap, Dividend, Price multiples of earning
- Quarterly and half yearly Sales revenue, EBITDA
Various filters can be used in conjunction with other macroeconomic information and market wide trends i.e. healthcare industry, software industry, Real estate, Gold price, AUD-USD exposure, retail data etc..
If you like this info, can you please provide your feedback in below survey?
https://www.surveymonkey.com/r/7RLCZCW
Example 1 :List of companies running close to their 52 weeks low : Last 2 days vs 52 weeks low (0-30%), last 2 days avg closing price is near to avg High price (indicating upward momentum), average VPM (Volume * Price for day) is >$100K,
Example : NVL -
2. Last 2 days vs 52 weeks Low (0-20%), If scripts are on VG+ Blackrock small fund list ,
There are numerous ways you can drill down the data, It will be refreshed daily and can have mid-day refresh too.
There are also supporting data tabs to drill down individual stock or industry group as per below example
52 weeks performance
Last 90 days perfromance
Where money is flowing?
