Australian (ASX) Stock Market Forum

Need replacement for Fairfax Media's Trading Room free program (1 Viewer)

Joined
Apr 14, 2016
Posts
2
Reactions
0
Have been searching for weeks to find anything similar as the excellent 'tradingroom' website which includes the necessary fields of 'dividend amount' and 'dividend date payable'. Have constructed my own spreadsheet using google sheets but there are no google finance fields for dividend date etc so thats turned out to be dead end. also google sheets have problems reloading the google finance data.
Thank you:eek::)
 
Joined
Jun 30, 2007
Posts
6,175
Reactions
618
Have been searching for weeks to find anything similar as the excellent 'tradingroom' website which includes the necessary fields of 'dividend amount' and 'dividend date payable'. Have constructed my own spreadsheet using google sheets but there are no google finance fields for dividend date etc so thats turned out to be dead end. also google sheets have problems reloading the google finance data.
Thank you:eek::)

SMH business is pretty much identical, except quotes 20 min delayed.
 

pixel

DIY Trader
Joined
Feb 3, 2010
Posts
5,359
Reactions
330
Have been searching for weeks to find anything similar as the excellent 'tradingroom' website which includes the necessary fields of 'dividend amount' and 'dividend date payable'. Have constructed my own spreadsheet using google sheets but there are no google finance fields for dividend date etc so thats turned out to be dead end. also google sheets have problems reloading the google finance data.
Thank you:eek::)

For dividend-related info, I've always gone to the very source:
http://www.asx.com.au/asx/markets/dividends.do?by=asxCodes&asxCodes=anz+bhp+cab+rio&view=all

I agree though, Tradingroom offered far more information: for starters, they had the complete history, whereas ASX only shows the last year or two. TR is also enormously faster to access from Excel. So, I'm really sad to see it disappear. I guess poor old Fairfax could no longer afford the upkeep...
 
Joined
Apr 14, 2016
Posts
2
Reactions
0
after many weeks still not able to find a suitable replacement for 'Trading Room'
have now tried to develop a excel sheet that takes data from various sources including ASX dividend data and this works except for one crucial missing point
the ASX dividend data is not expressed as a proper mathematical currency when it comes across as when u look at the ASX dvidend data they stupidly add the 'c' to indicate cents for dividend so it like 54c or 23c which cant then be multiplied by the number of shares held to get a proper dividend amount
also they even worse show very small half cents as 1.5c which is even worse for data manipultion.
So im stuck
 
Joined
Jun 30, 2007
Posts
6,175
Reactions
618
after many weeks still not able to find a suitable replacement for 'Trading Room'
have now tried to develop a excel sheet that takes data from various sources including ASX dividend data and this works except for one crucial missing point
the ASX dividend data is not expressed as a proper mathematical currency when it comes across as when u look at the ASX dvidend data they stupidly add the 'c' to indicate cents for dividend so it like 54c or 23c which cant then be multiplied by the number of shares held to get a proper dividend amount
also they even worse show very small half cents as 1.5c which is even worse for data manipultion.
So im stuck

Did you even read my reply above??

http://www.smh.com.au/business/markets/quotes/dividends/BHP/bhp-billiton-limited
 
Joined
Apr 21, 2014
Posts
7,956
Reactions
1,062
after many weeks still not able to find a suitable replacement for 'Trading Room'
have now tried to develop a excel sheet that takes data from various sources including ASX dividend data and this works except for one crucial missing point
the ASX dividend data is not expressed as a proper mathematical currency when it comes across as when u look at the ASX dvidend data they stupidly add the 'c' to indicate cents for dividend so it like 54c or 23c which cant then be multiplied by the number of shares held to get a proper dividend amount
also they even worse show very small half cents as 1.5c which is even worse for data manipultion.
So im stuck

Excel have those replace function you can use to remove 1 or x number of character from left or right.
 

pixel

DIY Trader
Joined
Feb 3, 2010
Posts
5,359
Reactions
330
also they even worse show very small half cents as 1.5c which is even worse for data manipultion.
So im stuck
Looks like you need help with Excel. Which is what I've been providing for over 2 decades :) String manipulation is best done with macros. As is data import from reference websites. Dates displayed in green are in the past; red dates are to look forward to. For those upcoming dates, I also calculate the yield of the expected grossed-up dividend on the basis of "if bought at today's price"

DiviSheet.png

and

DiviHist.png
Anybody interested: Drop me a PM.
 

Users who are viewing this thread

Top