Print Page | Close Window

A Spreadsheet that ranks the ASX by trends

Printed From: BullCharts Forum
Category: BullCharts
Forum Name: Tips and Tricks
Forum Discription: Tips on how to use BullCharts more effectively.
URL: http://www.bullcharts.com.au/forum/forum_posts.asp?TID=1029
Printed Date: 17 May 2024 at 2:14am
Software Version: Web Wiz Forums 9.69 - http://www.webwizforums.com


Topic: A Spreadsheet that ranks the ASX by trends
Posted By: John McNamara
Subject: A Spreadsheet that ranks the ASX by trends
Date Posted: 12 Jun 2019 at 5:37pm
Hi All 

I am a new Guy here.

I have a placed an Excel 2003 spreadsheet in the cloud sorted by three day trend. It is also updated to the 4PM close today.
http://www.mediafire.com/folder/5q970f02jg3g0/BullCharts - http://www.mediafire.com/folder/5q970f02jg3g0/BullCharts
There you find 2 files. (I have had an account at Mediafire for nearly 10 years and yes it is safe)
I had trouble uploading the files to this website, they are not large.

I automatically generate the spreadsheet using VBA Basic. 
I have also attached a brief Word doc that describes the other columns.

As you can see it displays a series of columns that contain positive and negative numbers.
Please ignore the actual values, they are simply placeholders indicating the position it that particular stock comparing all the rest of the market for price change over that particular stock over the calculated period.
The columns are calculated using various periods up to the weighted column ranks stocks that have consistently performed well over twelve months.

The coloured boxes help you to see what the graph will look like when you open the chart. Look for rows of green, less dips.

The 10vup column is worth sorting on. It will rank stocks by ten day volume increase. This will be a good sort for the shorter term traders.

You can sort any column on the sheet and even hide data that meets certain criteria say show only one sector By using the selection tool drop down at the top of each column. Read the word doc. (To see evering again use the tool and select "all")

Are there any members in the bull charts group that that do this sort computer based research?
I know of one after viewing Rick Riccio's excellent presentation on using the ASX api. I would love to chat with him one day.

In case you are wondering I do not regard the spreadsheet as some sort of "Black box" trading system, and unlike a black box it does not hide any stock they are all displayed. It is just a tool. What it does do is bring forward stocks that are performing well over a particular time frame. It is then up to the investor/trader to do further research.

For the record this is just my private research being shared. I do not sell it.

Regards
John




Print Page | Close Window

Bulletin Board Software by Web Wiz Forums® version 9.69 - http://www.webwizforums.com
Copyright ©2001-2010 Web Wiz - http://www.webwiz.co.uk