Messages In This Digest (25 Messages)
- 1a.
- IBD data From: tom_b_ellis
- 1b.
- Re: IBD data From: Randy Harmelink
- 1c.
- Re: IBD data From: Stephen Cole
- 2a.
- Return text not cell referrence From: scottandrewjackson
- 2b.
- Re: Return text not cell referrence From: Randy Harmelink
- 3a.
- Re: How to pull data from SEC Form 4 From: Au
- 3b.
- Re: How to pull data from SEC Form 4 From: Randy Harmelink
- 3c.
- Re: How to pull data from SEC Form 4 From: Au
- 3d.
- Re: How to pull data from SEC Form 4 From: Au
- 3e.
- Re: How to pull data from SEC Form 4 From: paul messerschmidt
- 4a.
- profile summary From: nikos chryssochoidis
- 4b.
- Re: profile summary From: Randy Harmelink
- 5a.
- Yahoo "high" quotes not working? From: Bellawala
- 5b.
- Re: Yahoo "high" quotes not working? From: Randy Harmelink
- 5c.
- Re: Yahoo "high" quotes not working? From: swoodbri
- 5d.
- Re: Yahoo "high" quotes not working? From: Randy Harmelink
- 5e.
- Re: Yahoo "high" quotes not working? From: swoodbri
- 5f.
- Re: Yahoo "high" quotes not working? From: Randy Harmelink
- 5g.
- Re: Yahoo "high" quotes not working? From: swoodbri
- 5h.
- Re: Yahoo "high" quotes not working? From: swoodbri
- 5i.
- Re: Yahoo "high" quotes not working? From: Randy Harmelink
- 6a.
- Re: Split Information From: MLSrini
- 7.
- Income Funds From: elderbands
- 8a.
- Get Options Quotes From: Keith
- 8b.
- Re: Get Options Quotes From: Randy Harmelink
Messages
- 1a.
-
IBD data
Posted by: "tom_b_ellis" mrtomellis@gmail.com tom_b_ellis
Fri Aug 5, 2011 4:52 am (PDT)
I was able to get the add in to work well with yahoo data. I have a worksheet that also is supposed to get IBD data. Two of the data fields populate when I refresh and about 25 do not.
The fields that populate are "EPS Rating" and the first leader of the industry groups.
Any idea on how to get the rest of the fields to populate?
- 1b.
-
Re: IBD data
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Fri Aug 5, 2011 5:06 am (PDT)
What functions/parameters are you using?
On Fri, Aug 5, 2011 at 4:02 AM, tom_b_ellis <mrtomellis@gmail.com > wrote:
> I was able to get the add in to work well with yahoo data. I have a
> worksheet that also is supposed to get IBD data. Two of the data fields
> populate when I refresh and about 25 do not.
>
> The fields that populate are "EPS Rating" and the first leader of the
> industry groups.
>
> Any idea on how to get the rest of the fields to populate?
>
- 1c.
-
Re: IBD data
Posted by: "Stephen Cole" scole@colenetlaw.com subrostud
Fri Aug 5, 2011 8:04 am (PDT)
I thought you were of the opinion the xls was 'clunky'? Still working on
it?
Stephen
Stephen N. Cole
ofc: 916-376-0486
fax: 208-693-2460
cel: 916-869-1651
"In a democracy, we have always had to worry about the ignorance of the
uneducated. Today we have to worry about the ignorance of people with
college degrees." Thomas Sowell.
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On
Behalf Of tom_b_ellis
Sent: Friday, August 05, 2011 4:03 AM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] IBD data
I was able to get the add in to work well with yahoo data. I have a
worksheet that also is supposed to get IBD data. Two of the data fields
populate when I refresh and about 25 do not.
The fields that populate are "EPS Rating" and the first leader of the
industry groups.
Any idea on how to get the rest of the fields to populate?
- 2a.
-
Return text not cell referrence
Posted by: "scottandrewjackson" scottandrewjackson@yahoo.com scottandrewjackson
Fri Aug 5, 2011 4:52 am (PDT)
I apologize for such a simple question but I have been looking for the answer for about four hours now.
I am building an adjusted price to book spreadsheet and I am trying to make it so I get text instead of a cell reference.
The ticker symbol "IDSY" is in B2 and I am getting an error
=RCHGetTableCell("http://finance. yahoo.com/ ",1,"Cash And Cash Equivalents"q/bs?s=B2+ Balance+Sheet& quarterly )
How do I get the text from B2 to show up in the function?
Thank you.
- 2b.
-
Re: Return text not cell referrence
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Fri Aug 5, 2011 5:05 am (PDT)
Just normal EXCEL string concatenation:
=RCHGetTableCell("http://finance. yahoo.com/ "&B2&"+Balance+q/bs?s= Sheet&quarterly" ,1,"Cash
And Cash Equivalents")
On Fri, Aug 5, 2011 at 1:35 AM, scottandrewjackson <
scottandrewjackson@yahoo.com > wrote:
> I apologize for such a simple question but I have been looking for the
> answer for about four hours now.
>
> I am building an adjusted price to book spreadsheet and I am trying to make
> it so I get text instead of a cell reference.
>
> The ticker symbol "IDSY" is in B2 and I am getting an error
>
> =RCHGetTableCell("
> http://finance.yahoo.com/ ",1,"Cash Andq/bs?s=B2+ Balance+Sheet& quarterly
> Cash Equivalents")
>
> How do I get the text from B2 to show up in the function?
>
- 3a.
-
Re: How to pull data from SEC Form 4
Posted by: "Au" uanant@ymail.com uanant@ymail.com
Fri Aug 5, 2011 5:23 am (PDT)
Hello Randy,
Thanks for your prompt reply. What does the "td" stands for the formula below
=smfGetTagContent(...URL... ,"td",... counter.. .)
I put "td" as it is and it is returning #VALUE!
Regards
Aku
_____________________ _________ __
From: Randy Harmelink <rharmelink@gmail.com >
To: smf_addin@yahoogroups.com
Sent: Thursday, August 4, 2011 4:24 PM
Subject: Re: [smf_addin] How to pull data from SEC Form 4
I was able to extract data from both pages, using either RCHGetTableCell() or smfGetTagContent( ) functions.
It's easy enough to try --- just do something like:
=smfGetTagContent(...URL... ,"td",... counter.. .)
...and varying "...counter..." from 1 to n to see what is in the various table cells on the web page.
On Thu, Aug 4, 2011 at 12:22 PM, Au <uanant@ymail.com > wrote:
>
>Is it possible to pull data from this page.
>http://www.sec.gov/cgi-bin/ srch-edgar? text=company- name%3D%22Net+ 1+Ueps+Technolog ies%22+AND+ form-type% 3D%2810-q* +OR+10-k* +OR+4%29& first=1996& last=2011
>
>
>
>http://www.sec.gov/Archives/ edgar/data/ 1041514/00010629 9310003865/ xslF345X03/ form4.xml
>
>
- 3b.
-
Re: How to pull data from SEC Form 4
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Fri Aug 5, 2011 6:56 am (PDT)
It's just a literal for the HTML table cell tag. Did you use the proper
double quotes to delimit the string?
On Fri, Aug 5, 2011 at 5:23 AM, Au <uanant@ymail.com > wrote:
> Thanks for your prompt reply. What does the "td" stands for the formula
> below
> =smfGetTagContent(...URL... ,"td",... counter.. .)
>
> I put "td" as it is and it is returning #VALUE!
>
>
- 3c.
-
Re: How to pull data from SEC Form 4
Posted by: "Au" uanant@ymail.com uanant@ymail.com
Fri Aug 5, 2011 7:19 am (PDT)
Am i doing this correctly
=smfGetTagContent(www.sec.gov/ Archives/ edgar/data/ 1041514/10629931 0003865/xslF345X 03/form4. xml,"td", 5)
Regards
Aku
_____________________ _________ __
From: Randy Harmelink <rharmelink@gmail.com >
To: smf_addin@yahoogroups.com
Sent: Thursday, August 4, 2011 4:24 PM
Subject: Re: [smf_addin] How to pull data from SEC Form 4
I was able to extract data from both pages, using either RCHGetTableCell() or smfGetTagContent( ) functions.
It's easy enough to try --- just do something like:
=smfGetTagContent(...URL... ,"td",... counter.. .)
...and varying "...counter..." from 1 to n to see what is in the various table cells on the web page.
On Thu, Aug 4, 2011 at 12:22 PM, Au <uanant@ymail.com > wrote:
>
>Is it possible to pull data from this page.
>http://www.sec.gov/cgi-bin/ srch-edgar? text=company- name%3D%22Net+ 1+Ueps+Technolog ies%22+AND+ form-type% 3D%2810-q* +OR+10-k* +OR+4%29& first=1996& last=2011
>
>
>
>http://www.sec.gov/Archives/ edgar/data/ 1041514/00010629 9310003865/ xslF345X03/ form4.xml
>
>
- 3d.
-
Re: How to pull data from SEC Form 4
Posted by: "Au" uanant@ymail.com uanant@ymail.com
Fri Aug 5, 2011 7:30 am (PDT)
Randy,
I think i found out how to do this,
=smfGetTagContent("http://www.sec. gov/Archives/ ","td",10)edgar/data/ 320193/000118143 111043490/ xslF345X03/ rrd318761. xml
This returns = Estimated Average Burden
_____________________ _________ __
From: Au <uanant@ymail.com >
To: "smf_addin@yahoogroups.com " <smf_addin@yahoogroups.com >
Sent: Friday, August 5, 2011 10:18 AM
Subject: Re: [smf_addin] How to pull data from SEC Form 4
Am i doing this correctly
=smfGetTagContent(www.sec.gov/ Archives/ edgar/data/ 1041514/10629931 0003865/xslF345X 03/form4. xml,"td", 5)
Regards
Aku
_____________________ _________ __
From: Randy Harmelink <rharmelink@gmail.com >
To: smf_addin@yahoogroups.com
Sent: Thursday, August 4, 2011 4:24 PM
Subject: Re: [smf_addin] How to pull data from SEC Form 4
I was able to extract data from both pages, using either RCHGetTableCell() or smfGetTagContent( ) functions.
It's easy enough to try --- just do something like:
=smfGetTagContent(...URL... ,"td",... counter.. .)
...and varying "...counter..." from 1 to n to see what is in the various table cells on the web page.
On Thu, Aug 4, 2011 at 12:22 PM, Au <uanant@ymail.com > wrote:
>
>Is it possible to pull data from this page.
>http://www.sec.gov/cgi-bin/ srch-edgar? text=company- name%3D%22Net+ 1+Ueps+Technolog ies%22+AND+ form-type% 3D%2810-q* +OR+10-k* +OR+4%29& first=1996& last=2011
>
>
>
>http://www.sec.gov/Archives/ edgar/data/ 1041514/00010629 9310003865/ xslF345X03/ form4.xml
>
>
- 3e.
-
Re: How to pull data from SEC Form 4
Posted by: "paul messerschmidt" financepaul@gmail.com fuelspotpaul
Fri Aug 5, 2011 10:45 am (PDT)
here is another free source for the sec form 4 data
http://www.secform4.com/insider- trading/1041514. htm
<http://www.secform4.com/insider- >trading/1041514. htm
On Fri, Aug 5, 2011 at 10:30 AM, Au <uanant@ymail.com > wrote:
> **
>
>
> Randy,
> I think i found out how to do this,
> =smfGetTagContent("
> http://www.sec.gov/Archives/ edgar/data/ 320193/000118143 111043490/ xslF345X03/ rrd318761. xml
> ","td",10)
> This returns = Estimated Average Burden
>
>
> --------------------- ---------
> *From:* Au <uanant@ymail.com >
> *To:* "smf_addin@yahoogroups.com " <smf_addin@yahoogroups.com >
> *Sent:* Friday, August 5, 2011 10:18 AM
>
> *Subject:* Re: [smf_addin] How to pull data from SEC Form 4
>
>
> Am i doing this correctly
> =smfGetTagContent(
> www.sec.gov/Archives/ edgar/data/ 1041514/10629931 0003865/xslF345X 03/form4. xml,
> "td",5)
> Regards
> Aku
> --------------------- ---------
> *From:* Randy Harmelink <rharmelink@gmail.com >
> *To:* smf_addin@yahoogroups.com
> *Sent:* Thursday, August 4, 2011 4:24 PM
> *Subject:* Re: [smf_addin] How to pull data from SEC Form 4
>
>
> I was able to extract data from both pages, using either RCHGetTableCell()
> or smfGetTagContent() functions.
>
> It's easy enough to try --- just do something like:
>
> =smfGetTagContent(...URL... ,"td",... counter.. .)
>
> ...and varying "...counter..." from 1 to n to see what is in the various
> table cells on the web page.
>
> On Thu, Aug 4, 2011 at 12:22 PM, Au <uanant@ymail.com > wrote:
>
>
> Is it possible to pull data from this page.
>
> http://www.sec.gov/cgi-bin/ srch-edgar? text=company- name%3D%22Net+ 1+Ueps+Technolog ies%22+AND+ form-type% 3D%2810-q* +OR+10-k* +OR+4%29& first=1996& last=2011
>
>
> http://www.sec.gov/Archives/ edgar/data/ 1041514/00010629 9310003865/ xslF345X03/ form4.xml
>
>
>
>
>
>
>
>
--
--------------------- --------- --------- --
Paul Messerschmidt
paul.messerschmidt (skype)
+1-813-334-8682 (mobile)
- 4a.
-
profile summary
Posted by: "nikos chryssochoidis" nikoschryssochoidis@yahoo.gr nikoschryssochoidis
Fri Aug 5, 2011 11:15 am (PDT)
hi,
am wondering if there is a formula to use , in order to add in a cell of an excel the profile summary of a company listed in a stock exchange.
thank you , and many thanks for this great group !
- 4b.
-
Re: profile summary
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Fri Aug 5, 2011 3:08 pm (PDT)
You'll need to be more specific. The mention of "in a stock exchange"
confuses me, as if it should mean something other than the normal.
Otherwise, you could search the message archives of the group for "business
summary" or "profile", which can come from multiple data sources.
On Fri, Aug 5, 2011 at 11:11 AM, nikos chryssochoidis <
nikoschryssochoidis@yahoo.gr > wrote:
>
> am wondering if there is a formula to use , in order to add in a cell of an
> excel the profile summary of a company listed in a stock exchange.
>
- 5a.
-
Yahoo "high" quotes not working?
Posted by: "Bellawala" bellawala@yahoo.com bellawala
Fri Aug 5, 2011 1:15 pm (PDT)
Hello,
when I use the following statement: =RCHGetYahooQuotes( "MSFT", "ovghl1", , , ), the 4th value, high, always returns N/A. It does this for all symbols that I try. Any ideas on what I'm doing wrong? This is in a spreadsheet that I have been using for a long time and have not changed.
thanks!
- 5b.
-
Re: Yahoo "high" quotes not working?
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Fri Aug 5, 2011 1:29 pm (PDT)
"N/A" means that is what Yahoo is currently populating the field with.
Nothing the add-in can do about it. Hopefully a temporary issue.
On Fri, Aug 5, 2011 at 1:15 PM, Bellawala <bellawala@yahoo.com > wrote:
>
> when I use the following statement: =RCHGetYahooQuotes( "MSFT", "ovghl1",
> , , ), the 4th value, high, always returns N/A. It does this for all
> symbols that I try. Any ideas on what I'm doing wrong? This is in a
> spreadsheet that I have been using for a long time and have not changed.
>
- 5c.
-
Re: Yahoo "high" quotes not working?
Posted by: "swoodbri" woodbri@swoodbridge.com swoodbri
Fri Aug 5, 2011 3:07 pm (PDT)
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> "N/A" means that is what Yahoo is currently populating the field with.
> Nothing the add-in can do about it. Hopefully a temporary issue.
>
> On Fri, Aug 5, 2011 at 1:15 PM, Bellawala <bellawala@...> wrote:
>
> >
> > when I use the following statement: =RCHGetYahooQuotes( "MSFT", "ovghl1",
> > , , ), the 4th value, high, always returns N/A. It does this for all
> > symbols that I try. Any ideas on what I'm doing wrong? This is in a
> > spreadsheet that I have been using for a long time and have not changed.
> >
>
I think there is a larger problem with Yahoo quotes in general. if you create a spreadsheet like:
IBM | =RCHGetYahooQuotes(A2,"l1",, NOW())
Then copy those to cells down 10+ rows you will get different values! If you hit key F9 the numbers change. Do this after market hours when the numbers should be stable.
I am also seeing something similar on my Windows7 Desktop Gadget Market 3.4 where the numbers jump around between different requests. So on one query I get one number and on the next I might get the same or a different value.
I'm wondering if maybe we should be looking at using another service? Does google have an API? or maybe Finviz?
- 5d.
-
Re: Yahoo "high" quotes not working?
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Fri Aug 5, 2011 3:10 pm (PDT)
Just tried it, and I got consistent values over the 10 rows, even with
hitting F9 several times.
I don't know of another data source with a Yahoo-like API for getting
multiple quotes/data items.
On Fri, Aug 5, 2011 at 2:26 PM, swoodbri <woodbri@swoodbridge.com > wrote:
>
> I think there is a larger problem with Yahoo quotes in general. if you
> create a spreadsheet like:
>
> IBM | =RCHGetYahooQuotes(A2,"l1",, NOW())
>
> Then copy those to cells down 10+ rows you will get different values! If
> you hit key F9 the numbers change. Do this after market hours when the
> numbers should be stable.
>
> I am also seeing something similar on my Windows7 Desktop Gadget Market 3.4
> where the numbers jump around between different requests. So on one query I
> get one number and on the next I might get the same or a different value.
>
> I'm wondering if maybe we should be looking at using another service? Does
> google have an API? or maybe Finviz?
>
- 5e.
-
Re: Yahoo "high" quotes not working?
Posted by: "swoodbri" woodbri@swoodbridge.com swoodbri
Fri Aug 5, 2011 8:18 pm (PDT)
Randy,
Thanks for your reply, so now I'm wondering why I have this problem.
This first table is built using:
=RCHGetYahooQuotes(A2,"l1t8c1p2yq" ,,NOW())
IBM 172.98 193.5 1.5 0.0087 1.57 May 6
IBM 178.05 193.5 -2.7 -0.0149 1.49 May 6 <<<
IBM 178.05 193.5 -2.7 -0.0149 1.49 May 6 <<<
IBM 172.98 193.5 1.5 0.0087 1.57 May 6
IBM 172.98 193.5 1.5 0.0087 1.57 May 6
IBM 178.05 193.5 -2.7 -0.0149 1.49 May 6 <<<
IBM 172.98 193.5 1.5 0.0087 1.57 May 6
IBM 172.98 193.5 1.5 0.0087 1.57 May 6
IBM 172.98 193.5 1.5 0.0087 1.57 May 6
IBM 172.98 193.5 1.5 0.0087 1.57 May 6
IBM 172.98 193.5 1.5 0.0087 1.57 May 6
IBM 172.98 193.5 1.5 0.0087 1.57 May 6
IBM 172.98 193.5 1.5 0.0087 1.57 May 6
and this is built use the example I gave you:
=RCHGetYahooQuotes(A16,"l1", ,NOW())
IBM 178.05 <<<<
IBM 172.98
IBM 178.05 <<<<
IBM 172.98
IBM 178.05 <<<<
IBM 172.98
IBM 172.98
IBM 172.98
IBM 172.98
IBM 172.98
IBM 178.05 <<<<
The numbers I get are always consistent for example 172.98 or 178.05 in this case for IBM also notice in the table above that other numbers are wrong also.
Since I get this with both smf and with my desktop gadgets, I'm guessing it is not a problem with smf but with something else. Any thoughts on what or how to trace this done so I can fix whatever is wrong.
-Steve
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Just tried it, and I got consistent values over the 10 rows, even with
> hitting F9 several times.
>
> I don't know of another data source with a Yahoo-like API for getting
> multiple quotes/data items.
>
> On Fri, Aug 5, 2011 at 2:26 PM, swoodbri <woodbri@...> wrote:
>
> >
> > I think there is a larger problem with Yahoo quotes in general. if you
> > create a spreadsheet like:
> >
> > IBM | =RCHGetYahooQuotes(A2,"l1",, NOW())
> >
> > Then copy those to cells down 10+ rows you will get different values! If
> > you hit key F9 the numbers change. Do this after market hours when the
> > numbers should be stable.
> >
> > I am also seeing something similar on my Windows7 Desktop Gadget Market 3.4
> > where the numbers jump around between different requests. So on one query I
> > get one number and on the next I might get the same or a different value.
> >
> > I'm wondering if maybe we should be looking at using another service? Does
> > google have an API? or maybe Finviz?
> >
>
- 5f.
-
Re: Yahoo "high" quotes not working?
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Fri Aug 5, 2011 8:22 pm (PDT)
I would suspect that you have your Internet Options set up to cache web
pages, which means the add-in will retrieve those cached web pages instead
of getting a new copy of the web page each time. See this item from the
"Links" area of the group:
http://finance.groups.yahoo. com/group/ smf_addin/ message/13523
That would also affect any "gadgets" that use the Microsoft Internet engine
to retrieve web pages.
On Fri, Aug 5, 2011 at 8:01 PM, swoodbri <woodbri@swoodbridge.com > wrote:
>
> Thanks for your reply, so now I'm wondering why I have this problem.
>
> This first table is built using:
> =RCHGetYahooQuotes(A2,"l1t8c1p2yq" ,,NOW())
>
> IBM 172.98 193.5 1.5 0.0087 1.57 May 6
> IBM 178.05 193.5 -2.7 -0.0149 1.49 May 6 <<<
> IBM 178.05 193.5 -2.7 -0.0149 1.49 May 6 <<<
> IBM 172.98 193.5 1.5 0.0087 1.57 May 6
> IBM 172.98 193.5 1.5 0.0087 1.57 May 6
> IBM 178.05 193.5 -2.7 -0.0149 1.49 May 6 <<<
> IBM 172.98 193.5 1.5 0.0087 1.57 May 6
> IBM 172.98 193.5 1.5 0.0087 1.57 May 6
> IBM 172.98 193.5 1.5 0.0087 1.57 May 6
> IBM 172.98 193.5 1.5 0.0087 1.57 May 6
> IBM 172.98 193.5 1.5 0.0087 1.57 May 6
> IBM 172.98 193.5 1.5 0.0087 1.57 May 6
> IBM 172.98 193.5 1.5 0.0087 1.57 May 6
>
>
> and this is built use the example I gave you:
> =RCHGetYahooQuotes(A16,"l1", ,NOW())
>
> IBM 178.05 <<<<
> IBM 172.98
> IBM 178.05 <<<<
> IBM 172.98
> IBM 178.05 <<<<
> IBM 172.98
> IBM 172.98
> IBM 172.98
> IBM 172.98
> IBM 172.98
> IBM 178.05 <<<<
>
> The numbers I get are always consistent for example 172.98 or 178.05 in
> this case for IBM also notice in the table above that other numbers are
> wrong also.
>
> Since I get this with both smf and with my desktop gadgets, I'm guessing it
> is not a problem with smf but with something else. Any thoughts on what or
> how to trace this done so I can fix whatever is wrong.
>
- 5g.
-
Re: Yahoo "high" quotes not working?
Posted by: "swoodbri" woodbri@swoodbridge.com swoodbri
Fri Aug 5, 2011 8:34 pm (PDT)
Randy,
A little more info on this. I downloaded HTTP Spy .NET and looked at the requests and responses. All the requests are identical like this:
GET http://download.finance.yahoo. HTTP/1.1com/d/quotes. csv?s=IBM& f=l1&e=.ignore
Accept: */*
Accept-Encoding: gzip, deflate
User-Agent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.1; WOW64; Trident/5.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; CMDTDF; .NET4.0C)
Host: download.finance.yahoo.com
Proxy-Connection: Keep-Alive
Cookie: B=2273i9573olbk&b=3&s=a8
and all the responses look like one of the following two responses:
HTTP/1.1 200 OK
Date: Sat, 06 Aug 2011 03:14:59 GMT
P3P: policyref="http://p3p.yahoo.com/w3c/p3p. ", CP="CAO DSP COR CUR ADM DEV TAI PSA PSD IVAi IVDi CONi TELo OTPi OUR DELi SAMi OTRi UNRi PUBi IND PHY ONL UNI PUR FIN COM NAV INT DEM CNT STA POL HEA PRE GOV"xml
Cache-Control: no-cache
Expires: -1
Pragma: no-cache
Connection: close
Transfer-Encoding: chunked
Content-Type: application/octet-stream
8
172.98
0
HTTP/1.1 200 OK
Date: Sat, 06 Aug 2011 03:14:58 GMT
P3P: policyref="http://p3p.yahoo.com/w3c/p3p. ", CP="CAO DSP COR CUR ADM DEV TAI PSA PSD IVAi IVDi CONi TELo OTPi OUR DELi SAMi OTRi UNRi PUBi IND PHY ONL UNI PUR FIN COM NAV INT DEM CNT STA POL HEA PRE GOV"xml
Cache-Control: no-cache
Expires: -1
Pragma: no-cache
Connection: close
Transfer-Encoding: chunked
Content-Type: application/octet-stream
8
178.05
0
Likewise for the multiple values here are the requests and responses:
GET http://download.finance.yahoo. HTTP/1.1com/d/quotes. csv?s=IBM& f=l1t8c1p2yq& e=.ignore
Accept: */*
Accept-Encoding: gzip, deflate
User-Agent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.1; WOW64; Trident/5.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; CMDTDF; .NET4.0C)
Host: download.finance.yahoo.com
Proxy-Connection: Keep-Alive
Cookie: B=2273i9573olbk&b=3&s=a8
HTTP/1.1 200 OK
Date: Sat, 06 Aug 2011 03:14:59 GMT
P3P: policyref="http://p3p.yahoo.com/w3c/p3p. ", CP="CAO DSP COR CUR ADM DEV TAI PSA PSD IVAi IVDi CONi TELo OTPi OUR DELi SAMi OTRi UNRi PUBi IND PHY ONL UNI PUR FIN COM NAV INT DEM CNT STA POL HEA PRE GOV"xml
Cache-Control: no-cache
Expires: -1
Pragma: no-cache
Connection: close
Transfer-Encoding: chunked
Content-Type: application/octet-stream
2c
178.05,193.50,-2.70,"-1. 49%",1.49, "May 6"
0
HTTP/1.1 200 OK
Date: Sat, 06 Aug 2011 03:14:59 GMT
P3P: policyref="http://p3p.yahoo.com/w3c/p3p. ", CP="CAO DSP COR CUR ADM DEV TAI PSA PSD IVAi IVDi CONi TELo OTPi OUR DELi SAMi OTRi UNRi PUBi IND PHY ONL UNI PUR FIN COM NAV INT DEM CNT STA POL HEA PRE GOV"xml
Cache-Control: no-cache
Expires: -1
Pragma: no-cache
Connection: close
Transfer-Encoding: chunked
Content-Type: application/octet-stream
2c
172.98,193.50,+1.50,"+0. 87%",1.57, "May 6"
0
I tried to log the desktop gadget but it does not seem to be using .NET for the HTTP requests because they are not caught by HTTP Spy.
Any thoughts on what the Cookie is for? How can I delete the cookie.
-Steve
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Just tried it, and I got consistent values over the 10 rows, even with
> hitting F9 several times.
>
> I don't know of another data source with a Yahoo-like API for getting
> multiple quotes/data items.
>
> On Fri, Aug 5, 2011 at 2:26 PM, swoodbri <woodbri@...> wrote:
>
> >
> > I think there is a larger problem with Yahoo quotes in general. if you
> > create a spreadsheet like:
> >
> > IBM | =RCHGetYahooQuotes(A2,"l1",, NOW())
> >
> > Then copy those to cells down 10+ rows you will get different values! If
> > you hit key F9 the numbers change. Do this after market hours when the
> > numbers should be stable.
> >
> > I am also seeing something similar on my Windows7 Desktop Gadget Market 3.4
> > where the numbers jump around between different requests. So on one query I
> > get one number and on the next I might get the same or a different value.
> >
> > I'm wondering if maybe we should be looking at using another service? Does
> > google have an API? or maybe Finviz?
> >
>
- 5h.
-
Re: Yahoo "high" quotes not working?
Posted by: "swoodbri" woodbri@swoodbridge.com swoodbri
Fri Aug 5, 2011 9:09 pm (PDT)
I reset my internet options per the message referenced below and cleared the internet cache, and was able to delete the cookie using HTTP Spy, but I still am getting the same behavior. I get a new Cookie after I delete the Cookie, but it does not change the behavior.
The internet cache option should not really matter if IE is honoring the: Pragma: no-cache in the request header. And the response header also has:
Cache-Control: no-cache
Pragma: no-cache
-Steve
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> I would suspect that you have your Internet Options set up to cache web
> pages, which means the add-in will retrieve those cached web pages instead
> of getting a new copy of the web page each time. See this item from the
> "Links" area of the group:
>
> http://finance.groups.yahoo. com/group/ smf_addin/ message/13523
>
> That would also affect any "gadgets" that use the Microsoft Internet engine
> to retrieve web pages.
>
> On Fri, Aug 5, 2011 at 8:01 PM, swoodbri <woodbri@...> wrote:
>
> >
> > Thanks for your reply, so now I'm wondering why I have this problem.
> >
> > This first table is built using:
> > =RCHGetYahooQuotes(A2,"l1t8c1p2yq" ,,NOW())
> >
> > IBM 172.98 193.5 1.5 0.0087 1.57 May 6
> > IBM 178.05 193.5 -2.7 -0.0149 1.49 May 6 <<<
> > IBM 178.05 193.5 -2.7 -0.0149 1.49 May 6 <<<
> > IBM 172.98 193.5 1.5 0.0087 1.57 May 6
> > IBM 172.98 193.5 1.5 0.0087 1.57 May 6
> > IBM 178.05 193.5 -2.7 -0.0149 1.49 May 6 <<<
> > IBM 172.98 193.5 1.5 0.0087 1.57 May 6
> > IBM 172.98 193.5 1.5 0.0087 1.57 May 6
> > IBM 172.98 193.5 1.5 0.0087 1.57 May 6
> > IBM 172.98 193.5 1.5 0.0087 1.57 May 6
> > IBM 172.98 193.5 1.5 0.0087 1.57 May 6
> > IBM 172.98 193.5 1.5 0.0087 1.57 May 6
> > IBM 172.98 193.5 1.5 0.0087 1.57 May 6
> >
> >
> > and this is built use the example I gave you:
> > =RCHGetYahooQuotes(A16,"l1", ,NOW())
> >
> > IBM 178.05 <<<<
> > IBM 172.98
> > IBM 178.05 <<<<
> > IBM 172.98
> > IBM 178.05 <<<<
> > IBM 172.98
> > IBM 172.98
> > IBM 172.98
> > IBM 172.98
> > IBM 172.98
> > IBM 178.05 <<<<
> >
> > The numbers I get are always consistent for example 172.98 or 178.05 in
> > this case for IBM also notice in the table above that other numbers are
> > wrong also.
> >
> > Since I get this with both smf and with my desktop gadgets, I'm guessing it
> > is not a problem with smf but with something else. Any thoughts on what or
> > how to trace this done so I can fix whatever is wrong.
> >
>
- 5i.
-
Re: Yahoo "high" quotes not working?
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Fri Aug 5, 2011 9:18 pm (PDT)
BTW, 178.05 was the closing price of IBM on Aug 2nd.
But I'm baffled...
On Fri, Aug 5, 2011 at 9:09 PM, swoodbri <woodbri@swoodbridge.com > wrote:
> I reset my internet options per the message referenced below and cleared
> the internet cache, and was able to delete the cookie using HTTP Spy, but I
> still am getting the same behavior. I get a new Cookie after I delete the
> Cookie, but it does not change the behavior.
>
> The internet cache option should not really matter if IE is honoring the:
> Pragma: no-cache in the request header. And the response header also has:
>
> Cache-Control: no-cache
> Pragma: no-cache
>
> -Steve
>
- 6a.
-
Re: Split Information
Posted by: "MLSrini" mlsrini@yahoo.com mlsrini
Fri Aug 5, 2011 1:47 pm (PDT)
Randy,
You Rock!!!!
THANK YOU VERY MUCH! Really appreciate it.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> See: http://finance.groups.yahoo. com/group/ smf_addin/ message/14400
>
> On Sat, Jul 16, 2011 at 11:51 AM, MLSrini <mlsrini@...> wrote:
>
> >
> > Can anybody please help me to extract split information for a specific
> > symbol between two dates?
> >
>
- 7.
-
Income Funds
Posted by: "elderbands" elderbands@aol.com elderbands
Fri Aug 5, 2011 4:51 pm (PDT)
Can I get some opinions on 2 funds for an older couple as far as risk is concerned. They are NCZ and BTA.I know that NCZ is rikier ,but it has been paying this dividend for many months. Thank you.
- 8a.
-
Get Options Quotes
Posted by: "Keith" kdnune@yahoo.com kdnune
Fri Aug 5, 2011 5:44 pm (PDT)
=smfGetOptionQuotes("SPY Aug 2011 ITM1 Put,SPY Aug 2011 ITM2 Put,SPY Aug 2011 ITM3 Put,SPY Aug 2011 ITM4 Put, SPY Aug 2011 ITM5 Put", "zsba",1)
Hey, I tried to use this formula, and all I had returned was "Ticker Symbol". Why didn't I get the data?
Thanks
- 8b.
-
Re: Get Options Quotes
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Fri Aug 5, 2011 5:46 pm (PDT)
I suspect you entered the function in a single cell instead of
array-entering the function over a range?
On Fri, Aug 5, 2011 at 5:31 PM, Keith <kdnune@yahoo.com > wrote:
> =smfGetOptionQuotes("SPY Aug 2011 ITM1 Put,SPY Aug 2011 ITM2 Put,SPY Aug
> 2011 ITM3 Put,SPY Aug 2011 ITM4 Put, SPY Aug 2011 ITM5 Put", "zsba",1)
>
> Hey, I tried to use this formula, and all I had returned was "Ticker
> Symbol". Why didn't I get the data?
>
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