Dump it Here

[Skate]

If you're interested
All you need is a free membership to "Market Index" and Microsoft Excel installed on your computer.

If you're interested
Here are the formulas in the workbook - remember, this is just a sample of what you can achieve with the free data provided. All you need is a free membership to "Market Index" and Microsoft Excel installed on your computer. Below are the Sample Excel Formulas for each column (Starting from Row 8).

ASX Code (B8)
Simply enter the ASX code in B8. Then, apply the following formulas to each corresponding column starting from Row 8:

Company (C8) Excel Formula
=IF(B8="", "", INDEX('[asx-workbook.xlsx]ASX Top 500'!$C$10:$C$500, MATCH(SUBSTITUTE(TRIM(B8), ".AX", ""), '[asx-workbook.xlsx]ASX Top 500'!$B$10:$B$500, 0)))

Quantity (D8)
Manually enter the amount of shares.

Purchase Price (E8)
Manually enter the Purchase Price.

Brokerage (F8) Excel Formula
I have applied (0.0012) in the formula which is a fixed rate, representing a percentage (0.12%) for brokerage or transaction fee.
=IF(B8=0,"",D8*E8*0.0012)

Total Buy Cost (G8) Excel Formula
=IF(B8=0,"", D8*E8+F8)

Current Price (H8) Excel Formula
=IF(B8="", "", INDEX('[asx-workbook.xlsx]ASX Top 500'!$D$10:$D$500, MATCH(SUBSTITUTE(TRIM(B8), ".AX", ""), '[asx-workbook.xlsx]ASX Top 500'!$B$10:$B$500, 0)))

Market Value (I8) Excel Formula
=IF(B8=0,"", D8*H8)

Net Profit/Loss (J8) Excel Formula
=IF(B8=0,"", I8-G8)

% Gain/Loss (K8) Excel Formula
=IF(B8=0,"", J8/G8)

Market Cap (L8) Excel Formula
=IF(B8="", "", TEXT(INDEX('[asx-workbook.xlsx]ASX Top 500'!$F$10:$F$500, MATCH(SUBSTITUTE(TRIM(B8), ".AX", ""), '[asx-workbook.xlsx]ASX Top 500'!$B$10:$B$500, 0))/1000000000, "0.00") & "B")

% Div Yield (M8) Excel Formula
=IF(B8="", "", TEXT(INDEX('[asx-workbook.xlsx]ASX Top 500'!$AD$10:$AD$500, MATCH(SUBSTITUTE(TRIM(B8), ".AX", ""), '[asx-workbook.xlsx]ASX Top 500'!$B$10:$B$500, 0)), "0.00%"))

Franking (N8) Excel Formula
=IF(B8="", "", TEXT(INDEX('[asx-workbook.xlsx]ASX Top 500'!$AF$10:$AF$500, MATCH(SUBSTITUTE(TRIM(B8), ".AX", ""), '[asx-workbook.xlsx]ASX Top 500'!$B$10:$B$500, 0))/100, "0.00%"))

Filling Down the Formulas
After setting up these formulas in Row 8, just copy them down each column to reference the cells in column B under [ASX Code] throughout the workbook.

Skate.

 

[Richard Dale]

@Richard Dale, I've now noted the 3 changes made to your website regarding:

#1. "and no further trials are available for that market."
#2. "Unauthorised repeat trials of the same service will be detected and cancelled."
#3. "Misleading/deceptive/temporary identities will be banned."

New Terms
I understand the concern you've raised. I had genuinely exhausted my initial trial and was not aware that seeking additional trials in this manner was against your policy.

I've now reviewed the "updates to your terms" on the website and commit to following them.

Skate.

I'm going to call bull**** on your excuse.

Upon detection, your additional trials were cancelled, yet you kept siging up.

You sought to obtain a service without paying and tried to use various methods to bypass detection, entering in fake details, different email addresses and fake phone numbers.

Any reasonable person knows the basis for a limited-time "free trial" is never "you can use the service for free forever, just change your identity!"

Your actions clearly speak volumes for your character.

 

[Skate]

I'm going to call bull**** on your excuse.

@Richard Dale, I understand your perspective, and I apologise. I acknowledge the updated terms and appreciate the clarity they provide.

Skate.

 

[Skate]

Share Trade Tracker v3.6.2
The new version of Share Trade Tracker, v3.6.2, introduces a new approach to updating End-of-Day (EOD) prices. This update completely removes the Yahoo Data Source and replaces it with an external file system for maintaining EOD prices for your positions.

Key Update
New Pricing Approach - The Yahoo Data Source has been replaced. You can now create and maintain an external file to store EOD prices for all your positions.

Important Instructions for Previous Yahoo Data Source Users
If you've used the Yahoo Data Source in the past, please follow the special instructions provided to transition to the new system. This update allows you to load the external file with your positions or any relevant additional data.

As a side note
I have an additional 9 worksheets in the Share Trade Tracker workbook referencing the "MyPrices" Excel file, the "asx-workbook," plus additional resources. You can adjust the formulas to reflect where the information is stored.

Skate.

 

[Skate]

Further to my previous Post
I trade through CommSec, and the wealth of data they possess should not be underestimated.

Skate.

 

[Garpal Gumnut]

@Richard Dale . You should never post when you are angry. Take it from an expert.

Whatever the rights and wrongs, you have made your point. I don't use data anymore as there is so much free stuff out there that satisfies my needs.

On a positive note it would now appear that your systems are now robust enough to prevent people using your data free. If it had been me I would have said nothing, I guess you've never served in the army, the last thing you share is intel on those opposing you. I briefly thought of really testing your systems but decided against it as time is more precious to me than idle fun.

I do understand your angst as it is your livelihood that is being threatened. @Skate has apologised.

gg

 

[Skate]

Decoding Market Moves with Chart Patterns
Ever wondered what those lines and colours on trading charts signify? For traders, these are not mere lines - they are the narratives of market sentiment, illustrating the dynamic shifts between buyers and sellers. Mastering this understanding can empower you to anticipate market trends instead of merely reacting to them.












Skate.

 

[Garpal Gumnut]

Thanks @Skate . These recent posts are quite valuable. I have an account with Market Index but up to now have just used it for news on the market and stocks. When I have some time I'll go in to your suggestions.

gg

 

[Skate]

I don't use data anymore as there is so much free stuff out there that satisfies my needs.

Indeed, with so much free content available, it's impressive how well our needs can be met without relying on data purchases.

Skate.

 

[investtrader]

I can not understand using cheap, "free" data for investing real money. The cost is a pittance. I really just don't get it unless you are completely new and have no money. Just the time saving alone, let alone the accuracy makes it a no brainer IMHO.

 

[Skate]

I can not understand using cheap, "free" data for investing real money. The cost is a pittance. I really just don't get it unless you are completely new and have no money. Just the time saving alone, let alone the accuracy makes it a no brainer IMHO.

@investtrader, while there's merit to the argument that paid data services can offer more precise and comprehensive information, the value of free resources shouldn't be underestimated, especially for beginners or those looking to test strategies without financial commitment. Free platforms like TradingView and Yahoo Finance provide real-time and historical data that can be quite effective for initial analysis or hobbyist investing.

Skate

 

[DaveTrade]

one thing new entrants into trading ( not so important to investors )

is the reliability and robustness of your equipment and software

despite not buying/selling anything in the last week

i had several incidences that might have wrecked my trading activity

A. the laptop went rogue ( had to do a hard reboot ) that is several minutes down that could have been pivotal

B. internet connectivity was sluggish AND intermittent ( very inconvenient if relying on news feeds and live charts )

C. the wireless mouse went crazy ( and was replaced , luckily i keep spares packed away )

and what might impact you is the accuracy of the data you are getting ( i did get glimpses of stale data last week

please double-check and assess these things BEFORE you start putting cash into the market ( very useful to watch for when learning with demo accounts )

now sure i had a back-up laptop ( but turned off at the time and back up mice and batteries .. and a smug phone if really desperate to transact ) but that connectivity can be a tough one to evade ( twin internet providers , perhaps ? )


good luck

Hi @divs4ever ,

With reference to the part of your post at the end where you state "but that connectivity can be a tough one to evade ( twin internet providers , perhaps ? )", I would like to provide a simple solution. If your home internet fails then you can connect internet to your computer via a personal hotspot from your mobile phone, they are two separate completely independent internet sources.

 

[divs4ever]

I can not understand using cheap, "free" data for investing real money. The cost is a pittance. I really just don't get it unless you are completely new and have no money. Just the time saving alone, let alone the accuracy makes it a no brainer IMHO.

well moons ago i was qualified for IRess ( several times over the years ) free and each time the app./internet/laptop couldn't deal with the downloads , and since i don't need hair-trigger speeds )

all i really need is to see the trend in a share i am interested in , and then lob in an order a few cents away from action , or better still decide a rational price , place an order and wait

i tried it (paper/real trading )my set-up wasn't reliable enough , so adapted my strategy , now my trading platforms might be a little poorer ( less trades ) , but at least i am not screaming on the phone about some costly glitch

i do OK for the creaky old strategy i have and will stick with it until i work out something better

 

[dyna]

one thing new entrants into trading ( not so important to investors )

Glad you've brought this up Mr. Divs.

That scenario would be really scary even for a veteran .

Another good reason , I guess , to have longer time frames in mind , rather than to dive head first into day trading , eh ?

 

[divs4ever]

Hi @divs4ever ,

With reference to the part of your post at the end where you state "but that connectivity can be a tough one to evade ( twin internet providers , perhaps ? )", I would like to provide a simple solution. If your home internet fails then you can connect internet to your computer via a personal hotspot from your mobile phone, they are two separate completely independent internet sources.

try that too ,

but sometimes 3G and sometimes that drops out as well , just the areas i stay in ( on the Brisbane fringe , or the Brisbane-Gold Coast corridor and the current spot slightly west of the Great Divide

some states just do not have reliable comms ( like the 18-24 hour delay to say i have a missed call and phone calls that just drop out , without me moving an inch

fun fact ... i am not that far from Amberley Air Base , so if i saw some low flying Chinese jets .. maybe they will be lucky
(

 

[DaveTrade]

but sometimes 3G and sometimes that drops out as well , just the areas i stay in ( on the Brisbane fringe , or the Brisbane-Gold Coast corridor and the current spot slightly west of the Great Divide

My backup of my backup is the wifi at the local library.

 

[divs4ever]

Glad you've brought this up Mr. Divs.

That scenario would be really scary even for a veteran .

Another good reason , I guess , to have longer time frames in mind , rather than to dive head first into day trading , eh ?

having played cricket at school ( and high school ) my favourite position was silly mid-on( or mid-off )

i was very tempted to dive into trading BUT decided to test my set up first and found it wasn't good enough ( even 4 laptops later )

it doesn't completely stop me from quick moves but i have to keep in mind the exit window might shut on me ( so i had better plan to keep it for a much longer time )

i have sometimes resisted obvious (to me ) trades as the in-out would have to be done within 2 days .. and that exit was not so certain ( be early in the sell line at open )

now if you can do this precision trading good for you

 

[divs4ever]

My backup of my backup is the wifi at the local library.

the local library here is about 30 minute drive ( depending on roadworks )

 

[dyna]

your livelihood that is being threatened.

When this free forum has such a hard time attracting new members ,one has to wonder how many paying clients our friend hopes to rope in with his paltry , unhelpful efforts here .

Getting mad at Mr. Skate , mate ? Not a good look !

 

[qldfrog]

When this free forum has such a hard time attracting new members ,one has to wonder how many paying clients our friend hopes to rope in with his paltry , unhelpful efforts here .

Getting mad at Mr. Skate , mate ? Not a good look !

Agree @dyna,
He was my latest addition this month to my ignore list, and a sad one as i should just stop my platinum data subscription but am too lazy to reconfigure.
The arrogance , smearing and full absence of positive input is/was staggering and relentless especially for someone openly representing the face of a market trading tool actually championed by Mr @Skate ..
What a shame..