Messages In This Digest (21 Messages)
- 1a.
- Fax Business website From: Steven
- 1b.
- Re: Fax Business website From: Randy Harmelink
- 1c.
- Re: Fax Business website From: Steven
- 1d.
- Re: Fax Business website From: dguillett1
- 2a.
- FX Rates From: bushpilote
- 2b.
- Re: FX Rates From: Randy Harmelink
- 3a.
- All my Yahoo quotes stopped working as of June 3rd. From: dbltapp00
- 3b.
- Re: All my Yahoo quotes stopped working as of June 3rd. From: Randy Harmelink
- 3c.
- Re: All my Yahoo quotes stopped working as of June 3rd. From: dbltapp00
- 3d.
- Re: All my Yahoo quotes stopped working as of June 3rd. From: Randy Harmelink
- 3e.
- Re: All my Yahoo quotes stopped working as of June 3rd. From: dbltapp00
- 3f.
- Re: All my Yahoo quotes stopped working as of June 3rd. From: dbltapp00
- 4.1.
- Re: RCHGetYahooQuotes() From: investor952
- 4.2.
- Re: RCHGetYahooQuotes() From: Randy Harmelink
- 4.3.
- Re: RCHGetYahooQuotes() From: investor952
- 4.4.
- Re: RCHGetYahooQuotes() From: Randy Harmelink
- 5a.
- time warp? From: sihlai
- 5b.
- Re: time warp? From: Randy Harmelink
- 6.
- quicktake morningstar From: alexander
- 7a.
- Incorrect Ex-Dividend Date extraction From: PhillipG
- 7b.
- Re: Incorrect Ex-Dividend Date extraction From: Randy Harmelink
Messages
- 1a.
-
Fax Business website
Posted by: "Steven" stevenletzer@yahoo.com stevenletzer
Mon Jun 6, 2011 7:34 am (PDT)
Has anyone worked on the Fox Business website? For example: http://quote.foxbusiness. For a simple GetTableCell on the financials tab, I tried several variations of this formula, and only received "Error"com/symbol/ ge/financials.
RCHGetTableCell("http://quote. foxbusiness. ",1,"Income Statement","com/symbol/ ge/financials Annual"," Sales")
The website is free, and the data layout is very clear.
Any ideas?
- 1b.
-
Re: Fax Business website
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Mon Jun 6, 2011 8:04 am (PDT)
The problem is that the financial statement is presented in a frame, so it's
not actually at that URL. Try this URL instead:
http://idms.foxbusiness. com/v2/stocks/ income_statement .idms?SYMBOL_ US=GE
On Mon, Jun 6, 2011 at 7:33 AM, Steven <stevenletzer@yahoo.com > wrote:
> Has anyone worked on the Fox Business website? For example:
> http://quote.foxbusiness. For a simplecom/symbol/ ge/financials.
> GetTableCell on the financials tab, I tried several variations of this
> formula, and only received "Error"
>
> RCHGetTableCell("http://quote. foxbusiness. ",1,"Incomecom/symbol/ ge/financials
> Statement","Annual"," Sales")
>
> The website is free, and the data layout is very clear.
>
> Any ideas?
>
- 1c.
-
Re: Fax Business website
Posted by: "Steven" stevenletzer@yahoo.com stevenletzer
Mon Jun 6, 2011 8:05 am (PDT)
Thanks
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> The problem is that the financial statement is presented in a frame, so it's
> not actually at that URL. Try this URL instead:
>
> http://idms.foxbusiness. com/v2/stocks/ income_statement .idms?SYMBOL_ US=GE
>
> On Mon, Jun 6, 2011 at 7:33 AM, Steven <stevenletzer@...> wrote:
>
> > Has anyone worked on the Fox Business website? For example:
> > http://quote.foxbusiness. For a simplecom/symbol/ ge/financials.
> > GetTableCell on the financials tab, I tried several variations of this
> > formula, and only received "Error"
> >
> > RCHGetTableCell("http://quote. foxbusiness. ",1,"Incomecom/symbol/ ge/financials
> > Statement","Annual"," Sales")
> >
> > The website is free, and the data layout is very clear.
> >
> > Any ideas?
> >
>
- 1d.
-
Re: Fax Business website
Posted by: "dguillett1" dguillett1@gmail.com donaldb36
Mon Jun 6, 2011 8:10 am (PDT)
Maybe?
http://idms.foxbusiness. com/v2/stocks/ income_statement .idms?SYMBOL_ US=GE
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1@gmail.com
From: Steven
Sent: Monday, June 06, 2011 9:33 AM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Fax Business website
Has anyone worked on the Fox Business website? For example: http://quote.foxbusiness. For a simple GetTableCell on the financials tab, I tried several variations of this formula, and only received "Error"com/symbol/ ge/financials.
RCHGetTableCell("http://quote. foxbusiness. ",1,"Income Statement","com/symbol/ ge/financials Annual"," Sales")
The website is free, and the data layout is very clear.
Any ideas?
- 2a.
-
FX Rates
Posted by: "bushpilote" bushpilote@yahoo.ca bushpilote
Mon Jun 6, 2011 7:50 am (PDT)
Good morning Randy,
I'm been unable to retrieve FX rates for specific dates (not a range)from http://fx.sauder. ubc.ca/data using the following formula:
RCHGetHTMLTable("http://fx.sauder. ubc.ca/cgi/ ","Wdy",-1,"fxdata?b= USD&c=EUR& rd=&fd=3& fm=6&fy=2011& ld=3&lm=6& ly=2011&y= daily&q=p& f=HTML ",1).
I've read all of the previous comments posted on your site on how to go about doing it and still can't get it to work.
What am I missing here?
- 2b.
-
Re: FX Rates
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Mon Jun 6, 2011 8:07 am (PDT)
That works fine for me...
On Mon, Jun 6, 2011 at 7:50 AM, bushpilote <bushpilote@yahoo.ca > wrote:
>
> I'm been unable to retrieve FX rates for specific dates (not a range)from
> http://fx.sauder. ubc.ca/data using the following formula:
>
> RCHGetHTMLTable("
> http://fx.sauder.ubc.ca/cgi/ fxdata?b= USD&c=EUR& rd=&fd=3& fm=6&fy=2011& ld=3&lm=6& ly=2011&y= daily&q=p& f=HTML
> ","Wdy",-1,"",1).
>
> I've read all of the previous comments posted on your site on how to go
> about doing it and still can't get it to work.
>
> What am I missing here?
>
- 3a.
-
All my Yahoo quotes stopped working as of June 3rd.
Posted by: "dbltapp00" dbltapp00@yahoo.com dbltapp00
Mon Jun 6, 2011 11:50 am (PDT)
Did something happen?
- 3b.
-
Re: All my Yahoo quotes stopped working as of June 3rd.
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Mon Jun 6, 2011 12:00 pm (PDT)
Assuming you mean RCHGetYahooQuotes() -- I just tried it and it worked fine
here. Refreshing with smfForceRecalculation worked just fine as well.
You could have web pages being cached -- check your Internet Options and
make sure they are set up to get a fresh copy of a web page on every visit
to the page. Without more details, that's about all I can suggest.
On Mon, Jun 6, 2011 at 11:40 AM, dbltapp00 <dbltapp00@yahoo.com > wrote:
> Did something happen?
>
- 3c.
-
Re: All my Yahoo quotes stopped working as of June 3rd.
Posted by: "dbltapp00" dbltapp00@yahoo.com dbltapp00
Mon Jun 6, 2011 12:27 pm (PDT)
--- In smf_addin@yahoogroups.com , "dbltapp00" <dbltapp00@...> wrote:
>
> Did something happen?
>
Let me amend that - all my Yahoo Rydex and Fidelity mutual fund quotes stopped working as of June 3rd. This suggests it's not me, it's Yahoo... right?
- 3d.
-
Re: All my Yahoo quotes stopped working as of June 3rd.
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Mon Jun 6, 2011 12:38 pm (PDT)
I have no idea what ticker symbols might apply.
What I'd suggest is to go to the web page for one of them and click on the
"Download Data" link and see if that is the same as what the add-in is
returning. Again, assuming you are talking about the RCHGetYahooQuotes()
function.
On Mon, Jun 6, 2011 at 12:23 PM, dbltapp00 <dbltapp00@yahoo.com > wrote:
>
> Let me amend that - all my Yahoo Rydex and Fidelity mutual fund quotes
> stopped working as of June 3rd. This suggests it's not me, it's Yahoo...
> right?
>
- 3e.
-
Re: All my Yahoo quotes stopped working as of June 3rd.
Posted by: "dbltapp00" dbltapp00@yahoo.com dbltapp00
Mon Jun 6, 2011 12:59 pm (PDT)
Tried that - the values download, not the code.
The following get the closing date of a quote. The index and stock calls return the correct date, but the two funds return a date from last week.
In Excel, this works: =RCHGetYahooQuotes("^RUT","d1" ) for an index, and this works: =RCHGetYahooQuotes( "TXN","d1" ) for a stock, but this doesn't work correctly: =RCHGetYahooQuotes( "FSHCX"," d1") for a Fidelity fund and this doesn't work correctly: =RCHGetYahooQuotes( "RYTNX"," d1") for a Rydex fund.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> I have no idea what ticker symbols might apply.
>
> What I'd suggest is to go to the web page for one of them and click on the
> "Download Data" link and see if that is the same as what the add-in is
> returning. Again, assuming you are talking about the RCHGetYahooQuotes()
> function.
>
> On Mon, Jun 6, 2011 at 12:23 PM, dbltapp00 <dbltapp00@...> wrote:
>
> >
> > Let me amend that - all my Yahoo Rydex and Fidelity mutual fund quotes
> > stopped working as of June 3rd. This suggests it's not me, it's Yahoo...
> > right?
> >
>
- 3f.
-
Re: All my Yahoo quotes stopped working as of June 3rd.
Posted by: "dbltapp00" dbltapp00@yahoo.com dbltapp00
Mon Jun 6, 2011 1:10 pm (PDT)
Flash- Turns out it's the Yahoo site that's returning the wrong date and values for those two families of funds. All the fund quotes come back "Trade Time June 2".
Never mind...
--- In smf_addin@yahoogroups.com , "dbltapp00" <dbltapp00@...> wrote:
>
> Tried that - the values download, not the code.
>
> The following get the closing date of a quote. The index and stock calls return the correct date, but the two funds return a date from last week.
>
> In Excel, this works: =RCHGetYahooQuotes("^RUT","d1" ) for an index, and this works: =RCHGetYahooQuotes( "TXN","d1" ) for a stock, but this doesn't work correctly: =RCHGetYahooQuotes( "FSHCX"," d1") for a Fidelity fund and this doesn't work correctly: =RCHGetYahooQuotes( "RYTNX"," d1") for a Rydex fund.
>
> --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@> wrote:
> >
> > I have no idea what ticker symbols might apply.
> >
> > What I'd suggest is to go to the web page for one of them and click on the
> > "Download Data" link and see if that is the same as what the add-in is
> > returning. Again, assuming you are talking about the RCHGetYahooQuotes()
> > function.
> >
> > On Mon, Jun 6, 2011 at 12:23 PM, dbltapp00 <dbltapp00@> wrote:
> >
> > >
> > > Let me amend that - all my Yahoo Rydex and Fidelity mutual fund quotes
> > > stopped working as of June 3rd. This suggests it's not me, it's Yahoo...
> > > right?
> > >
> >
>
- 4.1.
-
Re: RCHGetYahooQuotes()
Posted by: "investor952" investor952@yahoo.com investor952
Mon Jun 6, 2011 12:36 pm (PDT)
Hello, I am a newbee at this..just found this fantastic tool on internet last night...
I just tried this..and the o and l (open and low price) show up as NA for all the tickers. Looks like Yahoo doesn't have this data?
I use an older version of Excel..2002 I think.
--- In smf_addin@yahoogroups.com , "Randy Harmelink" <rharmelink@...> wrote:
>
> Here's a little template for you. Typically, when I want some Yahoo
> quotes data, I'll start out like this:
>
> 1. Put ticker symbols in cells A2, A3, A4. (e.g. "IBM", "JNJ", and
> "MOT").
> 2. Put Yahoo codes in cells B1, C1, D1 (e.g. "o", "h", and "l1").
> 3. Highlight a range -- let's say B2 to M100.
> 4. Type (into B2): "=RCHGetYahooQuotes(A2:A100, B1:M1)"
> 5. Hit Ctrl-Shift-Enter (to array-enter the formula)
>
> After a second or so, I will see:
>
> A B C D E 1 o h l1 2 IBM 75.83 77.29 76.15 3 JNJ
> 62.15 62.57 62.56 4 MOT 22 22.24 22.11 5 6
> However, since I set the symbol range to be A2:A100 and the Yahoo code
> range to be B1:M1, I can easily extend the table in either direction .
> For example, I can type "v" in cell E1. And I can type "MMM" in cell
> A5. I would then see:
>
> A B C D E 1 o h l1 v 2 IBM 75.83 77.29 76.15 6422900 3 JNJ
> 62.15 62.57 62.56 7658600 4 MOT 22 22.24 22.11 21180900 5 MMM 69.89
> 70.7 69.75 6141000 6
> And I can keep putting more symbols in, down to cell A100. Or I can
> put in more Yahoo codes, out to cell M1.
>
> Hopefully that helps a bit?
>
- 4.2.
-
Re: RCHGetYahooQuotes()
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Mon Jun 6, 2011 12:41 pm (PDT)
NA results typically mean that that is what Yahoo is sending.
If you were trying it last night, it would also depend on whether it was
before and after they have reset things for the next day -- in which case
they would be NA because they wouldn't be updated with real data until the
market opens.
On Mon, Jun 6, 2011 at 12:34 PM, investor952 <investor952@yahoo.com > wrote:
> Hello, I am a newbee at this..just found this fantastic tool on internet
> last night...
>
> I just tried this..and the o and l (open and low price) show up as NA for
> all the tickers. Looks like Yahoo doesn't have this data?
> I use an older version of Excel..2002 I think.
>
- 4.3.
-
Re: RCHGetYahooQuotes()
Posted by: "investor952" investor952@yahoo.com investor952
Mon Jun 6, 2011 1:16 pm (PDT)
hmmm...i forgot to mention that the l1 code for the close worked..but the o and h didn't (open and high)..
It's going to take me awhile to learn to use this..but it is exactly the tool i was looking for...
I still use an old computer with Excel 2002 or 2003. How will this limit my use? thx.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> NA results typically mean that that is what Yahoo is sending.
>
> If you were trying it last night, it would also depend on whether it was
> before and after they have reset things for the next day -- in which case
> they would be NA because they wouldn't be updated with real data until the
> market opens.
>
> On Mon, Jun 6, 2011 at 12:34 PM, investor952 <investor952@...> wrote:
>
> > Hello, I am a newbee at this..just found this fantastic tool on internet
> > last night...
> >
> > I just tried this..and the o and l (open and low price) show up as NA for
> > all the tickers. Looks like Yahoo doesn't have this data?
> > I use an older version of Excel..2002 I think.
> >
>
- 4.4.
-
Re: RCHGetYahooQuotes()
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Mon Jun 6, 2011 1:50 pm (PDT)
It shouldn't. I actually first developed the add-in using EXCEL 2002, until
my old machine died a few years ago.
On Mon, Jun 6, 2011 at 1:15 PM, investor952 <investor952@yahoo.com > wrote:
>
> I still use an old computer with Excel 2002 or 2003. How will this limit my
> use? thx.
>
- 5a.
-
time warp?
Posted by: "sihlai" sihlai@yahoo.ca sihlai
Mon Jun 6, 2011 6:13 pm (PDT)
I have been having a strange problem with several of the functions. Right now after market close, I expect to be able to retrieve today's closing prices. However, they are retrieving prior day's closing prices. I hit F9 to refresh but the same quotes are shown. I have so far noticed this problem with smfGetOptionQuotes and RCHGetTableCell. For RCHGetTableCell, I even checked out the actual web link, and the web page showed a different number than what RCHGetTableCell gathered. Any idea?
- 5b.
-
Re: time warp?
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Mon Jun 6, 2011 6:19 pm (PDT)
Go to the "Links" area of the group and read about the smfForceRecalculation
macro. F9 does NOT update RCHGetTableCell() or smfGetOptionQuotes( )
functions.
On Mon, Jun 6, 2011 at 6:13 PM, sihlai <sihlai@yahoo.ca > wrote:
> I have been having a strange problem with several of the functions. Right
> now after market close, I expect to be able to retrieve today's closing
> prices. However, they are retrieving prior day's closing prices. I hit F9 to
> refresh but the same quotes are shown. I have so far noticed this problem
> with smfGetOptionQuotes and RCHGetTableCell. For RCHGetTableCell, I even
> checked out the actual web link, and the web page showed a different number
> than what RCHGetTableCell gathered. Any idea?
>
- 6.
-
quicktake morningstar
Posted by: "alexander" alex.life2539@gmail.com life2539
Mon Jun 6, 2011 7:55 pm (PDT)
has anyone tried to look at integrating the 'quicktake' web alias of morningstar to extract its fin data on excel?
here is a link of its resources available. It is just the same data from going straight to the morningstar website. But it might be used as a workaround to pull fin data(balance sheet, Income Statement, Cash Flow) from the site.
here is a link of their list of quicktake links.
http://quicktake.morningstar. com/syndication/ index.htm
- 7a.
-
Incorrect Ex-Dividend Date extraction
Posted by: "PhillipG" philgiz@zoominternet.net philgiz_2000
Mon Jun 6, 2011 8:40 pm (PDT)
Hi Randy. I am using the 'rchgetyahooquotes' function to extract the ex-dividend date for GE stock. The 'q' code is pulling up 2/24/11 as the date. That was the date for the 1st qrt. The date showing in the Yahoo 'key statistics' is 6/16/11. Any idea why and what I should do to get the latest date?
Thanks;
Phil
- 7b.
-
Re: Incorrect Ex-Dividend Date extraction
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Mon Jun 6, 2011 8:45 pm (PDT)
You can extract it from the Key Statistics page. However, it's going to be
much slower, since you need to retrieve a new web page for each ticker
symbol. I have quite often found the ex-dividend date on that page to not be
current as well.
I haven't found a reliable source for ex-dividend dates, or at least a free
one. The best method to me seems to be to estimate it from the payout from
the previous year, at least for stocks that have a regular history of paying
dividends.
Maybe you'll need to use a paid service for such data, where they have a
financial incentive to keep the data current?
On Mon, Jun 6, 2011 at 8:39 PM, PhillipG <philgiz@zoominternet.net > wrote:
> Hi Randy. I am using the 'rchgetyahooquotes' function to extract the
> ex-dividend date for GE stock. The 'q' code is pulling up 2/24/11 as the
> date. That was the date for the 1st qrt. The date showing in the Yahoo
> 'key statistics' is 6/16/11. Any idea why and what I should do to get the
> latest date?
>
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