Messages In This Digest (5 Messages)
- 1a.
- http://www.morningstar.com.au From: jeromieweatherburn
- 1b.
- Re: http://www.morningstar.com.au From: Steven Sun
- 1c.
- Re: http://www.morningstar.com.au From: Jeromie Weatherburn
- 1d.
- Re: http://www.morningstar.com.au From: Randy Harmelink
- 2a.
- Re: Hi Randy, excellent work! Genious! I however would like to ask From: bobsledproductions
Messages
- 1a.
-
http://www.morningstar.com.au
Posted by: "jeromieweatherburn" jeromieweatherburn@yahoo.com.au jeromieweatherburn
Sun Dec 11, 2011 5:18 pm (PST)
Hi Randy & Members,
Firstly a huge thanks to Randy for creating and providing the Addin. Whilst I am not all that familiar with it, I am finding it to be a massively useful tool for data collection.
I doubly appreciate the time Randy & others spend on answering similar versions of the same questions as this is probably one.
Wondering if anyone has experience using the Addin for morningstar.com.au
It is a free service applicable for Australian companies (after joining.
The Good.
I have managed to scrape some of the historical financial information.
The Bad.
This information I collected from historical data seems to be limited to 3 years though I can see more on the page (up to 10yrs in the underlying (Page Source) script). I'm not sure why this would be the case.
I haven't been able to get any information from the "Balance Sheet" or other sections. Again I can see the figures in the underlying script.
Example
Stock Code CSR
Column Reference 0 1 2 3
03/09 03/10 03/11
Revenues (m) 3492.8 3784.5 1913.6
Example of call to get this date C1 is Stock Symbol, G3 is the Column Reference (3 in this case). negative numbers & 4 or above did not work.
Example of code used to call page.
RCHGetTableCell("http://www.mornings tar.com.au/ "&$C$1&"",G$Stocks/CompanyHi storicals/ 3,"Revenues (m)")
This is what I tried for the Balance Sheet Page without luck.
RCHGetTableCell("http://www.mornings tar.com.au/ "&$C$1&"",1,Stocks/BalanceSh eet/ "Cash")
It could be as easy as me not understanding when to use different versions of the addin, or another simple answer.
Anyways if someone can assist that would be great.
Thanks
Jeromie
- 1b.
-
Re: http://www.morningstar.com.au
Posted by: "Steven Sun" ssun24cd@gmail.com ssun_tdam
Sun Dec 11, 2011 5:27 pm (PST)
Use www.money.com to get financial data of australian companies.
Put au:rio in "get quote" box and you should be able to obtain financial
data.
"AU" represents country code and "rio" is stock symbol for Rio Tinto.
stevo
On Sun, Dec 11, 2011 at 8:18 PM, jeromieweatherburn <
jeromieweatherburn@yahoo.com. > wrote:au
> **
>
>
> Hi Randy & Members,
>
> Firstly a huge thanks to Randy for creating and providing the Addin.
> Whilst I am not all that familiar with it, I am finding it to be a
> massively useful tool for data collection.
>
> I doubly appreciate the time Randy & others spend on answering similar
> versions of the same questions as this is probably one.
>
> Wondering if anyone has experience using the Addin for morningstar.com.au
>
> It is a free service applicable for Australian companies (after joining.
>
> The Good.
> I have managed to scrape some of the historical financial information.
>
> The Bad.
> This information I collected from historical data seems to be limited to 3
> years though I can see more on the page (up to 10yrs in the underlying
> (Page Source) script). I'm not sure why this would be the case.
>
> I haven't been able to get any information from the "Balance Sheet" or
> other sections. Again I can see the figures in the underlying script.
>
> Example
>
> Stock Code CSR
>
> Column Reference 0 1 2 3
> 03/09 03/10 03/11
> Revenues (m) 3492.8 3784.5 1913.6
>
> Example of call to get this date C1 is Stock Symbol, G3 is the Column
> Reference (3 in this case). negative numbers & 4 or above did not work.
> Example of code used to call page.
> RCHGetTableCell("http://www.mornings tar.com.au/ "&$C$1&"",G$Stocks/CompanyHi storicals/ 3,"Revenues
> (m)")
>
> This is what I tried for the Balance Sheet Page without luck.
>
> RCHGetTableCell("http://www.mornings tar.com.au/ Stocks/BalanceSh eet/
> "&$C$1&"",1,"Cash")
>
> It could be as easy as me not understanding when to use different versions
> of the addin, or another simple answer.
>
> Anyways if someone can assist that would be great.
>
> Thanks
> Jeromie
>
>
>
- 1c.
-
Re: http://www.morningstar.com.au
Posted by: "Jeromie Weatherburn" jeromieweatherburn@yahoo.com.au jeromieweatherburn
Sun Dec 11, 2011 7:16 pm (PST)
Hi Steven,
I must be missing something.
www.money.com takes me to http://money.cnn.com/
I tried to enter the au:rio in "Enter a Symbol" and "Search" boxes on the right hand side without luck.
I tried a few other Australian Stocks as well without luck.
Are you able to clarify what I am doing wrong.
Thanks
--- On Mon, 12/12/11, Steven Sun <ssun24cd@gmail.com > wrote:
From: Steven Sun <ssun24cd@gmail.com >
Subject: Re: [smf_addin] http://www.morningstar.com.au
To: smf_addin@yahoogroups.com
Received: Monday, 12 December, 2011, 12:27 PM
Use www.money.com to get financial data of australian companies.
Put au:rio in "get quote" box and you should be able to obtain financial data.
"AU" represents country code and "rio" is stock symbol for Rio Tinto.
stevo
On Sun, Dec 11, 2011 at 8:18 PM, jeromieweatherburn <jeromieweatherburn@yahoo.com. > wrote:au
Hi Randy & Members,
Firstly a huge thanks to Randy for creating and providing the Addin. Whilst I am not all that familiar with it, I am finding it to be a massively useful tool for data collection.
I doubly appreciate the time Randy & others spend on answering similar versions of the same questions as this is probably one.
Wondering if anyone has experience using the Addin for morningstar.com.au
It is a free service applicable for Australian companies (after joining.
The Good.
I have managed to scrape some of the historical financial information.
The Bad.
This information I collected from historical data seems to be limited to 3 years though I can see more on the page (up to 10yrs in the underlying (Page Source) script). I'm not sure why this would be the case.
I haven't been able to get any information from the "Balance Sheet" or other sections. Again I can see the figures in the underlying script.
Example
Stock Code CSR
Column Reference 0 1 2 3
03/09 03/10 03/11
Revenues (m) 3492.8 3784.5 1913.6
Example of call to get this date C1 is Stock Symbol, G3 is the Column Reference (3 in this case). negative numbers & 4 or above did not work.
Example of code used to call page.
RCHGetTableCell("http://www.mornings tar.com.au/ "&$C$1&"",G$Stocks/CompanyHi storicals/ 3,"Revenues (m)")
This is what I tried for the Balance Sheet Page without luck.
RCHGetTableCell("http://www.mornings tar.com.au/ "&$C$1&"",1,Stocks/BalanceSh eet/ "Cash")
It could be as easy as me not understanding when to use different versions of the addin, or another simple answer.
Anyways if someone can assist that would be great.
Thanks
Jeromie
- 1d.
-
Re: http://www.morningstar.com.au
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sun Dec 11, 2011 9:15 pm (PST)
When I go to the page, I only see 3 years of data. But I also see a message
that says, "To view all information become a Premium Member".
So I think you just need to log in. However, you MUST login either thru the
EXCEL Web Query dialog or using IE -- because EXCEL, as a Microsoft
product, uses IE security cookies. It won't do you any good to be logged in
using another browser, like FireFox.
On Sun, Dec 11, 2011 at 6:18 PM, jeromieweatherburn <
jeromieweatherburn@yahoo.com. > wrote:au
> Hi Randy & Members,
>
> Firstly a huge thanks to Randy for creating and providing the Addin.
> Whilst I am not all that familiar with it, I am finding it to be a
> massively useful tool for data collection.
>
> I doubly appreciate the time Randy & others spend on answering similar
> versions of the same questions as this is probably one.
>
> Wondering if anyone has experience using the Addin for morningstar.com.au
>
> It is a free service applicable for Australian companies (after joining.
>
> The Good.
> I have managed to scrape some of the historical financial information.
>
> The Bad.
> This information I collected from historical data seems to be limited to 3
> years though I can see more on the page (up to 10yrs in the underlying
> (Page Source) script). I'm not sure why this would be the case.
>
> I haven't been able to get any information from the "Balance Sheet" or
> other sections. Again I can see the figures in the underlying script.
>
> Example
>
> Stock Code CSR
>
> Column Reference 0 1 2 3
> 03/09 03/10 03/11
> Revenues (m) 3492.8 3784.5 1913.6
>
> Example of call to get this date C1 is Stock Symbol, G3 is the Column
> Reference (3 in this case). negative numbers & 4 or above did not work.
> Example of code used to call page.
> RCHGetTableCell("http://www.mornings tar.com.au/ "&$C$1&"",G$Stocks/CompanyHi storicals/ 3,"Revenues
> (m)")
>
> This is what I tried for the Balance Sheet Page without luck.
>
> RCHGetTableCell("http://www.mornings tar.com.au/ Stocks/BalanceSh eet/
> "&$C$1&"",1,"Cash")
>
> It could be as easy as me not understanding when to use different versions
> of the addin, or another simple answer.
>
> Anyways if someone can assist that would be great.
>
- 2a.
-
Re: Hi Randy, excellent work! Genious! I however would like to ask
Posted by: "bobsledproductions" JPeters3515@snet.net bobsledproductions
Sun Dec 11, 2011 6:47 pm (PST)
Take a look at thes second link on the right hand panel. I put together an RSS reader a while ago. Embedded is a browser for reading the stories, and a list of RSS sources as well. Workbook should be open, so do with it what you please.
http://www.toteboard.net/
--- In smf_addin@yahoogroups.com , famwencong@... wrote:
>
> Hi Randy, excellent work! Genius! I however would like to ask something a little more out of the box.
>
> I understand its not my place to give you suggestions but in your possible future releases of the updated versions, will there be a function for an RSS extraction? Such as company news?
>
> I do not have prior VBA knowledge but am willing to learn if you point me in the direction.
>
Need to Reply?
Click one of the "Reply" links to respond to a specific message in the Daily Digest.
MARKETPLACE
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Individual | Switch format to Traditional
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe
Tidak ada komentar:
Posting Komentar