14 New Messages
Digest #2530
Messages
Sat Mar 2, 2013 9:27 am (PST) . Posted by:
"ufdn16" ufdn16
Which file has the full list of element numbers
Sat Mar 2, 2013 9:38 am (PST) . Posted by:
"Kermit W. Prather" kermitpra
RCHGetElementNumber-Element-Definitions.xls
Should be in the installed folder.
-----Original Message-----
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf
Of ufdn16
Sent: Saturday, March 02, 2013 12:28 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] List of element numbers
Which file has the full list of element numbers
------------------------------------
Yahoo! Groups Links
Should be in the installed folder.
-----Original Message-----
From: smf_addin@yahoogrou
Of ufdn16
Sent: Saturday, March 02, 2013 12:28 PM
To: smf_addin@yahoogrou
Subject: [smf_addin] List of element numbers
Which file has the full list of element numbers
------------
Yahoo! Groups Links
Sat Mar 2, 2013 10:24 am (PST) . Posted by:
"lswpubrw" lswpubrlw
I've running RCHGetYahooQuotes for a few spread sheets. Nothing sophisticated. I wanted to check the definitions spread sheet and find that my SM-Add-in directory reports being empty. So I downloaded the zip file again expanded it into the SM directory and it still shows nothing. What am I doing wrong? Another clue is the spread sheet using RCHGetYahooQuotes doesn't show the Add-in listed but it must be some where if it gets the results?
Bob W.
From: Kermit W. Prather
Sent: Saturday, March 02, 2013 12:38 PM
To: smf_addin@yahoogroups.com
Subject: RE: [smf_addin] List of element numbers
RCHGetElementNumber-Element-Definitions.xls
Should be in the installed folder.
-----Original Message-----
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf
Of ufdn16
Sent: Saturday, March 02, 2013 12:28 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] List of element numbers
Which file has the full list of element numbers
------------------------------------
Yahoo! Groups Links
No virus found in this message.
Checked by AVG - www.avg.com
Version: 2013.0.2899 / Virus Database: 2641/6140 - Release Date: 03/01/13
Bob W.
From: Kermit W. Prather
Sent: Saturday, March 02, 2013 12:38 PM
To: smf_addin@yahoogrou
Subject: RE: [smf_addin] List of element numbers
RCHGetElementNumber
Should be in the installed folder.
-----Original Message-----
From: smf_addin@yahoogrou
Of ufdn16
Sent: Saturday, March 02, 2013 12:28 PM
To: smf_addin@yahoogrou
Subject: [smf_addin] List of element numbers
Which file has the full list of element numbers
------------
Yahoo! Groups Links
No virus found in this message.
Checked by AVG - www.avg.com
Version: 2013.0.2899 / Virus Database: 2641/6140 - Release Date: 03/01/13
Sat Mar 2, 2013 10:43 am (PST) . Posted by:
"Randy Harmelink" rharmelink
The definitions workbook is element definitions for the
RCHGetElementNumber() function.
Documentation on RCHGetYahooQuotes() would be in the "Documentation" folder
of the FILES area of the Yahoo Group.
But I have no idea what is going on with your folder being empty, even
after unzipping the ZIP file.
If you use this function:
=RCHGetElementNumber("Version")
...it will tell you where you have the add-in located. Maybe you're not
looking in the right folder?
On Sat, Mar 2, 2013 at 11:24 AM, lswpubrw lswpubrw@optonline.net > wrote:
> **
> I've running RCHGetYahooQuotes for a few spread sheets. Nothing
> sophisticated. I wanted to check the definitions spread sheet and find
> that my SM-Add-in directory reports being empty. So I downloaded the zip
> file again expanded it into the SM directory and it still shows nothing.
> What am I doing wrong? Another clue is the spread sheet using
> RCHGetYahooQuotes doesn't show the Add-in listed but it must be some where
> if it gets the results?
>
>
RCHGetElementNumber
Documentation on RCHGetYahooQuotes(
of the FILES area of the Yahoo Group.
But I have no idea what is going on with your folder being empty, even
after unzipping the ZIP file.
If you use this function:
=RCHGetElementNumbe
...it will tell you where you have the add-in located. Maybe you're not
looking in the right folder?
On Sat, Mar 2, 2013 at 11:24 AM, lswpubrw lswpubrw@optonline.
> **
> I've running RCHGetYahooQuotes for a few spread sheets. Nothing
> sophisticated. I wanted to check the definitions spread sheet and find
> that my SM-Add-in directory reports being empty. So I downloaded the zip
> file again expanded it into the SM directory and it still shows nothing.
> What am I doing wrong? Another clue is the spread sheet using
> RCHGetYahooQuotes doesn't show the Add-in listed but it must be some where
> if it gets the results?
>
>
Sat Mar 2, 2013 10:49 am (PST) . Posted by:
"lswpubrw" lswpubrlw
Never mind. I had 2 SMF-Addin directories was looking at the wrong one.
From: lswpubrw
Sent: Saturday, March 02, 2013 1:24 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] List of element numbers
I've running RCHGetYahooQuotes for a few spread sheets. Nothing sophisticated. I wanted to check the definitions spread sheet and find that my SM-Add-in directory reports being empty. So I downloaded the zip file again expanded it into the SM directory and it still shows nothing. What am I doing wrong? Another clue is the spread sheet using RCHGetYahooQuotes doesn't show the Add-in listed but it must be some where if it gets the results?
Bob W.
From: Kermit W. Prather
Sent: Saturday, March 02, 2013 12:38 PM
To: smf_addin@yahoogroups.com
Subject: RE: [smf_addin] List of element numbers
RCHGetElementNumber-Element-Definitions.xls
Should be in the installed folder.
-----Original Message-----
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf
Of ufdn16
Sent: Saturday, March 02, 2013 12:28 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] List of element numbers
Which file has the full list of element numbers
------------------------------------
Yahoo! Groups Links
No virus found in this message.
Checked by AVG - www.avg.com
Version: 2013.0.2899 / Virus Database: 2641/6140 - Release Date: 03/01/13
No virus found in this message.
Checked by AVG - www.avg.com
Version: 2013.0.2899 / Virus Database: 2641/6140 - Release Date: 03/01/13
From: lswpubrw
Sent: Saturday, March 02, 2013 1:24 PM
To: smf_addin@yahoogrou
Subject: Re: [smf_addin] List of element numbers
I've running RCHGetYahooQuotes for a few spread sheets. Nothing sophisticated. I wanted to check the definitions spread sheet and find that my SM-Add-in directory reports being empty. So I downloaded the zip file again expanded it into the SM directory and it still shows nothing. What am I doing wrong? Another clue is the spread sheet using RCHGetYahooQuotes doesn't show the Add-in listed but it must be some where if it gets the results?
Bob W.
From: Kermit W. Prather
Sent: Saturday, March 02, 2013 12:38 PM
To: smf_addin@yahoogrou
Subject: RE: [smf_addin] List of element numbers
RCHGetElementNumber
Should be in the installed folder.
-----Original Message-----
From: smf_addin@yahoogrou
Of ufdn16
Sent: Saturday, March 02, 2013 12:28 PM
To: smf_addin@yahoogrou
Subject: [smf_addin] List of element numbers
Which file has the full list of element numbers
------------
Yahoo! Groups Links
No virus found in this message.
Checked by AVG - www.avg.com
Version: 2013.0.2899 / Virus Database: 2641/6140 - Release Date: 03/01/13
No virus found in this message.
Checked by AVG - www.avg.com
Version: 2013.0.2899 / Virus Database: 2641/6140 - Release Date: 03/01/13
Sat Mar 2, 2013 9:30 am (PST) . Posted by:
"ufdn16" ufdn16
I want to get 3,5,10 year numbers for:
Sales
Earnings
Earnings growth
Cash on hand
Return on Investment
What is the formula for this.
Thanks, David
Sales
Earnings
Earnings growth
Cash on hand
Return on Investment
What is the formula for this.
Thanks, David
Sat Mar 2, 2013 9:44 am (PST) . Posted by:
"Kermit W. Prather" kermitpra
Open the definition excel file RCHGetElementNumber-Element-Definitions.xls
And search for the data you need.
Then enter into a excel cell =RCHGetElementNumber(symbol,element#)
Repeat that for each element you want to retrieve
Such as
Element source information
693 YahooAE Revenue Estimates -- Year Ago Sales -- FQ1
694 YahooAE Revenue Estimates -- Year Ago Sales -- FQ2
695 YahooAE Revenue Estimates -- Year Ago Sales -- FY1
696 YahooAE Revenue Estimates -- Year Ago Sales -- FY2
697 YahooAE Revenue Estimates -- Sales Growth -- FQ1
698 YahooAE Revenue Estimates -- Sales Growth -- FQ2
699 YahooAE Revenue Estimates -- Sales Growth -- FY1
700 YahooAE Revenue Estimates -- Sales Growth -- FY2
-----Original Message-----
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf
Of ufdn16
Sent: Saturday, March 02, 2013 12:30 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] 3,5,10 year numbers
I want to get 3,5,10 year numbers for:
Sales
Earnings
Earnings growth
Cash on hand
Return on Investment
What is the formula for this.
Thanks, David
------------------------------------
Yahoo! Groups Links
And search for the data you need.
Then enter into a excel cell =RCHGetElementNumbe
Repeat that for each element you want to retrieve
Such as
Element source information
693 YahooAE Revenue Estimates -- Year Ago Sales -- FQ1
694 YahooAE Revenue Estimates -- Year Ago Sales -- FQ2
695 YahooAE Revenue Estimates -- Year Ago Sales -- FY1
696 YahooAE Revenue Estimates -- Year Ago Sales -- FY2
697 YahooAE Revenue Estimates -- Sales Growth -- FQ1
698 YahooAE Revenue Estimates -- Sales Growth -- FQ2
699 YahooAE Revenue Estimates -- Sales Growth -- FY1
700 YahooAE Revenue Estimates -- Sales Growth -- FY2
-----Original Message-----
From: smf_addin@yahoogrou
Of ufdn16
Sent: Saturday, March 02, 2013 12:30 PM
To: smf_addin@yahoogrou
Subject: [smf_addin] 3,5,10 year numbers
I want to get 3,5,10 year numbers for:
Sales
Earnings
Earnings growth
Cash on hand
Return on Investment
What is the formula for this.
Thanks, David
------------
Yahoo! Groups Links
Sat Mar 2, 2013 10:12 am (PST) . Posted by:
"ufdn16" ufdn16
My computer crashed on me recently. Once it was reinstalled I had to reinstall Windows Office 10.
My worksheets before the crash were still there but the formulas look something like this:
='C:\Program Files\SMF Add-In\RCH_Stock_Market_Functions.xla'!RCHGetElementNumber(+C3,990)
Now, starting a new file I tried =rchgetelementnumber(+C3,990) and I get #NAME in the new cell.
What do I need to do to correct this. Thanks, David
My worksheets before the crash were still there but the formulas look something like this:
='C:\
Now, starting a new file I tried =rchgetelementnumbe
What do I need to do to correct this. Thanks, David
Sat Mar 2, 2013 10:20 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Check out the item on location errors in the LINKS area of the Yahoo group.
But if you're getting #NAME? errors on new formulas, you probably need to
install the add-in.
On Sat, Mar 2, 2013 at 11:12 AM, ufdn16 ufdn16@yahoo.com > wrote:
> My computer crashed on me recently. Once it was reinstalled I had to
> reinstall Windows Office 10.
>
> My worksheets before the crash were still there but the formulas look
> something like this:
>
> ='C:\Program Files\SMF
> Add-In\RCH_Stock_Market_Functions.xla'!RCHGetElementNumber(+C3,990)
>
> Now, starting a new file I tried =rchgetelementnumber(+C3,990) and I get
> #NAME in the new cell.
>
> What do I need to do to correct this. Thanks, David
>
But if you're getting #NAME? errors on new formulas, you probably need to
install the add-in.
On Sat, Mar 2, 2013 at 11:12 AM, ufdn16 ufdn16@yahoo.
> My computer crashed on me recently. Once it was reinstalled I had to
> reinstall Windows Office 10.
>
> My worksheets before the crash were still there but the formulas look
> something like this:
>
> ='C:\
> Add-In\RCH_
>
> Now, starting a new file I tried =rchgetelementnumbe
> #NAME in the new cell.
>
> What do I need to do to correct this. Thanks, David
>
Sat Mar 2, 2013 2:12 pm (PST) . Posted by:
"eric.dagnelies" eric.dagnelies
I try to use SMF-Template-10-Year-Charts.xls but I get about only error values.
It comes from the RCHGetURLData1() function :
it returns "Error" when it try to get the Advfn reports,
but get a result for the Yahoo csv.
The error occurs when oHTTP.Send is executed. It returns :
Err.Number -2147024891
Err.Description Access is denied
http://www.advfn.com/p.php?pid=financials&symbol=ACC&mode=quarterly_reports ---> Error
http://www.advfn.com/p.php?pid=financials&symbol=ACC&mode=annual_reports ---> Error
http://download.finance.yahoo.com/d/quotes.csv?s=ACC&f=l1&e=.ignore ---> OK
Excel 2007 - Windows 7
Thanks for your very fine job.
It comes from the RCHGetURLData1(
it returns "Error" when it try to get the Advfn reports,
but get a result for the Yahoo csv.
The error occurs when oHTTP.Send is executed. It returns :
Err.Number -2147024891
Err.Description Access is denied
http://www.advfn.
http://www.advfn.
http://download.
Excel 2007 - Windows 7
Thanks for your very fine job.
Sat Mar 2, 2013 2:21 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Check out the AdvFN item in the LINKS area of the group and see if it fixes
your problem.
On Sat, Mar 2, 2013 at 3:12 PM, eric.dagnelies eric.dagnelies@yahoo.fr >wrote:
> I try to use SMF-Template-10-Year-Charts.xls but I get about only error
> values.
> It comes from the RCHGetURLData1() function :
> it returns "Error" when it try to get the Advfn reports,
> but get a result for the Yahoo csv.
>
> The error occurs when oHTTP.Send is executed. It returns :
> Err.Number -2147024891
> Err.Description Access is denied
>
> http://www.advfn.com/p.php?pid=financials&symbol=ACC&mode=quarterly_reports ---> Error
> http://www.advfn.com/p.php?pid=financials&symbol=ACC&mode=annual_reports ---> Error
> http://download.finance.yahoo.com/d/quotes.csv?s=ACC&f=l1&e=.ignore
> ---> OK
>
> Excel 2007 - Windows 7
>
your problem.
On Sat, Mar 2, 2013 at 3:12 PM, eric.dagnelies eric.dagnelies@
> I try to use SMF-Template-
> values.
> It comes from the RCHGetURLData1(
> it returns "Error" when it try to get the Advfn reports,
> but get a result for the Yahoo csv.
>
> The error occurs when oHTTP.Send is executed. It returns :
> Err.Number -2147024891
> Err.Description Access is denied
>
> http://www.advfn.
> http://www.advfn.
> http://download.
> ---> OK
>
> Excel 2007 - Windows 7
>
Sun Mar 3, 2013 12:46 am (PST) . Posted by:
"eric.dagnelies" eric.dagnelies
Yes, it fixes the problem !
Many thanks !
Many thanks !
Sat Mar 2, 2013 4:39 pm (PST) . Posted by:
"Undisclosed" iamruf
Hi Randy,
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
The RCHGetWebData() is just returning this JavaScript data:
( { "copyright":"Copyright (c) 2013 QuoteMedia, Inc.", "symbolcount":1, "quotedata":[ { "symbol":"AGF2107", "datatype";:"mutual fund", "entitlement":"EOD", "delaymin";:null, "datetime";:"2013-01-17T20:00:00-05:00", "pricedata":{ "last":"15.81", "change":"0.11", "changepercent":"0.700637", "sharevolume":"0" } } ] } );
So items out of that can be extracted.
But I don't see any of the additional items you mention shown there, and if I remember correctly, the main page was dynamically displayed, so the data couldn't be extracted there either.
If the data you want is available elsewhere, I'm not aware of it.
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:")
On Fri, Jan 18, 2013 at 8:23 AM, iamruf iamruf@yahoo.com > wrote:
Hi Randy,
>The formula at the bottom is getting prices although I don`t understand how it works.
>Is it possible to adapt the formula to get other data on this page.
>Fund Type: Global Equity
>52 Week High: 16.05
>52 Week Low: 14.34
>YTD Return (as of December 31, 2012): 11.69%
>Load Type: Choice of Front or Back
>MER: 2.94%
>Eligiblity: RRSP
>Who Should Invest
>Consider this Fund if: the tax consequences of a mutual fund corporation are more suitable to your investment program or that of your registered plan; you want the growth potential of equity securities of foreign companies; you're investing for the longer term; you tolerate medium risk; with respect to Series T and Series V securities, you prefer monthly distribution of capital.(This is a box varies in length)
>
>=RCHGetWebData("http://tmx.quotemedia.com/json/getQuotesMini.json.php?jsoncallba \ck=jsonp1358089488792&symbols=AGF2107&webmasterId=101020&_=1358089550952",1,1000)
>
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
The RCHGetWebData(
( { "copyright&quo
So items out of that can be extracted.
But I don't see any of the additional items you mention shown there, and if I remember correctly, the main page was dynamically displayed, so the data couldn't be extracted there either.
If the data you want is available elsewhere, I'm not aware of it.
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:
=smfGetTagContent(
=0+smfGetTagContent
On Fri, Jan 18, 2013 at 8:23 AM, iamruf iamruf@yahoo.
Hi Randy,
>The formula at the bottom is getting prices although I don`t understand how it works.
>Is it possible to adapt the formula to get other data on this page.
>Fund Type: Global Equity
>52 Week High: 16.05
>52 Week Low: 14.34
>YTD Return (as of December 31, 2012): 11.69%
>Load Type: Choice of Front or Back
>MER: 2.94%
>Eligiblity: RRSP
>Who Should Invest
>Consider this Fund if: the tax consequences of a mutual fund corporation are more suitable to your investment program or that of your registered plan; you want the growth potential of equity securities of foreign companies; you're investing for the longer term; you tolerate medium risk; with respect to Series T and Series V securities, you prefer monthly distribution of capital.(This is a box varies in length)
>
>=RCHGetWebData(
>
Sat Mar 2, 2013 5:56 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
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:")
>
=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:
>
> =smfGetTagContent(
> =0+smfGetTagContent
>
Tidak ada komentar:
Posting Komentar