Sabtu, 28 Januari 2012

[smf_addin] Digest Number 2091

Messages In This Digest (15 Messages)

Messages

1a.

Re: =RCHGetYahooHistory updating very slow

Posted by: "Shaun" bolony21@gmail.com   draz2121

Fri Jan 27, 2012 3:43 am (PST)



Well, I will check but I would expect the previous days EOD to be available before the market open on the next day?

Almost all had updated to 26th Jan data by 10am this morning but none had updated before 8am when I need the data.

I'm baffled too....

Regards,

Shaun

On 27 Jan 2012, at 10:52, "Randy H" <rharmelink@gmail.com> wrote:

> Where isn't it updated? On Yahoo, or in your workbook? If it's not updated on Yahoo, you'll need to find a different source that has updated data available in time for your needs. If the workbook, I'm baffled -- it usually takes less than a second for me to get historical quotes on a stock.
>
>
> On Fri, Jan 27, 2012 at 3:23 AM, draz2121 <bolony21@gmail.com> wrote:
>
> I am using =RCHGetYahooHistory(B1,,,,,,,,,,1,1)
>
> .....where B1 is the ticker to fetch the following EOD data from Yahoo:
>
> Date Adj. Open Adj. High Adj. Low Adj. Close
>
> The problem is, the LSE opens at 8am GMT and none of my 64 ticker data is updated before this time.
>
> After 8am, they start to update in dribs and drabs.
>
> At the time of writing (10:22 GMT)there are still 5 that have not updated to show yesterday's EOD data.
>
> Is there anything I can do to get this data sooner and I need it before market open to make the most use of it.
>
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)
1b.

Re: =RCHGetYahooHistory updating very slow

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

Fri Jan 27, 2012 3:53 am (PST)



American stocks are usually updated within several hours of the NYSE
close...

Is it possible you just have a caching problem?

http://finance.groups.yahoo.com/group/smf_addin/message/13523

On Fri, Jan 27, 2012 at 4:43 AM, Shaun <bolony21@gmail.com> wrote:

Well, I will check but I would expect the previous days EOD to be
available before the market open on the next day?
Almost all had updated to 26th Jan data by 10am this morning but none
had updated before 8am when I need the data.
I'm baffled too....

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

Re: =RCHGetYahooHistory updating very slow

Posted by: "draz2121" bolony21@gmail.com   draz2121

Fri Jan 27, 2012 4:46 am (PST)



I don't use IE but understand form that message that Excel uses IE's settings.

I did indeed need to change this setting so I will know if this worked tonight :)

Thanks.

--- In smf_addin@yahoogroups.com, "Randy H" <rharmelink@...> wrote:
>
> American stocks are usually updated within several hours of the NYSE
> close...
>
> Is it possible you just have a caching problem?
>
> http://finance.groups.yahoo.com/group/smf_addin/message/13523
>
> On Fri, Jan 27, 2012 at 4:43 AM, Shaun <bolony21@...> wrote:
>
> Well, I will check but I would expect the previous days EOD to be
> available before the market open on the next day?
> Almost all had updated to 26th Jan data by 10am this morning but none
> had updated before 8am when I need the data.
> I'm baffled too....
>

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

Don't stuff it up for the rest of us

Posted by: "John" jpb6163@yahoo.com.au   jpb6163

Fri Jan 27, 2012 6:27 am (PST)



To all those people trying to develop stock data bases by down loading 1000's of financial items on 1000's of companies. Do you really think that all that data is correct? I recently down loaded ROE & dividend data on several companies from MSN, Yahoo & Commsec and found 3 different answers in some cases. In the end I had to go to company web sites to verify the correct data.

So just because you don't have to pay for it won't make it correct. But you will fuk it up for those of us who use the tool responsibly. Down load what u need and don't be greedy.

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

Re: Don't stuff it up for the rest of us

Posted by: "george" panax@fuse.net   simon_of_iernot

Fri Jan 27, 2012 8:27 am (PST)



Agreed!

----- Original Message -----
From: John
To: smf_addin@yahoogroups.com
Sent: Friday, January 27, 2012 09:27
Subject: [smf_addin] Don't stuff it up for the rest of us

To all those people trying to develop stock data bases by down loading 1000's of financial items on 1000's of companies. Do you really think that all that data is correct? I recently down loaded ROE & dividend data on several companies from MSN, Yahoo & Commsec and found 3 different answers in some cases. In the end I had to go to company web sites to verify the correct data.

So just because you don't have to pay for it won't make it correct. But you will fuk it up for those of us who use the tool responsibly. Down load what u need and don't be greedy.

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

Re: Error -- Too many web page retrievals

Posted by: "Lysakowski" lysakowski@yahoo.com   lysakowski

Fri Jan 27, 2012 9:57 am (PST)



I don't normally respond to something like this, but you can save yourself a lot of aggravation by subscribing to aaii.org Stock Investor Pro and get 1000s of accurate data points on over 9000 companies. These are updated monthly. The data are exportable.

Something to consider before being pennywise and pound foolish with your time.

Ricardo

On Jan 26, 2012, at 23:48, "tanya_1bg" <tanya_1bg@yahoo.com> wrote:

> Hi -
> I tried pulling the Earnings Growth Rate (5-Year Annual Average) using =RCHGetElementNumber(Ticker,66) which appears to source from MSN. Received an error message: Error -- Too many web page retrievals
>
> Is there a way around this? Alternatively, is there another "pullable" element that will give me the past 5-yr Earnings growth rate? Can also use EPS growth rate (past 5-yr avg).
>
> Would greatly appreciate anybody's help on this!
>
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (12)
3b.

Re: Error -- Too many web page retrievals

Posted by: "Stephen Cole" scole@colenetlaw.com   subrostud

Fri Jan 27, 2012 10:19 am (PST)



You can get loads of data from MarketSmith (www.investors.com) but it'll cost you $999/year. Very customizable lists, exportable to xls and xlsm.



Stephen

Stephen N. Cole

ofc: 916-376-0486

fax: 208-693-2460

cel: 916-869-1651



One of the happiest consequences of the absence of government...is the development of individual strength that inevitably follows. ~~de Tocqueville.



From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of Lysakowski
Sent: Friday, January 27, 2012 9:04 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Error -- Too many web page retrievals





I don't normally respond to something like this, but you can save yourself a lot of aggravation by subscribing to aaii.org Stock Investor Pro and get 1000s of accurate data points on over 9000 companies. These are updated monthly. The data are exportable.



Something to consider before being pennywise and pound foolish with your time.


Ricardo


On Jan 26, 2012, at 23:48, "tanya_1bg" <tanya_1bg@yahoo.com> wrote:



Hi -
I tried pulling the Earnings Growth Rate (5-Year Annual Average) using =RCHGetElementNumber(Ticker,66) which appears to source from MSN. Received an error message: Error -- Too many web page retrievals

Is there a way around this? Alternatively, is there another "pullable" element that will give me the past 5-yr Earnings growth rate? Can also use EPS growth rate (past 5-yr avg).

Would greatly appreciate anybody's help on this!



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

Re: Error -- Too many web page retrievals

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

Fri Jan 27, 2012 10:27 am (PST)



Plus, you can pull the data into EXCEL if you want. With the right data
connection, you can actually write your own functions to pull in
specific data items, just like the add-in functions do. I wrote up the
process here, back when I used SIPro:

http://finance.groups.yahoo.com/group/smf_addin/message/7029

Another powerful screener/backtester is StockScreen123.com (and their
more powerful and more expensive cousin Portfolio123.com). I dropped my
SIPro subscription after I got SS123 -- it is slightly cheaper, has more
data fields (including a number of quarterly and annual financial
statement items), and has a "point in time" backtester. My biggest
complaint with SS123 is that it's too easy to create a bullet screen
that has phenomenal returns, but it selects stocks that can't be traded
in large quantities in the real world. So you do need to put in your
own liquidity factors to ensure you can actually trade the results of
the screens.

On the free side, both FinViz and Zacks allow screening on a number of
factors, plus you can export all of the results -- even if it is every
stock they have in their database.

On Fri, Jan 27, 2012 at 10:04 AM, Lysakowski <lysakowski@yahoo.com>
wrote:

I don't normally respond to something like this, but you can save
yourself a lot of aggravation by subscribing to aaii.org
<http://aaii.org/> Stock Investor Pro and get 1000s of accurate data
points on over 9000 companies. These are updated monthly. The data are
exportable.
Something to consider before being pennywise and pound foolish with your
time.

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

Re: CDS

Posted by: "Allan Batista Gabriel" allan_bgabriel@yahoo.com.br   allan_bgabriel

Fri Jan 27, 2012 11:52 am (PST)





Hello,

does anyone know a website that is possible to get CDS (Credit default Swap) and  historical CDS ?

tks

Allan

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

Re: elements 547 - 550

Posted by: "Joel" joel.andrews@lpl.com   joelfp2000

Fri Jan 27, 2012 2:09 pm (PST)



Randy,

I believe they have added them back. Element 543 is the Stock Scouter Report Rating on MSN and it works fine. The webpage also offers the following:

The Stock Rating Summary verbiage: element 540 ?
Quick Summary (pro con): element 541 ?
Technical rating: element 547 ?
Valuation: element 548 ?
Ownership: element 549 ?
Fundamentals: element 550?

It would be great if you would reconnect these again. Thanks so very much for all of your help with this information.

Joel

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> They were obsoleted last year when MSN dropped them from their web pages.
> Have they added them back?
>
> On Mon, Jan 23, 2012 at 8:11 AM, Joel <joel.andrews@...> wrote:
>
> >
> > These elements from MSN2 do not seem to work. They are for Technical
> > Grade, Valuation Grade, Ownership Grade, and Fundamental Grade.
> >
>

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

Re: elements 547 - 550

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

Fri Jan 27, 2012 3:28 pm (PST)



Ah, my mistake. I did redefine elements 547-550. It was elements 551
(Return Grade) and 552 (Risk Grade) that I obsoleted. So many different
"Grades" on the stock. :)

To get elements 547-550, you probably just need the new element
definitions for MSN from the "Works in Progress" folder. Here was my
change log entry for that update:

2011-01-26 RCHGetElementNumber Updated the element definitions
in file smf-elements-1.txt because MSN
made changes to their web pages.
-- Too many were changed to mention them all.
-- Elements #2, #541-542, #544-546, and #551-552 were obsoleted.
I'll have to look at elements 540 and 541. I had obsoleted element 541,
but not 540. But it looks like the web page I used to get 540 from no
longer exists.

On Fri, Jan 27, 2012 at 3:09 PM, Joel <joel.andrews@lpl.com> wrote:

I believe they have added them back. Element 543 is the Stock Scouter
Report Rating on MSN and it works fine. The webpage also offers the
following:

The Stock Rating Summary verbiage: element 540 ?
Quick Summary (pro con): element 541 ?
Technical rating: element 547 ?
Valuation: element 548 ?
Ownership: element 549 ?
Fundamentals: element 550?

It would be great if you would reconnect these again. Thanks so very
much for all of your help with this information.

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

Re: elements 547 - 550

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

Fri Jan 27, 2012 4:08 pm (PST)



For now, these should get the Stock Rating Summary and Quick Summary:

=SUBSTITUTE(SUBSTITUTE(smfGetTagContent("
http://investing.money.msn.com/investments/stock-ratings/?symbol=MMM","p",1,"Stock
Rating Summary"),"<b>",""),"</b>","")
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(smfGetTagContent("
http://investing.money.msn.com/investments/stock-ratings/?symbol=MMM","div",1,"Quick
Summary"),"<span>",CHAR(10)),"</span>",""),"<B>"," ==>
"),"</B>",""),"</p>",""),"<p>",CHAR(10)&"-- ")

On Fri, Jan 27, 2012 at 3:09 PM, Joel <joel.andrews@lpl.com> wrote:

> The webpage also offers the following:
>
> The Stock Rating Summary verbiage: element 540 ?
> Quick Summary (pro con): element 541 ?
>
> It would be great if you would reconnect these again. Thanks so very much
> for all of your help with this information.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)
5a.

options quotes

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

Fri Jan 27, 2012 2:48 pm (PST)



Hi, these are great tools and I got the quotes to work for stocks but I am having trouble with options. Option symbols have now been standardized with a form like "IBM120218C00185000" for the Feb 18,2012 185 IBM CALL option. When I try to use these types of codes I can get nothing back of any use. Do you have any ideas on this problem?

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

Re: options quotes

Posted by: "Martin Topper" mtopper@yahoo.com   mtopper

Fri Jan 27, 2012 2:58 pm (PST)



In case Randy is not available for the weekend, please try searching old messages for options.  I think there has been a lot of discussion about how to do this.  You may need the version of the addin that is in Works in Progress folder in the files area.

have a good weekend

Marty

From: three100mph <three100mph@yahoo.com>

To: smf_addin@yahoogroups.com
Sent: Friday, January 27, 2012 5:44 PM
Subject: [smf_addin] options quotes


 
Hi, these are great tools and I got the quotes to work for stocks but I am having trouble with options. Option symbols have now been standardized with a form like "IBM120218C00185000" for the Feb 18,2012 185 IBM CALL option. When I try to use these types of codes I can get nothing back of any use. Do you have any ideas on this problem?

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

Re: options quotes

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

Fri Jan 27, 2012 3:12 pm (PST)



While "IBM120218C00185000" may be the defined standard form of the
option symbol, it is not what all data sources use. For example, both
Google and Yahoo use it, but MSN would use ".IBM\12B18\185.0" and
OptionsXPress would use "IBM^^^120218C00185000".

That's why when I wrote the smfGetOptionQuotes() function, I created a
verbiage based option symbol and then have the add-in function convert
it to be what the individual data sources need. It also allows the
options symbol to be what people typically SAY when describing an
option, so it's self-documenting. For example, to get the bid price for
said option from OptionsXPress, you could use either of:

=smfGetOptionQuotes("IBM 2/18 2012 $185 Call","b",,"OX")
=smfGetOptionQuotes("IBM Feb 2012 $185 Call","b",,"OX")

I note you didn't indicate which function you are using when getting
nothing back, so it could be you are trying to use the
RCHGetYahooQuotes() function. Yahoo used to return option quotes via
their CSV interface. However, they stopped providing the quotes there
when the new option symbology was adopted. Which is one of the reasons I
ended up writing my own function above to get the option quotes.

Other than OptionsXPress (which is actually trading the options, so they
need to be up-to-date and accurate), I find the various sources to be
spotty on coverage, especially on the weekly options. But OptionsXPress
is also the slowest source of the data.

On Fri, Jan 27, 2012 at 3:44 PM, three100mph <three100mph@...> wrote:
Hi, these are great tools and I got the quotes to work for stocks but I
am having trouble with options. Option symbols have now been
standardized with a form like "IBM120218C00185000" for the Feb 18,2012
185 IBM CALL option. When I try to use these types of codes I can get
nothing back of any use. Do you have any ideas on this problem?

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)
Recent Activity
Visit Your Group
Yahoo! News

Get it all here

Breaking news to

entertainment news

Ads on Yahoo!

Learn more now.

Reach customers

searching for you.

Yahoo! Finance

It's Now Personal

Guides, news,

advice & more.

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 02.43

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)