Messages In This Digest (7 Messages)
- 1a.
- Re: Getting data - which function From: agdalban
- 1b.
- Re: Getting data - which function From: Randy Harmelink
- 2a.
- Re: ^VIX data From: grandparalphy
- 2b.
- Re: ^VIX data From: SANCHO
- 3a.
- RCHGetElementNumber 5079 From: lexstar
- 3b.
- Re: RCHGetElementNumber 5079 From: Randy Harmelink
- 4a.
- Re: DJIA quotes from Yahoo (^DJI and INDU both failing) From: spamfiel
Messages
- 1a.
-
Re: Getting data - which function
Posted by: "agdalban" work@astridhome.net agdalban
Tue Nov 8, 2011 2:58 am (PST)
Thank you - I did get that to work as well, but in the meantime I realised what the problem is - either formula will return only the default first 20 dates, which is what the page opens to as a default.
The page can provide several years of daily data, which get cached as a continuation of the table (page 1 of x, page 2 of x etc.) in the page source (from line 769 in the source) ONCE one has selected a timeframe(right above the table on the webpage)- it changes the page source (from line 606) with this type of code: <option value="08" selected="selected">08</option> and so on for month, day of both the start and end date (end date will default to latest, so I'm not too concerned about it. Start date is the issue).
Unfortunately, that timeframe selection does not get reflected in the url, which remains the same, so I don't see how to get to the earlier data.
Is that possible at all with the add-in?
Thank you
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> I'm not having a problem with it -- just tried both:
>
> =RCHGetHTMLTable("
> http://bourse.votreargent. lexpress. fr/cours- sicav-fcp/ cours-AMUNDI+ INTERNATIONAL+ A+USD+CAP- LU0068578508/ graphique_ evolutions
> ",">Dernier",-1,"",1)
>
> =RCHGetTableCell("
> http://bourse.votreargent. lexpress. fr/cours- sicav-fcp/ cours-AMUNDI+ INTERNATIONAL+ A+USD+CAP- LU0068578508/ graphique_ evolutions
> ",1,">Dernier",,,,1)
>
> ...but I did drop the anchor specification from the URL. Not sure why I get
> different results with it and without it -- it should only be a browser
> directive, not a web page parameter.
>
> On Sun, Nov 6, 2011 at 2:26 AM, agdalban <work@...> wrote:
>
> >
> > My question: I have been trying to extract the table data from this page:
> > "
> > http://bourse.votreargent. lexpress. fr/cours- sicav-fcp/ cours-AMUNDI+ INTERNATIONAL+ A+USD+CAP- LU0068578508/ graphique_ evolutions# histo_anchor
> > "
> >
> > I can tell from the page source code that all the data I need is there,
> > and it doesn't look that different from the Yahoo type of coding to me...
> > but I am unable to retrieve it with the GetHTMLTable function, and I have
> > not been able to tweak GetWebData or GetTableCell templates to get it
> > either (am not proficient with these...).
> >
> > Could someone please point me in the right direction? Maybe give me a
> > formula to at least get one of the datapoints in there, and I'll build on
> > it...
> > This is unfortunately the only website that will provide this data on a
> > historical basis, so I really need it.
> >
> > Many thanks in advance
> >
>
- 1b.
-
Re: Getting data - which function
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Tue Nov 8, 2011 3:19 am (PST)
Sorry, but you need a bookmarkable URL in order for the add-in to process
the web page. So you would need the parameters to be in the URL.
On Tue, Nov 8, 2011 at 3:58 AM, agdalban <work@astridhome.net > wrote:
>
> Thank you - I did get that to work as well, but in the meantime I realised
> what the problem is - either formula will return only the default first 20
> dates, which is what the page opens to as a default.
>
> The page can provide several years of daily data, which get cached as a
> continuation of the table (page 1 of x, page 2 of x etc.) in the page
> source (from line 769 in the source) ONCE one has selected a
> timeframe(right above the table on the webpage)- it changes the page source
> (from line 606) with this type of code: <option value="08"
> selected="selected">08</option> and so on for month, day of both the start
> and end date (end date will default to latest, so I'm not too concerned
> about it. Start date is the issue).
>
> Unfortunately, that timeframe selection does not get reflected in the url,
> which remains the same, so I don't see how to get to the earlier data.
>
> Is that possible at all with the add-in?
>
- 2a.
-
Re: ^VIX data
Posted by: "grandparalphy" grandparalph@comcast.net grandparalphy
Tue Nov 8, 2011 5:59 am (PST)
Thanks, Randy
I had done a search in the messages to see if anyone else had this issue, but didn't see the other user who complained about it until a few hours after I posted.
FWIW, I've had issues with ^VIX data intermittently with my queries for over a year. Sometimes, usually after hours, the data returned is just totally wrong, like maybe 10 times the actual value, so I used some limit checking to detect this and give myself a warning.
Ralph
--- In smf_addin@yahoogroups.com , "grandparalphy" <grandparalph@...> wrote:
>
> Hi, new user here, and loving it.
>
> I have replaced a bunch of web queries with functions from the add-in, and have gotten all to work, but seem to have an issue retrieving ^VIX and ^TNX data from Yahoo!
>
> I have the code below in 2 block of cells, array entered, 4 colums wide:
>
> =RCHGetYahooQuotes("^VIX",,, NOW())
> =RCHGetYahooQuotes("^TNX",,, NOW())
>
> The data returned as of Monday, Nov 7 is:
>
> ^VIX 30.16 11/4/2011 3:14pm
> ^TNX 2.05 11/4/2011 1:59pm
>
> I have tried the Recalculation macro, closed Excel and reopened, shut down computer and restarted, still it returns last Friday's mid-day data. I have rerun my version with with the old web queries, and they return the correct data for today's close, which is 29.85 for the VIX and and 1.99 for the TNX.
>
> Any ideas? And thanks so much for this great tool!
>
> I'm using Windows 7, Excel 2010.
>
> Ralph
>
- 2b.
-
Re: ^VIX data
Posted by: "SANCHO" sancho_best@yahoo.com sancho_best
Tue Nov 8, 2011 7:57 am (PST)
No one index quote works for second day......
No one european US or asian indexes proceed into a spreadsheet usig RCHGetYahooQuote function...
--- In smf_addin@yahoogroups.com , "grandparalphy" <grandparalph@...> wrote:
>
> Thanks, Randy
>
> I had done a search in the messages to see if anyone else had this issue, but didn't see the other user who complained about it until a few hours after I posted.
>
> FWIW, I've had issues with ^VIX data intermittently with my queries for over a year. Sometimes, usually after hours, the data returned is just totally wrong, like maybe 10 times the actual value, so I used some limit checking to detect this and give myself a warning.
>
> Ralph
>
> --- In smf_addin@yahoogroups.com , "grandparalphy" <grandparalph@> wrote:
> >
> > Hi, new user here, and loving it.
> >
> > I have replaced a bunch of web queries with functions from the add-in, and have gotten all to work, but seem to have an issue retrieving ^VIX and ^TNX data from Yahoo!
> >
> > I have the code below in 2 block of cells, array entered, 4 colums wide:
> >
> > =RCHGetYahooQuotes("^VIX",,, NOW())
> > =RCHGetYahooQuotes("^TNX",,, NOW())
> >
> > The data returned as of Monday, Nov 7 is:
> >
> > ^VIX 30.16 11/4/2011 3:14pm
> > ^TNX 2.05 11/4/2011 1:59pm
> >
> > I have tried the Recalculation macro, closed Excel and reopened, shut down computer and restarted, still it returns last Friday's mid-day data. I have rerun my version with with the old web queries, and they return the correct data for today's close, which is 29.85 for the VIX and and 1.99 for the TNX.
> >
> > Any ideas? And thanks so much for this great tool!
> >
> > I'm using Windows 7, Excel 2010.
> >
> > Ralph
> >
>
- 3a.
-
RCHGetElementNumber 5079
Posted by: "lexstar" lexstar@yahoo.com lexstar
Tue Nov 8, 2011 6:17 am (PST)
I get an ERROR message when using this Element # 5079, anyone know the reason why? Has that # been changed?
I try using RCHGetTableCell(), but that takes a longer time to load the values.
- 3b.
-
Re: RCHGetElementNumber 5079
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Tue Nov 8, 2011 7:16 am (PST)
You probably just need the new element definitions from the "Works in
Progress" folder. I have this in the change log:
2011-01-31 RCHGetElementNumber Updated definitions of element #5079 and
#5086 for Yahoo mutual funds to reflect their change on the web page of
"Total Expense Ratio" to be the new "Annual Report Expense Ratio".
RCHGetTableCell() shouldn't take longer. All RCHGetElementNumber () does is
an RCHGetTableCell() extraction. It's just that the parameters have been
saved and assigned to an element number.
On Tue, Nov 8, 2011 at 7:17 AM, lexstar <lexstar@yahoo.com > wrote:
> I get an ERROR message when using this Element # 5079, anyone know the
> reason why? Has that # been changed?
>
> I try using RCHGetTableCell(), but that takes a longer time to load the
> values.
>
- 4a.
-
Re: DJIA quotes from Yahoo (^DJI and INDU both failing)
Posted by: "spamfiel" dave@fiel.us spamfiel
Tue Nov 8, 2011 10:14 am (PST)
The DIA is fine, since I'm just using it to get a general market high/low, up/down comparison. Thanks, Randy!
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