This is a mobile optimized page that loads fast, if you want to load the real page, click this text.

Dump it Here

Jump to new
Skate said:
If you're interested
All you need is a free membership to "Market Index" and Microsoft Excel installed on your computer.
Click to expand...



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.
 
Last edited:

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.
 
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.
 
@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
 
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.
 
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
 
investtrader said:
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.
Click to expand...

@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
 

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.
 
investtrader said:
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.
Click to expand...
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
 
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
(
 
dyna said:
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 ?
Click to expand...
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
 
dyna said:
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 !
Click to expand...
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..
 
You must log in or register to reply here.

Similar threads

R
My strategy/plan going forward
Replies
13
Views
827
RbNEO
R
Very nice Rain here today
3 4 5
Replies
85
Views
4K
farmerge
  • Poll
Financial Independence (Home Ownership, Super, Long Retirement) not possible for wage earners: What do we need and how do we get it?
11 12 13
Replies
258
Views
20K
Smurf1976
November 2024 DDD
2 3
Replies
53
Views
5K
ducati916
Ozempic: Magic Pill or Devils Bargain?
Replies
10
Views
2K
sptrawler
Menu
Log in
Register
Cookies are required to use this site. You must accept them to continue using the site. Learn more...