Messages In This Digest (18 Messages)
- 1a.
- RCHGetYahooHistory() From: lexstar
- 1b.
- Re: RCHGetYahooHistory() From: Randy Harmelink
- 2a.
- Company Name From: ehstats
- 2b.
- Re: Company Name From: Randy Harmelink
- 2c.
- Re: Company Name From: Mike McQuaid
- 2d.
- Re: Company Name From: Eric Stats
- 3a.
- Newbie - Error Message for Some Functions From: Anuraag
- 3b.
- Re: Newbie - Error Message for Some Functions From: Randy Harmelink
- 3c.
- Re: Newbie - Error Message for Some Functions From: Mike McQuaid
- 3d.
- Re: Newbie - Error Message for Some Functions From: Anuraag
- 4a.
- New but interesting question From: whitney
- 4b.
- Re: New but interesting question From: Randy H
- 4c.
- Re: New but interesting question From: whitney
- 4d.
- Re: New but interesting question From: Mike McQuaid
- 4e.
- Re: New but interesting question From: whitney
- 4f.
- Re: New but interesting question From: Randy H
- 4g.
- Re: New but interesting question From: whitney
- 4h.
- Re: New but interesting question From: Randy H
Messages
- 1a.
-
RCHGetYahooHistory()
Posted by: "lexstar" lexstar@yahoo.com lexstar
Fri Feb 10, 2012 6:37 am (PST)
I want to be able to retrieve the monthly PRICE ONLY (NOT monthly Total Return) Open/High/Low/Close for a particular Ticker from Date1 to Date2 (for example, look up the Price only OHLC for VFINX from 3/1/2000 to 6/1/2000). Can I use RCHGetYahooHistory?
When I try using:
=RCHGetYahooHistory($B5,YEAR( AA$4),MONTH( AA$4),DAY( AA$4),YEAR( K$4),MONTH( K$4),DAY( K$4),"m", "ohlc",0, 0,1,K$4-AA$ 4,4)
I get only the OHLC for the FIRST month. I want the OHLC for the period, not the first month.
Any suggestions? (I believe smfPricesBetween() only gives OHLC between the period, but ONLY for TOTAL RETURNS, not Price Returns).
- 1b.
-
Re: RCHGetYahooHistory()
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Fri Feb 10, 2012 7:36 am (PST)
What that formula should give you is four sets of monthly prices -- March,
April, May, and June. To see what should be returned, just go to Yahoo's
historical quotes page and plug in your dates. That's what you should be
getting.
For what it should like you're trying to do, you would need to retrieve the
entire period and then derive your desired result from the returned array
of data.
On Fri, Feb 10, 2012 at 7:37 AM, lexstar <lexstar@yahoo.com > wrote:
> I want to be able to retrieve the monthly PRICE ONLY (NOT monthly Total
> Return) Open/High/Low/Close for a particular Ticker from Date1 to Date2
> (for example, look up the Price only OHLC for VFINX from 3/1/2000 to
> 6/1/2000). Can I use RCHGetYahooHistory?
>
> When I try using:
>
>
> =RCHGetYahooHistory($B5,YEAR( AA$4),MONTH( AA$4),DAY( AA$4),YEAR( K$4),MONTH( K$4),DAY( K$4),"m", "ohlc",0, 0,1,K$4-AA$ 4,4)
>
> I get only the OHLC for the FIRST month. I want the OHLC for the period,
> not the first month.
>
> Any suggestions? (I believe smfPricesBetween() only gives OHLC between
> the period, but ONLY for TOTAL RETURNS, not Price Returns).
>
- 2a.
-
Company Name
Posted by: "ehstats" ericstats@gmail.com ehstats
Fri Feb 10, 2012 11:12 am (PST)
I saw in one of the posts to use RCHgetelementnumber to retrieve information about a company. I simply want to get the company names for a list of tickers. How do I do that?
- 2b.
-
Re: Company Name
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Fri Feb 10, 2012 11:17 am (PST)
Easiest way is to just use RCHGetYahooQuotes(), with the "n" Yahoo code.
However, different sources have different versions of the company names.
On Fri, Feb 10, 2012 at 12:12 PM, ehstats <ericstats@gmail.com > wrote:
> I saw in one of the posts to use RCHgetelementnumber to retrieve
> information about a company. I simply want to get the company names for a
> list of tickers. How do I do that?
>
- 2c.
-
Re: Company Name
Posted by: "Mike McQuaid" mikemcq802@yahoo.com mikemcq802
Fri Feb 10, 2012 11:18 am (PST)
Look in the directory you installed the SMF add in for a list of all the
element number definitions.
Then just enter:
=RCHGetElementNumber("AAPL", ###)
where ### is the number from the definitions file and use whatever ticker
you like - as literal or cell reference
_____
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf
Of ehstats
Sent: Friday, February 10, 2012 2:13 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Company Name
I saw in one of the posts to use RCHgetelementnumber to retrieve information
about a company. I simply want to get the company names for a list of
tickers. How do I do that?
- 2d.
-
Re: Company Name
Posted by: "Eric Stats" ericstats@gmail.com ehstats
Fri Feb 10, 2012 11:23 am (PST)
thanks
On Fri, Feb 10, 2012 at 12:19 PM, Mike McQuaid <mikemcq802@yahoo.com > wrote:
> **
>
>
> **
> Look in the directory you installed the SMF add in for a list of all the
> element number definitions.
>
> Then just enter:
>
> =RCHGetElementNumber("AAPL", ###)
>
> where ### is the number from the definitions file and use whatever ticker
> you like - as literal or cell reference
>
> --------------------- ---------
> *From:* smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] *On
> Behalf Of *ehstats
> *Sent:* Friday, February 10, 2012 2:13 PM
> *To:* smf_addin@yahoogroups.com
> *Subject:* [smf_addin] Company Name
>
>
>
> I saw in one of the posts to use RCHgetelementnumber to retrieve
> information about a company. I simply want to get the company names for a
> list of tickers. How do I do that?
>
>
>
--
Eric Stats, CFA
801-552-6631
Strategic, Tactical, and Algorithmic Trading Strategies
- 3a.
-
Newbie - Error Message for Some Functions
Posted by: "Anuraag" mohan_anuraag@yahoo.com mohan_anuraag
Fri Feb 10, 2012 12:33 pm (PST)
Hi,
I am new to this plugin and am absolutely blown away by its ease of use. I am getting an error for some element definitions. For instance, if I want to look up an data from barchart or stockhouse. I dont get any error for looking up data from MSN.
For Example
=RCHGetElementNumber("JPM",25) gives 37.47
=RCHGetElementNumber("JPM",701) gives an error
According to the spreadsheet I have, element 701 is trendspotter from barchart
Any help in this matter would be appreciated
Thanks
- 3b.
-
Re: Newbie - Error Message for Some Functions
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Fri Feb 10, 2012 12:41 pm (PST)
Element 701 works fine for me for JNJ. Are you using the most recent
version of the add-in? I had to redefine that element late last year
because of changes on their web site. StockHouse items were obsolete, but
earlier this month, I was able to redefine a number of the elements based
on the new StockScores web site.
You can check the version you're running with:
=RCHGetElementNumber("Version" )
On Fri, Feb 10, 2012 at 1:04 PM, Anuraag <mohan_anuraag@yahoo.com > wrote:
>
> I am new to this plugin and am absolutely blown away by its ease of use. I
> am getting an error for some element definitions. For instance, if I want
> to look up an data from barchart or stockhouse. I dont get any error for
> looking up data from MSN.
>
> For Example
>
> =RCHGetElementNumber("JPM",25) gives 37.47
>
> =RCHGetElementNumber("JPM",701) gives an error
>
> According to the spreadsheet I have, element 701 is trendspotter from
> barchart
>
> Any help in this matter would be appreciated
>
- 3c.
-
Re: Newbie - Error Message for Some Functions
Posted by: "Mike McQuaid" mikemcq802@yahoo.com mikemcq802
Fri Feb 10, 2012 12:42 pm (PST)
I don't get any error with your JPM,701 lookup exactly as you show it.
Do you have the latest version of SMF? Have you set your IE Cache properly?
common issues: http://finance.groups.yahoo. com/group/ smf_addin/ links
By the way, element 701 says JPM is a BUY :)
_____
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf
Of Anuraag
Sent: Friday, February 10, 2012 3:04 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Newbie - Error Message for Some Functions
Hi,
I am new to this plugin and am absolutely blown away by its ease of use. I
am getting an error for some element definitions. For instance, if I want to
look up an data from barchart or stockhouse. I dont get any error for
looking up data from MSN.
For Example
=RCHGetElementNumber("JPM",25) gives 37.47
=RCHGetElementNumber("JPM",701) gives an error
According to the spreadsheet I have, element 701 is trendspotter from
barchart
Any help in this matter would be appreciated
Thanks
- 3d.
-
Re: Newbie - Error Message for Some Functions
Posted by: "Anuraag" mohan_anuraag@yahoo.com mohan_anuraag
Fri Feb 10, 2012 1:40 pm (PST)
Many thanks for the reply. I have it running now. The version of SMF I was using was old.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Element 701 works fine for me for JNJ. Are you using the most recent
> version of the add-in? I had to redefine that element late last year
> because of changes on their web site. StockHouse items were obsolete, but
> earlier this month, I was able to redefine a number of the elements based
> on the new StockScores web site.
>
> You can check the version you're running with:
>
> =RCHGetElementNumber("Version" )
>
> On Fri, Feb 10, 2012 at 1:04 PM, Anuraag <mohan_anuraag@...> wrote:
>
> >
> > I am new to this plugin and am absolutely blown away by its ease of use. I
> > am getting an error for some element definitions. For instance, if I want
> > to look up an data from barchart or stockhouse. I dont get any error for
> > looking up data from MSN.
> >
> > For Example
> >
> > =RCHGetElementNumber("JPM",25) gives 37.47
> >
> > =RCHGetElementNumber("JPM",701) gives an error
> >
> > According to the spreadsheet I have, element 701 is trendspotter from
> > barchart
> >
> > Any help in this matter would be appreciated
> >
>
- 4a.
-
New but interesting question
Posted by: "whitney" thelancour@yahoo.com thelancour
Fri Feb 10, 2012 1:53 pm (PST)
Is there a way to use RCHGetTableCell to search for the cell above or below the endmarker? For example =RCHgettablecell("http://www.bcpa. net/RecInfo. "&A2&"",1,"Land Calculations"asp?URL_Folio= ,"Factor" ) I want the number in the cell BELOW the cell with "Factor" in it? Any help would be great!
- 4b.
-
Re: New but interesting question
Posted by: "Randy H" rharmelink@gmail.com rharmelink
Fri Feb 10, 2012 1:56 pm (PST)
Take a look at the "pRows" parameter. It allows you to move forwards and
backwards rows from your last found search string.
I couldn't give you an example based on your formula, because I can't
look at the web page without knowing what was in cell A2.
On Fri, Feb 10, 2012 at 2:48 PM, whitney <thelancour@yahoo.com > wrote:
Is there a way to use RCHGetTableCell to search for the cell above or
below the endmarker? For example
=RCHgettablecell("http://www.bcpa. net/RecInfo. asp?URL_Folio=
<http://www.bcpa.net/RecInfo. > "&A2&"",1,"Landasp?URL_Folio=
Calculations","Factor" ) I want the number in the cell BELOW the cell
with "Factor" in it? Any help would be great!
- 4c.
-
Re: New but interesting question
Posted by: "whitney" thelancour@yahoo.com thelancour
Fri Feb 10, 2012 3:31 pm (PST)
Oh whoops, I forgot to change that. Here it is revised, =RCHgettablecell("http://www.bcpa. net/RecInfo. ",1,"Land Calculations"asp?URL_Folio= 514112040270 ,"Factor" ), I want to get the number under the cell FACTOR which should be 6,969. An example would be really really helpful.
--- In smf_addin@yahoogroups.com , "Randy H" <rharmelink@...> wrote:
>
> Take a look at the "pRows" parameter. It allows you to move forwards and
> backwards rows from your last found search string.
>
> I couldn't give you an example based on your formula, because I can't
> look at the web page without knowing what was in cell A2.
>
> On Fri, Feb 10, 2012 at 2:48 PM, whitney <thelancour@...> wrote:
> Is there a way to use RCHGetTableCell to search for the cell above or
> below the endmarker? For example
> =RCHgettablecell("http://www.bcpa. net/RecInfo. asp?URL_Folio=
> <http://www.bcpa.net/RecInfo. > "&A2&"",1,"Landasp?URL_Folio=
> Calculations","Factor" ) I want the number in the cell BELOW the cell
> with "Factor" in it? Any help would be great!
>
- 4d.
-
Re: New but interesting question
Posted by: "Mike McQuaid" mikemcq802@yahoo.com mikemcq802
Fri Feb 10, 2012 3:42 pm (PST)
=RCHGetTableCell("http://www.bcpa. net/RecInfo. ",2,asp?URL_Folio= 514112040270
"Land <http://www.bcpa.net/RecInfo. >asp?URL_Folio= 514112040270
Calculations","Factor" ,,,1)
The 1 on the end is the pRows Randy described - it skips to the next row.
The 2 then gives the 2nd cell on that row which is the number you want.
_____
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf
Of whitney
Sent: Friday, February 10, 2012 6:32 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Re: New but interesting question
Oh whoops, I forgot to change that. Here it is revised,
=RCHgettablecell("http://www.bcpa. net/RecInfo. ",1,asp?URL_Folio= 514112040270
"Land Calculations","Factor" ), I want to get the number under the cell
FACTOR which should be 6,969. An example would be really really helpful.
--- In smf_addin@yahoogroups.com <mailto:smf_addin%40yahoogro ups.com> ,
"Randy H" <rharmelink@...> wrote:
>
> Take a look at the "pRows" parameter. It allows you to move forwards and
> backwards rows from your last found search string.
>
> I couldn't give you an example based on your formula, because I can't
> look at the web page without knowing what was in cell A2.
>
> On Fri, Feb 10, 2012 at 2:48 PM, whitney <thelancour@...> wrote:
> Is there a way to use RCHGetTableCell to search for the cell above or
> below the endmarker? For example
> =RCHgettablecell("http://www.bcpa. net/RecInfo. asp?URL_Folio=
> <http://www.bcpa.net/RecInfo. > "&A2&"",1,"Landasp?URL_Folio=
> Calculations","Factor" ) I want the number in the cell BELOW the cell
> with "Factor" in it? Any help would be great!
>
- 4e.
-
Re: New but interesting question
Posted by: "whitney" thelancour@yahoo.com thelancour
Fri Feb 10, 2012 4:51 pm (PST)
Ok I follow, thank you. However when I try to get the date of the sale in the adjacent table, it doesnt work. Same concept =RCHgettablecell("http://www.bcpa. net/RecInfo. ",1,"Sales History","Date"asp?URL_Folio= 514112040270 ,,,1) The last 1 should drop me down to the next row after DATE and the first 1 should give me the date cell of 12/7/2011. ???????
--- In smf_addin@yahoogroups.com , "Mike McQuaid" <mikemcq802@...> wrote:
>
> =RCHGetTableCell("http://www.bcpa. net/RecInfo. ",2,asp?URL_Folio= 514112040270
> "Land <http://www.bcpa.net/RecInfo. >asp?URL_Folio= 514112040270
> Calculations","Factor" ,,,1)
>
> The 1 on the end is the pRows Randy described - it skips to the next row.
>
> The 2 then gives the 2nd cell on that row which is the number you want.
>
> _____
>
> From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf
> Of whitney
> Sent: Friday, February 10, 2012 6:32 PM
> To: smf_addin@yahoogroups.com
> Subject: [smf_addin] Re: New but interesting question
>
>
>
>
> Oh whoops, I forgot to change that. Here it is revised,
> =RCHgettablecell("http://www.bcpa. net/RecInfo. ",1,asp?URL_Folio= 514112040270
> "Land Calculations","Factor" ), I want to get the number under the cell
> FACTOR which should be 6,969. An example would be really really helpful.
>
> --- In smf_addin@yahoogroups.com <mailto:smf_addin%40yahoogro ups.com> ,
> "Randy H" <rharmelink@> wrote:
> >
> > Take a look at the "pRows" parameter. It allows you to move forwards and
> > backwards rows from your last found search string.
> >
> > I couldn't give you an example based on your formula, because I can't
> > look at the web page without knowing what was in cell A2.
> >
> > On Fri, Feb 10, 2012 at 2:48 PM, whitney <thelancour@> wrote:
> > Is there a way to use RCHGetTableCell to search for the cell above or
> > below the endmarker? For example
> > =RCHgettablecell("http://www.bcpa. net/RecInfo. asp?URL_Folio=
> > <http://www.bcpa.net/RecInfo. > "&A2&"",1,"Landasp?URL_Folio=
> > Calculations","Factor" ) I want the number in the cell BELOW the cell
> > with "Factor" in it? Any help would be great!
> >
>
- 4f.
-
Re: New but interesting question
Posted by: "Randy H" rharmelink@gmail.com rharmelink
Fri Feb 10, 2012 5:01 pm (PST)
That's because your search terms aren't unique enough. If I look at the
source code of the web page, the first occurrence of "Sales History" is
a comment line. The first occurrence of "Date" following that is
another comment line. So if I get the 1st cell of the next row, I'm
only in the cell containing the header of the table.
Try this instead:
=RCHGetTableCell("http://www.bcpa. net/RecInfo. ",1,"Subdivision Sales","Date"asp?URL_Folio= 514112040270\
,,,1)
On Fri, Feb 10, 2012 at 5:51 PM, whitney <thelancour@yahoo.com > wrote:
Ok I follow, thank you. However when I try to get the date of the sale
in the adjacent table, it doesnt work. Same concept
=RCHgettablecell("http://www.bcpa. net/RecInfo. asp?URL_Folio= 514112040270
<http://www.bcpa.net/RecInfo. > ",1,"Salesasp?URL_Folio= 514112040270
History","Date",,,1) The last 1 should drop me down to the next row
after DATE and the first 1 should give me the date cell of 12/7/2011.
???????
- 4g.
-
Re: New but interesting question
Posted by: "whitney" thelancour@yahoo.com thelancour
Fri Feb 10, 2012 5:31 pm (PST)
thank you. If I want to go for earlier sale dates is it as simple as changing the last digit to a 2 or 3 for 2nd and 3rd row respectively? Seems to be giving me an error.......
--- In smf_addin@yahoogroups.com , "Randy H" <rharmelink@...> wrote:
>
> That's because your search terms aren't unique enough. If I look at the
> source code of the web page, the first occurrence of "Sales History" is
> a comment line. The first occurrence of "Date" following that is
> another comment line. So if I get the 1st cell of the next row, I'm
> only in the cell containing the header of the table.
>
> Try this instead:
>
> =RCHGetTableCell("http://www.bcpa. net/RecInfo. > ",1,"Subdivision Sales","Date"asp?URL_Folio= 514112040270\
,,,1)
>
> On Fri, Feb 10, 2012 at 5:51 PM, whitney <thelancour@...> wrote:
> Ok I follow, thank you. However when I try to get the date of the sale
> in the adjacent table, it doesnt work. Same concept
> =RCHgettablecell("http://www.bcpa. net/RecInfo. asp?URL_Folio= 514112040270
> <http://www.bcpa.net/RecInfo. > ",1,"Salesasp?URL_Folio= 514112040270
> History","Date",,,1) The last 1 should drop me down to the next row
> after DATE and the first 1 should give me the date cell of 12/7/2011.
> ???????
>
- 4h.
-
Re: New but interesting question
Posted by: "Randy H" rharmelink@gmail.com rharmelink
Fri Feb 10, 2012 5:47 pm (PST)
Typically, that's what you would do. However, the problem is that the
table is not coded properly in HTML. They have tags for the end of the
row, but not to start the next row.
A workaround would be to use something like:
=smfGetTagContent("http://www.bcpa. net/RecInfo. ","span",_n_asp?URL_Folio= 51411204027\
0,"Subdivision Sales","Page" )
...where you would vary _n_ from 1 to whatever to get the next table
cell, ignoring how the rows of the table are coded.
On Fri, Feb 10, 2012 at 6:31 PM, whitney <thelancour@yahoo.com > wrote:
thank you. If I want to go for earlier sale dates is it as simple as
changing the last digit to a 2 or 3 for 2nd and 3rd row respectively?
Seems to be giving me an error.......
Need to Reply?
Click one of the "Reply" links to respond to a specific message in the Daily Digest.
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