7 New Messages
Digest #2531
Messages
Sun Mar 3, 2013 10:54 am (PST) . Posted by:
"Undisclosed" iamruf
Works great! Thanks.
________________________________
From: Randy Harmelink rharmelink@gmail.com >
To: smf_addin@yahoogroups.com
Sent: Saturday, March 2, 2013 8:56 PM
Subject: Re: [smf_addin] RCHGetWebData
With the given URL in cell C2:
=smfGetTagContent($C$2,"span",-1,"qm_quotetitle")
On Sat, Mar 2, 2013 at 5:38 PM, Undisclosed iamruf@yahoo.com > wrote:
On the same theme & URL below is it possible to extract the fund name?
>In this instance it is: AGF Global Equity Class Series T (AGF2107)
>Thanks for all your help
>
>________________________________
> From: Randy Harmelink rharmelink@gmail.com >
>To: smf_addin@yahoogroups.com
>Sent: Friday, January 18, 2013 10:46 AM
>Subject: Re: [smf_addin] RCHGetWebData
>
>
>Hmmm. Took another look. Raw data appears to be here:
>
>
>http://app.quotemedia.com/quotetools/fundataModule.go?overviewChartLink=off&ents=wmonly&showCommas=true&toolWidth=740&webmasterId=101020&chgrd=D8DCE5&chbdr=D8DCE5&chfill2=6d9641&chfill=cc6d9641&chln=313942&chaaon=true&cp=off&symbol=AGF2107&hiddenTabs=topnav&action=showDetailedQuote&targetURL=http://tmx.quotemedia.com/funds-ca-quote.php&locale=en
>
>...so you could extract it from there. For example, if that URL is in cell C2:
>
>=smfGetTagContent($C$2,"div",1,"Type:")
>=0+smfGetTagContent($C$2,"div",1,"High:")
>
____________
From: Randy Harmelink rharmelink@gmail.
To: smf_addin@yahoogrou
Sent: Saturday, March 2, 2013 8:56 PM
Subject: Re: [smf_addin] RCHGetWebData
With the given URL in cell C2:
=smfGetTagContent(
On Sat, Mar 2, 2013 at 5:38 PM, Undisclosed iamruf@yahoo.
On the same theme & URL below is it possible to extract the fund name?
>In this instance it is: AGF Global Equity Class Series T (AGF2107)
>Thanks for all your help
>
>________
> From: Randy Harmelink rharmelink@gmail.
>To: smf_addin@yahoogrou
>Sent: Friday, January 18, 2013 10:46 AM
>Subject: Re: [smf_addin] RCHGetWebData
>
>
>Hmmm. Took another look. Raw data appears to be here:
>
>
>http://app.quotemed
>
>...so you could extract it from there. For example, if that URL is in cell C2:
>
>=smfGetTagConte
>=0+smfGetTagCon
>
Sun Mar 3, 2013 3:17 pm (PST) . Posted by:
"lewglenn" lewglenn
In their historical prices Yahoo gives the closing price adjusted for dividends and splits as well as the standard closing price. Is there any way to get the former using RCHGetYahooQuotes()? I don't see a code for this item in the datacodelist in the documentation.
Thanks.
Thanks.
Sun Mar 3, 2013 3:23 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
I don't understand the question. The current stock price would not need to
be adjusted. Historical quotes are adjusted so they will be on the same
basis as the current stock price.
On Sun, Mar 3, 2013 at 4:17 PM, lewglenn lewglenn@yahoo.com > wrote:
> In their historical prices Yahoo gives the closing price adjusted for
> dividends and splits as well as the standard closing price. Is there any
> way to get the former using RCHGetYahooQuotes()? I don't see a code for
> this item in the datacodelist in the documentation.
>
be adjusted. Historical quotes are adjusted so they will be on the same
basis as the current stock price.
On Sun, Mar 3, 2013 at 4:17 PM, lewglenn lewglenn@yahoo.
> In their historical prices Yahoo gives the closing price adjusted for
> dividends and splits as well as the standard closing price. Is there any
> way to get the former using RCHGetYahooQuotes(
> this item in the datacodelist in the documentation.
>
Sun Mar 3, 2013 3:31 pm (PST) . Posted by:
"Lew Glenn" lewglenn
Let me try to put this question into another context. Can I use a ticker list, instead of just a single ticker symbol, in the RCHGEetYahooHistory() function?
________________________________
From: Randy Harmelink rharmelink@gmail.com >
To: smf_addin@yahoogroups.com
Sent: Sunday, March 3, 2013 3:23 PM
Subject: Re: [smf_addin] RCHGetYahooQuotes() question
I don't understand the question. The current stock price would not need to be adjusted. Historical quotes are adjusted so they will be on the same basis as the current stock price.
On Sun, Mar 3, 2013 at 4:17 PM, lewglenn lewglenn@yahoo.com > wrote:
In their historical prices Yahoo gives the closing price adjusted for dividends and splits as well as the standard closing price. Is there any way to get the former using RCHGetYahooQuotes()? I don't see a code for this item in the datacodelist in the documentation.
>
____________
From: Randy Harmelink rharmelink@gmail.
To: smf_addin@yahoogrou
Sent: Sunday, March 3, 2013 3:23 PM
Subject: Re: [smf_addin] RCHGetYahooQuotes(
I don't understand the question. The current stock price would not need to be adjusted. Historical quotes are adjusted so they will be on the same basis as the current stock price.
On Sun, Mar 3, 2013 at 4:17 PM, lewglenn lewglenn@yahoo.
In their historical prices Yahoo gives the closing price adjusted for dividends and splits as well as the standard closing price. Is there any way to get the former using RCHGetYahooQuotes(
>
Sun Mar 3, 2013 3:37 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
No. There'd be no reason to. Each ticker symbol requires a separate
Internet access, so there's no advantage to doing multiple tickers in a
single function versus individual functions for each ticker symbol.
On Sun, Mar 3, 2013 at 4:31 PM, Lew Glenn lewglenn@yahoo.com > wrote:
>
> Let me try to put this question into another context. Can I use a ticker
> list, instead of just a single ticker symbol, in the RCHGEetYahooHistory()
> function?
>
Internet access, so there's no advantage to doing multiple tickers in a
single function versus individual functions for each ticker symbol.
On Sun, Mar 3, 2013 at 4:31 PM, Lew Glenn lewglenn@yahoo.
>
> Let me try to put this question into another context. Can I use a ticker
> list, instead of just a single ticker symbol, in the RCHGEetYahooHistory
> function?
>
Sun Mar 3, 2013 6:31 pm (PST) . Posted by:
"Pete" petekoch
I compared some numbers returned from AdvFN and Morningstar.
Using Xerox (XRX) as an example, I went directly to the company's annual reports. Morningstar's numbers exactly matched those in the report. AdvFN's numbers, while in the ballpark, differed from the report. And I'm talking about the raw data, e.g., total revenues, nothing derived or calculated. Plus I find that AdvFN is often late with both the most recent fiscal year's data as well as that for TTM.
Using Xerox (XRX) as an example, I went directly to the company'
Sun Mar 3, 2013 7:08 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
When I looked at XRX, the annual "As Reported" numbers for Total Revenues
matched between Morningstar and AdvFN, but the "Restated"; numbers on
MorningStar were different.
On Sun, Mar 3, 2013 at 7:31 PM, Pete petekoch@yahoo.com > wrote:
> I compared some numbers returned from AdvFN and Morningstar.
>
> Using Xerox (XRX) as an example, I went directly to the company's annual
> reports. Morningstar's numbers exactly matched those in the report. AdvFN's
> numbers, while in the ballpark, differed from the report. And I'm talking
> about the raw data, e.g., total revenues, nothing derived or calculated.
> Plus I find that AdvFN is often late with both the most recent fiscal
> year's data as well as that for TTM.
>
matched between Morningstar and AdvFN, but the "Restated"
MorningStar were different.
On Sun, Mar 3, 2013 at 7:31 PM, Pete petekoch@yahoo.
> I compared some numbers returned from AdvFN and Morningstar.
>
> Using Xerox (XRX) as an example, I went directly to the company'
> reports. Morningstar&#
> numbers, while in the ballpark, differed from the report. And I'm talking
> about the raw data, e.g., total revenues, nothing derived or calculated.
> Plus I find that AdvFN is often late with both the most recent fiscal
> year's data as well as that for TTM.
>
Tidak ada komentar:
Posting Komentar