15 New Messages
Digest #2280
3a
Error with RCHGetElementNumber, but not with other commands by "sergeikotelnikov" sergeikotelnikov
Messages
Sun Jul 15, 2012 4:17 pm (PDT) . Posted by:
"colinmmoors" colinmmoors
i checked the version and it's the beta: Stock Market Functions add-in, Version 2.1.2012.07.12 (C:\Program Files (x86)\smf addin; 1)
the invocation i'm using is: =RCHGetYahooHistory(M531,YEAR($J531),MONTH($J531),DAY($J531),YEAR($J531),MONTH($J531),DAY($J531),"d",V$2,0,0,0)
for symbol JPM, I get 7/13 close of 36.03 (from first row of data) instead of correct 36.07
maybe because i'm not using within an array (I can't because of how sheet is setup)?
thanks, colin
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Shouldn't. The latest 2.1.2012.07.19 is exactly the set of files that I use.
>
> What is your exact function invocation that you are having problems with?
>
> On Sat, Jul 14, 2012 at 4:06 PM, colinmmoors <colinmmoors@...> wrote:
>
> > Randy, after overwriting the new smf_addin files, do i need to do anything
> > else? thanks
> >
>
the invocation i'm using is: =RCHGetYahooHistory
for symbol JPM, I get 7/13 close of 36.03 (from first row of data) instead of correct 36.07
maybe because i'm not using within an array (I can't because of how sheet is setup)?
thanks, colin
--- In smf_addin@yahoogrou
>
> Shouldn't. The latest 2.1.2012.07.
>
> What is your exact function invocation that you are having problems with?
>
> On Sat, Jul 14, 2012 at 4:06 PM, colinmmoors <colinmmoors@
>
> > Randy, after overwriting the new smf_addin files, do i need to do anything
> > else? thanks
> >
>
Sun Jul 15, 2012 5:00 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Actually, if you're just looking for a single date, my code is not going to
work. I stop once the request is filled. In this case, one row. I don't
think I'm going to change the processing. There are too many issues that
come up. I really don't want to spend a lot of time on what is essentially
a Yahoo data problem. Time would be better spent lobbying Yahoo to get it
fixed.
However, there is an easy work-around you can use -- just request 2 rows of
data and enter the formula into a single row. For example:
=RCHGetYahooHistory(M531,YEAR($J531),MONTH($J531),DAY($J531),YEAR($J531),MONTH($J531),DAY($J531),"d",V$2,0,0,0
*,2,1*)
On Sun, Jul 15, 2012 at 4:16 PM, colinmmoors <colinmmoors@yahoo.com > wrote:
> i checked the version and it's the beta: Stock Market Functions add-in,
> Version 2.1.2012.07.12 (C:\Program Files (x86)\smf addin; 1)
>
> the invocation i'm using is:
> =RCHGetYahooHistory(M531,YEAR($J531),MONTH($J531),DAY($J531),YEAR($J531),MONTH($J531),DAY($J531),"d",V$2,0,0,0)
>
> for symbol JPM, I get 7/13 close of 36.03 (from first row of data) instead
> of correct 36.07
>
> maybe because i'm not using within an array (I can't because of how sheet
> is setup)?
>
work. I stop once the request is filled. In this case, one row. I don't
think I'm going to change the processing. There are too many issues that
come up. I really don't want to spend a lot of time on what is essentially
a Yahoo data problem. Time would be better spent lobbying Yahoo to get it
fixed.
However, there is an easy work-around you can use -- just request 2 rows of
data and enter the formula into a single row. For example:
=RCHGetYahooHistory
*,2,1*)
On Sun, Jul 15, 2012 at 4:16 PM, colinmmoors <colinmmoors@
> i checked the version and it's the beta: Stock Market Functions add-in,
> Version 2.1.2012.07.
>
> the invocation i'm using is:
> =RCHGetYahooHistory
>
> for symbol JPM, I get 7/13 close of 36.03 (from first row of data) instead
> of correct 36.07
>
> maybe because i'm not using within an array (I can't because of how sheet
> is setup)?
>
Sun Jul 15, 2012 4:25 pm (PDT) . Posted by:
"whitney" thelancour
Does this not work on windows 7? I was able to get it to work on my work computer which still has XP, but my home computer will return "NAME?" when I enter the formula. Thanks.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> You should be able to get the two "Year Built" values with:
>
> =0+smfStrExtr(smfGetTagContent("
> http://www.bcpa.net/RecInfo.asp?URL_Folio=514012050260-Prev ","td",-1,"Year
> Built"),"theyear=","'")
>
> =0+smfStrExtr(smfStrExtr(smfGetTagContent("
> http://www.bcpa.net/RecInfo.asp?URL_Folio=514012050260-Prev ","td",-1,"Year
> Built"),"Year Built","Year Built"),"theyear=","'")
>
> On Sun, Mar 11, 2012 at 4:04 PM, whitney <thelancour@...> wrote:
>
> > IS there anyway to get a value from a link? for instance
> > http://www.bcpa.net/RecInfo.asp?URL_Folio=514012050260-Prev if you
> > click on Act. Year Built it will pop up a cell value in a window. CAn smf
> > do anything to gain this value? have a look and see what you think
> >
>
--- In smf_addin@yahoogrou
>
> You should be able to get the two "Year Built" values with:
>
> =0+smfStrExtr(
> http://www.bcpa.
> Built"),"theyear=
>
> =0+smfStrExtr(
> http://www.bcpa.
> Built"),"Year Built","Year Built"),"theyear=
>
> On Sun, Mar 11, 2012 at 4:04 PM, whitney <thelancour@
>
> > IS there anyway to get a value from a link? for instance
> > http://www.bcpa.
> > click on Act. Year Built it will pop up a cell value in a window. CAn smf
> > do anything to gain this value? have a look and see what you think
> >
>
Sun Jul 15, 2012 5:02 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Which item in the formula is causing the #NAME? error? Which version of the
add-in are you using?
On Sun, Jul 15, 2012 at 4:25 PM, whitney <thelancour@yahoo.com > wrote:
> Does this not work on windows 7? I was able to get it to work on my work
> computer which still has XP, but my home computer will return "NAME?" when
> I enter the formula. Thanks.
>
> --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
> >
> > You should be able to get the two "Year Built" values with:
> >
> > =0+smfStrExtr(smfGetTagContent("
> > http://www.bcpa.net/RecInfo.asp?URL_Folio=514012050260-Prev
> ","td",-1,"Year
> > Built"),"theyear=","'")
> >
> > =0+smfStrExtr(smfStrExtr(smfGetTagContent("
> > http://www.bcpa.net/RecInfo.asp?URL_Folio=514012050260-Prev
> ","td",-1,"Year
> > Built"),"Year Built","Year Built"),"theyear=","'")
>
add-in are you using?
On Sun, Jul 15, 2012 at 4:25 PM, whitney <thelancour@yahoo.
> Does this not work on windows 7? I was able to get it to work on my work
> computer which still has XP, but my home computer will return "NAME?" when
> I enter the formula. Thanks.
>
> --- In smf_addin@yahoogrou
> >
> > You should be able to get the two "Year Built" values with:
> >
> > =0+smfStrExtr(
> > http://www.bcpa.
> ","td",-1,"Year
> > Built"),"theyear=
> >
> > =0+smfStrExtr(
> > http://www.bcpa.
> ","td",-1,"Year
> > Built"),"Year Built","Year Built"),"theyear=
>
Sun Jul 15, 2012 6:44 pm (PDT) . Posted by:
"whitney" thelancour
I am running version 1.0 on both computers, I just cut and paste the formula into a spreadsheet, works on my xp computer, but not my windows 7, other than that there is are no other differences.....??
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Which item in the formula is causing the #NAME? error? Which version of the
> add-in are you using?
>
> On Sun, Jul 15, 2012 at 4:25 PM, whitney <thelancour@...> wrote:
>
> > Does this not work on windows 7? I was able to get it to work on my work
> > computer which still has XP, but my home computer will return "NAME?" when
> > I enter the formula. Thanks.
> >
> > --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@> wrote:
> > >
> > > You should be able to get the two "Year Built" values with:
> > >
> > > =0+smfStrExtr(smfGetTagContent("
> > > http://www.bcpa.net/RecInfo.asp?URL_Folio=514012050260-Prev
> > ","td",-1,"Year
> > > Built"),"theyear=","'")
> > >
> > > =0+smfStrExtr(smfStrExtr(smfGetTagContent("
> > > http://www.bcpa.net/RecInfo.asp?URL_Folio=514012050260-Prev
> > ","td",-1,"Year
> > > Built"),"Year Built","Year Built"),"theyear=","'")
> >
>
--- In smf_addin@yahoogrou
>
> Which item in the formula is causing the #NAME? error? Which version of the
> add-in are you using?
>
> On Sun, Jul 15, 2012 at 4:25 PM, whitney <thelancour@
>
> > Does this not work on windows 7? I was able to get it to work on my work
> > computer which still has XP, but my home computer will return "NAME?" when
> > I enter the formula. Thanks.
> >
> > --- In smf_addin@yahoogrou
> > >
> > > You should be able to get the two "Year Built" values with:
> > >
> > > =0+smfStrExtr(
> > > http://www.bcpa.
> > ","td",-1,"Year
> > > Built"),"theyear=
> > >
> > > =0+smfStrExtr(
> > > http://www.bcpa.
> > ","td",-1,"Year
> > > Built"),"Year Built","Year Built"),"theyear=
> >
>
Sun Jul 15, 2012 6:49 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Version 1.0 of the add-in? If so, none of those functions I used are
available. It shouldn't work on either computer.
On Sun, Jul 15, 2012 at 6:43 PM, whitney <thelancour@yahoo.com > wrote:
> I am running version 1.0 on both computers, I just cut and paste the
> formula into a spreadsheet, works on my xp computer, but not my windows 7,
> other than that there is are no other differences.....??
>
> --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
> >
> > Which item in the formula is causing the #NAME? error? Which version of
> the
> > add-in are you using?
>
available. It shouldn't work on either computer.
On Sun, Jul 15, 2012 at 6:43 PM, whitney <thelancour@yahoo.
> I am running version 1.0 on both computers, I just cut and paste the
> formula into a spreadsheet, works on my xp computer, but not my windows 7,
> other than that there is are no other differences.
>
> --- In smf_addin@yahoogrou
> >
> > Which item in the formula is causing the #NAME? error? Which version of
> the
> > add-in are you using?
>
Sun Jul 15, 2012 7:23 pm (PDT) . Posted by:
"whitney" thelancour
Ok, whoops, I had the the old version clicked as active for the add-in not the update for 2.12.2012, Got it now! Thanks!
--- In smf_addin@yahoogrou
>
> Version 1.0 of the add-in? If so, none of those functions I used are
> available. It shouldn't work on either computer.
>
> On Sun, Jul 15, 2012 at 6:43 PM, whitney <thelancour@
>
> > I am running version 1.0 on both computers, I just cut and paste the
> > formula into a spreadsheet, works on my xp computer, but not my windows 7,
> > other than that there is are no other differences.
> >
> > --- In smf_addin@yahoogrou
> > >
> > > Which item in the formula is causing the #NAME? error? Which version of
> > the
> > > add-in are you using?
> >
>
Sun Jul 15, 2012 7:58 pm (PDT) . Posted by:
"whitney" thelancour
but with the updates, i cannot use any functions to extract data from this page http://www.bcpa.
I was trying to use RCHGetHTMLTable, RCHGetTableCell, and smftag? any other suggestions?
--- In smf_addin@yahoogrou
>
>
> Ok, whoops, I had the the old version clicked as active for the add-in not the update for 2.12.2012, Got it now! Thanks!
>
>
> --- In smf_addin@yahoogrou
> >
> > Version 1.0 of the add-in? If so, none of those functions I used are
> > available. It shouldn't work on either computer.
> >
> > On Sun, Jul 15, 2012 at 6:43 PM, whitney <thelancour@
> >
> > > I am running version 1.0 on both computers, I just cut and paste the
> > > formula into a spreadsheet, works on my xp computer, but not my windows 7,
> > > other than that there is are no other differences.
> > >
> > > --- In smf_addin@yahoogrou
> > > >
> > > > Which item in the formula is causing the #NAME? error? Which version of
> > > the
> > > > add-in are you using?
> > >
> >
>
Sun Jul 15, 2012 8:02 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
I get "Page Not Found" for that URL.
On Sun, Jul 15, 2012 at 7:58 PM, whitney <thelancour@yahoo.com > wrote:
>
> but with the updates, i cannot use any functions to extract data from this
> page
> http://www.bcpa.net/RecSearch.aspURL_Sort=Folio&URL_Seq=0&URL_Name=BANK%20OF%20AMERICA
>
> I was trying to use RCHGetHTMLTable, RCHGetTableCell, and smftag? any
> other suggestions?
>
On Sun, Jul 15, 2012 at 7:58 PM, whitney <thelancour@yahoo.
>
> but with the updates, i cannot use any functions to extract data from this
> page
> http://www.bcpa.
>
> I was trying to use RCHGetHTMLTable, RCHGetTableCell, and smftag? any
> other suggestions?
>
Sun Jul 15, 2012 8:40 pm (PDT) . Posted by:
"whitney" thelancour
here we go
http://www.bcpa.net/RecSearch.asp?URL_Sort=Folio&URL_Seq=0&URL_Name=BANK%20OF%20AMERICA
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> I get "Page Not Found" for that URL.
>
> On Sun, Jul 15, 2012 at 7:58 PM, whitney <thelancour@...> wrote:
>
> >
> > but with the updates, i cannot use any functions to extract data from this
> > page
> > http://www.bcpa.net/RecSearch.aspURL_Sort=Folio&URL_Seq=0&URL_Name=BANK%20OF%20AMERICA
> >
> > I was trying to use RCHGetHTMLTable, RCHGetTableCell, and smftag? any
> > other suggestions?
> >
>
http://www.bcpa.
--- In smf_addin@yahoogrou
>
> I get "Page Not Found" for that URL.
>
> On Sun, Jul 15, 2012 at 7:58 PM, whitney <thelancour@
>
> >
> > but with the updates, i cannot use any functions to extract data from this
> > page
> > http://www.bcpa.
> >
> > I was trying to use RCHGetHTMLTable, RCHGetTableCell, and smftag? any
> > other suggestions?
> >
>
Sun Jul 15, 2012 9:38 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
This workw for me:
=RcHGetHTMLTable("
http://www.bcpa.net/RecSearch.asp?URL_Sort=Folio&URL_Seq=0&URL_Name=BANK%20OF%20AMERICA ","Owner
Name",-1,"",1)
On Sun, Jul 15, 2012 at 8:40 PM, whitney <thelancour@yahoo.com > wrote:
> here we go
>
>
> http://www.bcpa.net/RecSearch.asp?URL_Sort=Folio&URL_Seq=0&URL_Name=BANK%20OF%20AMERICA
>
> --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
> >
> > I get "Page Not Found" for that URL.
> >
> > On Sun, Jul 15, 2012 at 7:58 PM, whitney <thelancour@...> wrote:
> >
> > >
> > > but with the updates, i cannot use any functions to extract data from
> this
> > > page
> > >
> http://www.bcpa.net/RecSearch.aspURL_Sort=Folio&URL_Seq=0&URL_Name=BANK%20OF%20AMERICA
> > >
> > > I was trying to use RCHGetHTMLTable, RCHGetTableCell, and smftag? any
> > > other suggestions?
>
=RcHGetHTMLTable(
http://www.bcpa.
Name",-1,"",
On Sun, Jul 15, 2012 at 8:40 PM, whitney <thelancour@yahoo.
> here we go
>
>
> http://www.bcpa.
>
> --- In smf_addin@yahoogrou
> >
> > I get "Page Not Found" for that URL.
> >
> > On Sun, Jul 15, 2012 at 7:58 PM, whitney <thelancour@
> >
> > >
> > > but with the updates, i cannot use any functions to extract data from
> this
> > > page
> > >
> http://www.bcpa.
> > >
> > > I was trying to use RCHGetHTMLTable, RCHGetTableCell, and smftag? any
> > > other suggestions?
>
Sun Jul 15, 2012 9:56 pm (PDT) . Posted by:
"whitney" thelancour
right, but i want to retrieve all the underlying info, the actual folio numbers,and addresses. I can get the sameline, but cannot get all the subsequent info.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> This workw for me:
>
> =RcHGetHTMLTable("
> http://www.bcpa.net/RecSearch.asp?URL_Sort=Folio&URL_Seq=0&URL_Name=BANK%20OF%20AMERICA ","Owner
> Name",-1,"",1)
>
> On Sun, Jul 15, 2012 at 8:40 PM, whitney <thelancour@...> wrote:
>
> > here we go
> >
> >
> > http://www.bcpa.net/RecSearch.asp?URL_Sort=Folio&URL_Seq=0&URL_Name=BANK%20OF%20AMERICA
> >
> > --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@> wrote:
> > >
> > > I get "Page Not Found" for that URL.
> > >
> > > On Sun, Jul 15, 2012 at 7:58 PM, whitney <thelancour@> wrote:
> > >
> > > >
> > > > but with the updates, i cannot use any functions to extract data from
> > this
> > > > page
> > > >
> > http://www.bcpa.net/RecSearch.aspURL_Sort=Folio&URL_Seq=0&URL_Name=BANK%20OF%20AMERICA
> > > >
> > > > I was trying to use RCHGetHTMLTable, RCHGetTableCell, and smftag? any
> > > > other suggestions?
> >
>
--- In smf_addin@yahoogrou
>
> This workw for me:
>
> =RcHGetHTMLTable(
> http://www.bcpa.
> Name",-1,"",
>
> On Sun, Jul 15, 2012 at 8:40 PM, whitney <thelancour@
>
> > here we go
> >
> >
> > http://www.bcpa.
> >
> > --- In smf_addin@yahoogrou
> > >
> > > I get "Page Not Found" for that URL.
> > >
> > > On Sun, Jul 15, 2012 at 7:58 PM, whitney <thelancour@
> > >
> > > >
> > > > but with the updates, i cannot use any functions to extract data from
> > this
> > > > page
> > > >
> > http://www.bcpa.
> > > >
> > > > I was trying to use RCHGetHTMLTable, RCHGetTableCell, and smftag? any
> > > > other suggestions?
> >
>
Sun Jul 15, 2012 10:04 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
That returns the folio number, the owner name, and the property address...??
If you want more detailed information on the folio number, you'd need to
capture the URL for the folio number and then capture the data from that
web page.
On Sun, Jul 15, 2012 at 9:56 PM, whitney <thelancour@yahoo.com > wrote:
> right, but i want to retrieve all the underlying info, the actual folio
> numbers,and addresses. I can get the sameline, but cannot get all the
> subsequent info.
>
If you want more detailed information on the folio number, you'd need to
capture the URL for the folio number and then capture the data from that
web page.
On Sun, Jul 15, 2012 at 9:56 PM, whitney <thelancour@yahoo.
> right, but i want to retrieve all the underlying info, the actual folio
> numbers,and addresses. I can get the sameline, but cannot get all the
> subsequent info.
>
Sun Jul 15, 2012 5:29 pm (PDT) . Posted by:
"sergeikotelnikov" sergeikotelnikov
Randy,
I have a strange problem. I have the February 2012 version of the xla file. My spreadsheets return an error message for some, but not all RCHGetElementNumber commands. For instance, I get an error message for (ticker, 4), but not for (ticker, 617). What could be the problem?
If this is relevant, I run Excel 2007.
Thank you!
I have a strange problem. I have the February 2012 version of the xla file. My spreadsheets return an error message for some, but not all RCHGetElementNumber commands. For instance, I get an error message for (ticker, 4), but not for (ticker, 617). What could be the problem?
If this is relevant, I run Excel 2007.
Thank you!
Sun Jul 15, 2012 5:31 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
The problem is that MSN elements had to be redefined because of changes to
their web site layout.
See: http://finance.groups.yahoo.com/group/smf_addin/message/18529
Best practice:
1. Exit EXCEL
2. Download the new version of the element definition file
3. Replace the older version of this file in your add-in's file folder
with the newer downloaded version
4. Restart EXCEL
On Sun, Jul 15, 2012 at 5:22 PM, sergeikotelnikov <
sergeikotelnikov@yahoo.com > wrote:
>
> I have a strange problem. I have the February 2012 version of the xla
> file. My spreadsheets return an error message for some, but not all
> RCHGetElementNumber commands. For instance, I get an error message for
> (ticker, 4), but not for (ticker, 617). What could be the problem?
>
> If this is relevant, I run Excel 2007.
>
their web site layout.
See: http://finance.
Best practice:
1. Exit EXCEL
2. Download the new version of the element definition file
3. Replace the older version of this file in your add-in's file folder
with the newer downloaded version
4. Restart EXCEL
On Sun, Jul 15, 2012 at 5:22 PM, sergeikotelnikov <
sergeikotelnikov@
>
> I have a strange problem. I have the February 2012 version of the xla
> file. My spreadsheets return an error message for some, but not all
> RCHGetElementNumber commands. For instance, I get an error message for
> (ticker, 4), but not for (ticker, 617). What could be the problem?
>
> If this is relevant, I run Excel 2007.
>
Tidak ada komentar:
Posting Komentar