Selasa, 19 Juli 2011

[smf_addin] Digest Number 1891

Messages In This Digest (16 Messages)

Messages

1a.

Re: RCHGetYahooQuotes erratic behavior beginning Fri, 7/15/11

Posted by: "smortonm" smmarder@yahoo.com   smortonm

Mon Jul 18, 2011 5:23 am (PDT)



Thanks. What I have dome is switched to retrieving quotes from MSN Money. This works except for many ETF quotes. Like DEM,CVY. SPY. MDY and such. This seems strange?

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> It might help to do an array-entered formula for all of the data instead of
> doing individual functions. Yahoo may be doing something on their side if
> there are too many requests within a short time frame? A few people in the
> past with problems have found this solved the problems, in addition to
> making the worksheet run much faster.
>
> Also check out item 9.4.2 in the "Links" area of the group.
>
> On Sun, Jul 17, 2011 at 8:39 AM, smortonm <smmarder@...> wrote:
>
> > I am having the same problem which continues to today. When I cut and paste
> > the =RCHGetYahooQuotes function into the problem cell, it corrects. But many
> > cell are having the problem. I am sure many others are experiencing this
> > issue.
> > Sid
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (15)
1b.

Re: RCHGetYahooQuotes erratic behavior beginning Fri, 7/15/11

Posted by: "drahmir" missouri24@mail.com   drahmir

Mon Jul 18, 2011 9:49 am (PDT)



How would one change their code from individual formulas to an array entered formula?

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (15)
1c.

Re: RCHGetYahooQuotes erratic behavior beginning Fri, 7/15/11

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Mon Jul 18, 2011 9:51 am (PDT)



Probably because you're using element #25? That's data from a stock page, so
it shouldn't work for other items.

On Mon, Jul 18, 2011 at 5:17 AM, smortonm <smmarder@yahoo.com> wrote:

> Thanks. What I have dome is switched to retrieving quotes from MSN Money.
> This works except for many ETF quotes. Like DEM,CVY. SPY. MDY and such. This
> seems strange?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (15)
1d.

Re: RCHGetYahooQuotes erratic behavior beginning Fri, 7/15/11

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Mon Jul 18, 2011 9:52 am (PDT)



Check the documentation and the examples...

But you may need to rearrange the worksheet, depending on how you're doing
things. However, returning all data with the one array-entered function will
be MUCH faster.

On Mon, Jul 18, 2011 at 9:45 AM, drahmir <missouri24@mail.com> wrote:

> How would one change their code from individual formulas to an array
> entered formula?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (15)
1e.

Re: RCHGetYahooQuotes erratic behavior beginning Fri, 7/15/11

Posted by: "bizmark_ee" markpadden@hotmail.com   bizmark_ee

Mon Jul 18, 2011 11:27 am (PDT)



Same exact problem here. It exists whether you use single cell or array formulas. Last price ("l1") will alternately appear as the correct last price, or some huge number > 500m. Refreshing the data can temporarily correct or bring on the problem, seemingly at random. Some tickers will work and other won't (different tickers will/won't) upon each refresh. Brand new issue, as I have not seen this in two years of using RCHGetYahooQuotes.

Thanks for looking into this.

--- In smf_addin@yahoogroups.com, "davedc78" <davedc78@...> wrote:
>
> I have been successfully using formulas like the following to get quotes for mutual funds into a cell in an Excel spreadsheet:
>
> =RCHGetYahooQuotes($B27,"l1",,NOW())
>
> In the above, the cell B27 contains the 5-char ticker for a mutual fund or a 3-char ticker for an exchange-traded fund. This has been working for about the past six months.
>
> Last Friday, some cell formulas started returning numbers that look like the following:
>
> 503240576.00
> 503256192.00
> 503105216.00
>
> If I press F9 to update, some of the "problem" cells will show the correct quote, but other cells that were showing correct quotes, will now show these strange numbers. No matter how many times I press F9, the problem cells just move around.
>
> I have made no changes to the spreadsheet. One possible issue: since the beginning (six months ago), I have been using Excel 2010 on a Windows 7 (64-bit) platform. But again the trouble only started last Friday.
>
> Any clues as to what might be going on here? Has something changed at Yahoo that means I am going to have to abandon smf_addin??
>
> Any suggestions will be welcome.
>
> Dave Simonds
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (15)
1f.

Re: RCHGetYahooQuotes erratic behavior beginning Fri, 7/15/11

Posted by: "bizmark_ee" markpadden@hotmail.com   bizmark_ee

Mon Jul 18, 2011 11:37 am (PDT)



BTW, I am looking at US stocks, such as HAL, STLD, MAT.

--- In smf_addin@yahoogroups.com, "bizmark_ee" <markpadden@...> wrote:
>
> Same exact problem here. It exists whether you use single cell or array formulas. Last price ("l1") will alternately appear as the correct last price, or some huge number > 500m. Refreshing the data can temporarily correct or bring on the problem, seemingly at random. Some tickers will work and other won't (different tickers will/won't) upon each refresh. Brand new issue, as I have not seen this in two years of using RCHGetYahooQuotes.
>
> Thanks for looking into this.
>
>
> --- In smf_addin@yahoogroups.com, "davedc78" <davedc78@> wrote:
> >
> > I have been successfully using formulas like the following to get quotes for mutual funds into a cell in an Excel spreadsheet:
> >
> > =RCHGetYahooQuotes($B27,"l1",,NOW())
> >
> > In the above, the cell B27 contains the 5-char ticker for a mutual fund or a 3-char ticker for an exchange-traded fund. This has been working for about the past six months.
> >
> > Last Friday, some cell formulas started returning numbers that look like the following:
> >
> > 503240576.00
> > 503256192.00
> > 503105216.00
> >
> > If I press F9 to update, some of the "problem" cells will show the correct quote, but other cells that were showing correct quotes, will now show these strange numbers. No matter how many times I press F9, the problem cells just move around.
> >
> > I have made no changes to the spreadsheet. One possible issue: since the beginning (six months ago), I have been using Excel 2010 on a Windows 7 (64-bit) platform. But again the trouble only started last Friday.
> >
> > Any clues as to what might be going on here? Has something changed at Yahoo that means I am going to have to abandon smf_addin??
> >
> > Any suggestions will be welcome.
> >
> > Dave Simonds
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (15)
1g.

Re: RCHGetYahooQuotes erratic behavior beginning Fri, 7/15/11

Posted by: "flangeneral" jefff@rogers.com   flangeneral

Mon Jul 18, 2011 12:04 pm (PDT)



I agree with you Randy, returning all data with the one array-entered function is MUCH faster. However, I did need to re-arrange my worksheet to accomodate the array-entered function, and in doing so, I lose the ability to sort my stocks.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Check the documentation and the examples...
>
> But you may need to rearrange the worksheet, depending on how you're doing
> things. However, returning all data with the one array-entered function will
> be MUCH faster.
>
> On Mon, Jul 18, 2011 at 9:45 AM, drahmir <missouri24@...> wrote:
>
> > How would one change their code from individual formulas to an array
> > entered formula?
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (15)
1h.

Re: RCHGetYahooQuotes erratic behavior beginning Fri, 7/15/11

Posted by: "Ron" ronaldj309@cox.net   ronaldj309

Mon Jul 18, 2011 12:31 pm (PDT)



Copy and paste values and formats then sort.

--- In smf_addin@yahoogroups.com, "flangeneral" <jefff@...> wrote:
>
> I agree with you Randy, returning all data with the one array-entered function is MUCH faster. However, I did need to re-arrange my worksheet to accomodate the array-entered function, and in doing so, I lose the ability to sort my stocks.
>
> --- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@> wrote:
> >
> > Check the documentation and the examples...
> >
> > But you may need to rearrange the worksheet, depending on how you're doing
> > things. However, returning all data with the one array-entered function will
> > be MUCH faster.
> >
> > On Mon, Jul 18, 2011 at 9:45 AM, drahmir <missouri24@> wrote:
> >
> > > How would one change their code from individual formulas to an array
> > > entered formula?
> > >
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (15)
1i.

Re: RCHGetYahooQuotes erratic behavior beginning Fri, 7/15/11

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Mon Jul 18, 2011 12:33 pm (PDT)



Not if you create a sort field outside of the array-entered range. It can be
a simple referral such as:

=F6

As long as the ticker symbols sort with your sort field, everything will
recalculate in the correct spot.

On Mon, Jul 18, 2011 at 11:54 AM, flangeneral <jefff@rogers.com> wrote:

> I agree with you Randy, returning all data with the one array-entered
> function is MUCH faster. However, I did need to re-arrange my worksheet to
> accomodate the array-entered function, and in doing so, I lose the ability
> to sort my stocks.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (15)
1j.

Re: RCHGetYahooQuotes erratic behavior beginning Fri, 7/15/11

Posted by: "flangeneral" jefff@rogers.com   flangeneral

Mon Jul 18, 2011 1:21 pm (PDT)



Thanks Randy, it worked.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Not if you create a sort field outside of the array-entered range. It can be
> a simple referral such as:
>
> =F6
>
> As long as the ticker symbols sort with your sort field, everything will
> recalculate in the correct spot.
>
> On Mon, Jul 18, 2011 at 11:54 AM, flangeneral <jefff@...> wrote:
>
> > I agree with you Randy, returning all data with the one array-entered
> > function is MUCH faster. However, I did need to re-arrange my worksheet to
> > accomodate the array-entered function, and in doing so, I lose the ability
> > to sort my stocks.
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (15)
2a.

=RCHGetYahooQuotes($B2,"l1",,"now()")

Posted by: "lezm001" lezm001@yahoo.com   lezm001

Mon Jul 18, 2011 7:58 am (PDT)



I've been using this function for a long time to pull in mutual fund prices for different mutual fund tickers. It just starting pulling in a very large number for some of the tickers. It is pulling in the value $503,240,576.00 for some of the tickers. As an exmaple, the ticker CAIBX is pulling in the price of $51.07 for some line items and the same ticker CAIBX is pulling in $503,240,576.00 in other areas of the spreadsheet. Any idea what may have changed? The formulas are the same in the file that I have been using for a very long time.

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)
2b.

Re: =RCHGetYahooQuotes($B2,"l1",,"now()")

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Mon Jul 18, 2011 9:47 am (PDT)



I suspect the problem is with Yahoo...

However, I would suggest you use one large array-entered RCHGetYahooQuotes()
function instead of individual functions. Why burden Yahoo with so many
individual data requests when you get give them just one? And I suspect
issues arise if there are too many for EXCEL and Yahoo to manage within a
short time period.

On Mon, Jul 18, 2011 at 7:36 AM, lezm001 <lezm001@yahoo.com> wrote:

> I've been using this function for a long time to pull in mutual fund prices
> for different mutual fund tickers. It just starting pulling in a very large
> number for some of the tickers. It is pulling in the value $503,240,576.00
> for some of the tickers. As an exmaple, the ticker CAIBX is pulling in the
> price of $51.07 for some line items and the same ticker CAIBX is pulling in
> $503,240,576.00 in other areas of the spreadsheet. Any idea what may have
> changed? The formulas are the same in the file that I have been using for a
> very long time.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)
2c.

Re: =RCHGetYahooQuotes($B2,"l1",,"now()")

Posted by: "Ron" ronaldj309@cox.net   ronaldj309

Mon Jul 18, 2011 10:07 am (PDT)



Having the same problem with PSM from DTlink which uses YAHOO as the data source. So, I think YAHOO is the problem.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> I suspect the problem is with Yahoo...
>
> However, I would suggest you use one large array-entered RCHGetYahooQuotes()
> function instead of individual functions. Why burden Yahoo with so many
> individual data requests when you get give them just one? And I suspect
> issues arise if there are too many for EXCEL and Yahoo to manage within a
> short time period.
>
> On Mon, Jul 18, 2011 at 7:36 AM, lezm001 <lezm001@...> wrote:
>
> > I've been using this function for a long time to pull in mutual fund prices
> > for different mutual fund tickers. It just starting pulling in a very large
> > number for some of the tickers. It is pulling in the value $503,240,576.00
> > for some of the tickers. As an exmaple, the ticker CAIBX is pulling in the
> > price of $51.07 for some line items and the same ticker CAIBX is pulling in
> > $503,240,576.00 in other areas of the spreadsheet. Any idea what may have
> > changed? The formulas are the same in the file that I have been using for a
> > very long time.
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)
3a.

Re: I am looking for Free Intraday Data

Posted by: "paul messerschmidt" financepaul@gmail.com   fuelspotpaul

Mon Jul 18, 2011 11:49 am (PDT)



here is a link to free futures data (ES used as example)

http://www.commoditycharts.com/commodityprices/search/es

<http://www.commoditycharts.com/commodityprices/search/es>data is delayed,
however.

and link for all markets

http://www.commoditycharts.com/commodities/All%20Markets/

<http://www.commoditycharts.com/commodities/All%20Markets/>good trading...

On Mon, Jul 18, 2011 at 6:00 AM, sina_ramezani2002 <
sina_ramezani2002@yahoo.com> wrote:

> **
>
>
> Hi everybody, I am new in this world. Please let me know if there is
> anywhere that I can get free intraday data. Specially for Indices futures.
> Thanks
>
>
>

--
-----------------------------------------
Paul Messerschmidt
paul.messerschmidt (skype)
+1-813-334-8682 (mobile)
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
4a.

Array entered formula

Posted by: "kkkutty" kkkutty@yahoo.com   kkkutty

Mon Jul 18, 2011 1:41 pm (PDT)



Hi Randy,

I've tried to get the information from the following Edgars site using an array-entered formula, but have not been successful:

http://www.sec.gov/cgi-bin/current.pl?q1=2&q2=0&q3=

Can you point me in the right direction as to which formula would be best suited to extract the info from the above website and also whether or not that formula can be array-entered. Thank you very much.

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
4b.

Re: Array entered formula

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Mon Jul 18, 2011 3:43 pm (PDT)



You would need to manually extract the data yourself, since they have ALL of
the data in a single table cell. For example:

=smfGetTagContent("http://www.sec.gov/cgi-bin/current.pl?q1=2&q2=0&q3=
","td",2)

On Mon, Jul 18, 2011 at 1:41 PM, kkkutty <kkkutty@yahoo.com> wrote:

>
> I've tried to get the information from the following Edgars site using an
> array-entered formula, but have not been successful:
>
> http://www.sec.gov/cgi-bin/current.pl?q1=2&q2=0&q3=
>
> Can you point me in the right direction as to which formula would be best
> suited to extract the info from the above website and also whether or not
> that formula can be array-entered. Thank you very much.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
Recent Activity
Visit Your Group
Ads on Yahoo!

Learn more now.

Reach customers

searching for you.

Yahoo! Finance

It's Now Personal

Guides, news,

advice & more.

Yahoo! News

Odd News

You won't believe

it, but it's true

Need to Reply?

Click one of the "Reply" links to respond to a specific message in the Daily Digest.

Create New Topic | Visit Your Group on the Web
Diposting oleh EXCEL FEED LEARNING di 04.03

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)