Messages In This Digest (9 Messages)
- 1a.
- smfPricesByDates showing $505,480,256 for today's price From: chaim422
- 1b.
- Re: smfPricesByDates showing $505,480,256 for today's price From: Randy Harmelink
- 1c.
- Re: smfPricesByDates showing $505,480,256 for today's price From: chaim422
- 2a.
- Latest stock headline From: chaim422
- 2b.
- Re: Latest stock headline From: Randy Harmelink
- 3a.
- Re: RCHGetYahooQuotes erratic behavior beginning Fri, 7/15/11 From: Bobby
- 3b.
- Re: RCHGetYahooQuotes erratic behavior beginning Fri, 7/15/11 From: bizmark_ee
- 3c.
- Re: RCHGetYahooQuotes erratic behavior beginning Fri, 7/15/11 From: Phil
- 4a.
- Re: Can I download financial data that are listed in Pakistan From: Randy Harmelink
Messages
- 1a.
-
smfPricesByDates showing $505,480,256 for today's price
Posted by: "chaim422" chaim422@gmail.com chaim422
Tue Jul 19, 2011 3:26 pm (PDT)
I have a spreadsheet to track the total return of the stocks in my portfolio using smfPricesByDates. Some stocks show the right price but some stocks show $505,480,256 as today's price.
I'm using a separate array of two columns for each stock. For example: smfPricesByDates("BAC, 6/1/11, today()). When I change the date to today()-1 it works fine. Any ideas?
- 1b.
-
Re: smfPricesByDates showing $505,480,256 for today's price
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Tue Jul 19, 2011 3:34 pm (PDT)
When you use today's date, the function uses the RCHGetYahooQuotes()
function to retrieve the current quote -- because historical quotes only
goes through the prior day.
If you look at recent message threads in the group archives, you'll notice
Yahoo current quotes has been flaky and occasionally returning erroneous
prices recently. I suspect one of their servers has a corrupted database or
something.
On Tue, Jul 19, 2011 at 2:47 PM, chaim422 <chaim422@gmail.com > wrote:
> I have a spreadsheet to track the total return of the stocks in my
> portfolio using smfPricesByDates. Some stocks show the right price but some
> stocks show $505,480,256 as today's price.
>
> I'm using a separate array of two columns for each stock. For example:
> smfPricesByDates("BAC, 6/1/11, today()). When I change the date to today()-1
> it works fine. Any ideas?
>
- 1c.
-
Re: smfPricesByDates showing $505,480,256 for today's price
Posted by: "chaim422" chaim422@gmail.com chaim422
Tue Jul 19, 2011 3:57 pm (PDT)
Thanks Randy!
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> When you use today's date, the function uses the RCHGetYahooQuotes()
> function to retrieve the current quote -- because historical quotes only
> goes through the prior day.
>
> If you look at recent message threads in the group archives, you'll notice
> Yahoo current quotes has been flaky and occasionally returning erroneous
> prices recently. I suspect one of their servers has a corrupted database or
> something.
>
> On Tue, Jul 19, 2011 at 2:47 PM, chaim422 <chaim422@...> wrote:
>
> > I have a spreadsheet to track the total return of the stocks in my
> > portfolio using smfPricesByDates. Some stocks show the right price but some
> > stocks show $505,480,256 as today's price.
> >
> > I'm using a separate array of two columns for each stock. For example:
> > smfPricesByDates("BAC, 6/1/11, today()). When I change the date to today()-1
> > it works fine. Any ideas?
> >
>
- 2a.
-
Latest stock headline
Posted by: "chaim422" chaim422@gmail.com chaim422
Tue Jul 19, 2011 5:36 pm (PDT)
Randy,
I've been trying to import the latest headline from either Yahoo Finance
or ADVFN
(http://www.advfn.com/company- ) using RCHGetTableCell(news-TSE/ Bioexx-Specialty -Proteins- BXI.htm\
l) but came up empty. Is there a way?
Thanks
- 2b.
-
Re: Latest stock headline
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Tue Jul 19, 2011 6:59 pm (PDT)
The table cell came up as empty because the entire table cell is a link tag
-- and the add-in removes all HTML tag data in the table cell before
returning the remaining data in the cell. Instead, try something like:
=smfGetTagContent("
http://www.advfn.com/company- news-TSE/ Bioexx-Specialty -Proteins- BXI.html
","a",1,">Source")
On Tue, Jul 19, 2011 at 5:35 PM, chaim422 <chaim422@gmail.com > wrote:
>
> I've been trying to import the latest headline from either Yahoo Finance
> or ADVFN
> (http://www.advfn.com/company- > l) using RCHGetTableCell(news-TSE/ Bioexx-Specialty -Proteins- BXI.htm\
) but came up empty. Is there a way?
>
- 3a.
-
Re: RCHGetYahooQuotes erratic behavior beginning Fri, 7/15/11
Posted by: "Bobby" audiorush00@yahoo.com audiorush00
Tue Jul 19, 2011 9:26 pm (PDT)
Getting the same issue
--- 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
>
- 3b.
-
Re: RCHGetYahooQuotes erratic behavior beginning Fri, 7/15/11
Posted by: "bizmark_ee" markpadden@hotmail.com bizmark_ee
Wed Jul 20, 2011 3:50 am (PDT)
Does using an array formula help anyone currently with this problem? It does not for me. I get it with both array and single-cell formulas, and with both large sheets and tiny (one request) sheets. So there appears to be a genuine problem in the way the add-in is receiving data from Yahoo.
--- 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
> >
>
- 3c.
-
Re: RCHGetYahooQuotes erratic behavior beginning Fri, 7/15/11
Posted by: "Phil" philgiz@zoominternet.net philgiz_2000
Wed Jul 20, 2011 3:57 am (PDT)
Using an array did not help. I had to convert all formulas to the '=rchgettablecell' function. This seems to work fine for my work.
Hope this helps.
Phil
From: bizmark_ee
Sent: Wednesday, July 20, 2011 6:50 AM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Re: RCHGetYahooQuotes erratic behavior beginning Fri, 7/15/11
Does using an array formula help anyone currently with this problem? It does not for me. I get it with both array and single-cell formulas, and with both large sheets and tiny (one request) sheets. So there appears to be a genuine problem in the way the add-in is receiving data from Yahoo.
--- In mailto:smf_addin%40yahoogroups. 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
> >
>
- 4a.
-
Re: Can I download financial data that are listed in Pakistan
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Wed Jul 20, 2011 1:39 am (PDT)
I get no response from that URL. Hopefully, you can use the
RCHGetTableCell() function. Next choice would be the smfGetTagContent( )
function.
On Thu, Jul 14, 2011 at 8:25 AM, Amir Rehman <amir.rehman@yahoo.com > wrote:
>
> Thanks for your response. Can you explain me little bit. I am trying to
> download data from kse.com.pk
>
>
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