Messages In This Digest (7 Messages)
- 1a.
- Re: smfGetOptionQuotes give wrong numbers for ADBE From: Glen Fullmer
- 2a.
- Re: RCHGetYahooQuotes erratic behavior beginning Fri, 7/15/11 From: smortonm
- 2b.
- Re: RCHGetYahooQuotes erratic behavior beginning Fri, 7/15/11 From: Randy Harmelink
- 2c.
- Re: RCHGetYahooQuotes erratic behavior beginning Fri, 7/15/11 From: Tom Steadman
- 3a.
- How to get weekly and monthly Yahoo historical data? From: cocoaacc
- 3b.
- Re: How to get weekly and monthly Yahoo historical data? From: Randy Harmelink
- 4.
- I am looking for Free Intraday Data From: sina_ramezani2002
Messages
- 1a.
-
Re: smfGetOptionQuotes give wrong numbers for ADBE
Posted by: "Glen Fullmer" gfullmer@cox.net gfullmer
Sun Jul 17, 2011 5:34 am (PDT)
Hi Randy,
On Sat, 2011-07-16 at 10:09 -0700, Randy Harmelink wrote:
>
> Like I said, you need to go to the item in the "Links" area of the
> group to find out more about smfForceRecalculation.
Did so and even set up a macro button as documented for Excel 2007 in
the tool bar. Works flawlessly. Thanks again.
Glen
- 2a.
-
Re: RCHGetYahooQuotes erratic behavior beginning Fri, 7/15/11
Posted by: "smortonm" smmarder@yahoo.com smortonm
Sun Jul 17, 2011 8:44 am (PDT)
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
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> My guess would be something was going on with the Yahoo servers...
>
> On Sat, Jul 16, 2011 at 11:31 AM, 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.
> >
>
- 2b.
-
Re: RCHGetYahooQuotes erratic behavior beginning Fri, 7/15/11
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sun Jul 17, 2011 1:41 pm (PDT)
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@yahoo.com > 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
>
- 2c.
-
Re: RCHGetYahooQuotes erratic behavior beginning Fri, 7/15/11
Posted by: "Tom Steadman" tomsteadman@muskoka.com tom.steadman
Sun Jul 17, 2011 1:55 pm (PDT)
I too am experiencing unusual behaviour. Yahoo intermittently fails to
deliver the complete equity name-providing truncations. For example, for
ABX.TO, I get things retrieved like "arrick" and "rrick". Suggestions?
T.A. (Tom) Steadman
115 Maple Heights Drive
Gravenhurst, Ontario, Canada
P1P1R1
Phone: 705-687-3057
Skype-Tom.Steadman2
- 3a.
-
How to get weekly and monthly Yahoo historical data?
Posted by: "cocoaacc" cocoaacc@yahoo.com.hk cocoaacc
Mon Jul 18, 2011 2:00 am (PDT)
Hi Sir/Madam,
I don't know how to get the weekly and monthly Yahoo historical data.
I only know how to get the daily Yahoo historical data using the below function:
=RCHGetYahooHistory(IBM)
Many Thanks!
Will
- 3b.
-
Re: How to get weekly and monthly Yahoo historical data?
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Mon Jul 18, 2011 2:12 am (PDT)
Check out the documentation of the function. One of the parameters tells
Yahoo whether you want daily, weekly, or monthly data.
On Mon, Jul 18, 2011 at 2:00 AM, cocoaacc <cocoaacc@yahoo.com.hk > wrote:
>
> I don't know how to get the weekly and monthly Yahoo historical data.
>
> I only know how to get the daily Yahoo historical data using the below
> function:
>
> =RCHGetYahooHistory(IBM)
>
- 4.
-
I am looking for Free Intraday Data
Posted by: "sina_ramezani2002" sina_ramezani2002@yahoo.com sina_ramezani2002
Mon Jul 18, 2011 3:12 am (PDT)
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
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