Messages In This Digest (9 Messages)
- 1a.
- Re: RCHGet From: Randy Harmelink
- 1b.
- Re: RCHGet From: P Palminha
- 1c.
- Re: RCHGet From: Randy Harmelink
- 2a.
- Re: No update from Yahoo From: wu_ming_sg
- 2b.
- Re: No update from Yahoo From: Randy Harmelink
- 2c.
- Re: No update from Yahoo From: a.atkinson92
- 2d.
- Re: No update from Yahoo From: Randy Harmelink
- 3a.
- ^VIX data From: grandparalphy
- 3b.
- Re: ^VIX data From: Randy Harmelink
Messages
- 1a.
-
Re: RCHGet
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Mon Nov 7, 2011 2:22 pm (PST)
You'll probably need to write your own RCHGetTableCell() or
smfGetTagContent() functions to get data from a different data source.
On Mon, Nov 7, 2011 at 3:04 PM, Paulo <palminha@yahoo.com > wrote:
> I am using the formulas RCHGet with great utility and satisfaction. They
> work perfectly for companies in the U.S. market, but for the European
> market I can not obtain all elements on yahoo. I'd like if samone help me
> find alternatives using the same formulas.
>
- 1b.
-
Re: RCHGet
Posted by: "P Palminha" palminha@yahoo.com palminha
Mon Nov 7, 2011 4:44 pm (PST)
OK, is there any samples or people working with them on Reuters that you know off?
_____________________ _________ __
From: Randy Harmelink <rharmelink@gmail.com >
To: smf_addin@yahoogroups.com
Sent: Monday, November 7, 2011 10:22 PM
Subject: Re: [smf_addin] RCHGet
You'll probably need to write your own RCHGetTableCell() or smfGetTagContent( ) functions to get data from a different data source.
On Mon, Nov 7, 2011 at 3:04 PM, Paulo <palminha@yahoo.com > wrote:
I am using the formulas RCHGet with great utility and satisfaction. They work perfectly for companies in the U.S. market, but for the European market I can not obtain all elements on yahoo. I'd like if samone help me find alternatives using the same formulas.
>
- 1c.
-
Re: RCHGet
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Mon Nov 7, 2011 5:20 pm (PST)
There is a Reuters RCHGetTableCell() example in the files area...
On Mon, Nov 7, 2011 at 5:35 PM, P Palminha <palminha@yahoo.com > wrote:
>
> OK, is there any samples or people working with them on Reuters that you
> know off?
>
- 2a.
-
Re: No update from Yahoo
Posted by: "wu_ming_sg" nghongchong@hotmail.com wu_ming_sg
Mon Nov 7, 2011 5:38 pm (PST)
Hi,
Is there a separate documentation on the "refresh " parameter?
thanks.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Read the documentation please -- look at the refresh parameter.
>
> On Mon, Nov 7, 2011 at 2:05 PM, SANCHO <sancho_best@...> wrote:
>
> > How to make the fuction volatile?
> >
>
- 2b.
-
Re: No update from Yahoo
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Mon Nov 7, 2011 5:41 pm (PST)
No. It's a parameter of the RCHGetYahooQuotes() function that I'm talking
about.
On Mon, Nov 7, 2011 at 6:38 PM, wu_ming_sg <nghongchong@hotmail.com > wrote:
>
> Is there a separate documentation on the "refresh " parameter?
>
- 2c.
-
Re: No update from Yahoo
Posted by: "a.atkinson92" a.atkinson92@yahoo.com a.atkinson92
Tue Nov 8, 2011 1:58 am (PST)
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> How are you doing your updating? What parameters are you using for the
> function? Have you set your Internet Options so that new content is
> retrieved every time a web page is visited (see "Links" area of group for
> more info -- item 9.4.2)?
>
> On Mon, Nov 7, 2011 at 10:41 AM, SANCHO <sancho_best@...> wrote:
>
> >
> > I tried to update tickers from yahoo. Nothing is happening. Quotes are
> > still old from friday 4th. on friday it worked fine. I reinstalled the
> > add-in and it doesn't help.
> >
> > Does anybody have the same issue right now?
> > Is it yahoo's problem?
> >
>
I have a similar problem,since 4/11/11 with ^FTSE, ^HSI,^N225,^GDAXI and ^FCHI not updating ^GSPC did update 7/11/11 all other quotes appear to work.
- 2d.
-
Re: No update from Yahoo
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Tue Nov 8, 2011 2:22 am (PST)
It wasn't until someone FINALLY gave me a sample ticker symbol that I was
able to verify that it is a Yahoo problem...
On Tue, Nov 8, 2011 at 2:50 AM, a.atkinson92 <a.atkinson92@yahoo.com > wrote:
> I have a similar problem,since 4/11/11 with ^FTSE, ^HSI,^N225,^GDAXI and
> ^FCHI not updating ^GSPC did update 7/11/11 all other quotes appear to work.
>
- 3a.
-
^VIX data
Posted by: "grandparalphy" grandparalph@comcast.net grandparalphy
Mon Nov 7, 2011 7:55 pm (PST)
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
- 3b.
-
Re: ^VIX data
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Mon Nov 7, 2011 8:01 pm (PST)
Someone else has been complaining about Yahoo as well, saying the indexes
aren't updating properly.
I just tried the process directly from Yahoo for ^VIX without the add-in
and also got data from last Friday (the same data you cite below), so it
definitely is a Yahoo problem.
I assume your web queries probably use the tabular data from the web page?
That's not the same source as the CSV data from Yahoo. Two different feeds.
But you can use that as a workaround if necessary, using RCHGetTableCell()
would probably be more convenient that using web queries. However, slower
than using RCHGetYahooQuotes() with Yahoo's CSV current quotes interface.
And, we did have a situation a few months ago where some data was
sporadically getting current data and outdated data -- I suspect that at
the time they had one server that wasn't getting updates properly.
On Mon, Nov 7, 2011 at 8:35 PM, grandparalphy <grandparalph@comcast.net >wrote:
>
> 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.
>
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