Rabu, 26 Desember 2012

[smf_addin] Digest Number 2446

9 New Messages

Digest #2446
1
AdvFNPrefix change by "Patrick" patrickvb
2a
Data Sources and How to Extract by "rjemery7" rjemery7
2b
Re: Data Sources and How to Extract by "Randy Harmelink" rharmelink
2c
2d
Re: Data Sources and How to Extract by "Randy Harmelink" rharmelink
2e
3a
Retrieving Beta by "rjemery7" rjemery7
3b
Re: Retrieving Beta by "Randy Harmelink" rharmelink

Messages

Tue Dec 25, 2012 7:39 am (PST) . Posted by:

"Patrick" patrickvb


Hi Randy,

Thanks for your great  addin!

There is some change  in ADVFN, the place of the national AdvFNPrefix
change for the foreigner.

I've adapt your code

FROM

sURL ="http://" sAdvFNPrefix ".advfn.com/p.php?pid=financials" "="
sTicker sLabel1

INTO

sURL ="http://www.advfn.com/fr/p.php?pid=financials" "=" sTicker
sLabel1

 Could you adapt your code?

Happy NewYear,

Patrick.

Tue Dec 25, 2012 10:33 am (PST) . Posted by:

"rjemery7" rjemery7

1) For a given symbol, from where and how can I include from Standard & Poor's their:

a) GICS Sector and Sub-Industry information
b) Beta
c) STARS, Credit and Quality Ratings
d) Qualitative Risk Assessment
e) Relative Strength Rank
f) Fair Value Rank
g) Fair Value Calculation
h) etc.

in my spreadsheets using RCH or SMF functions?

2) How can I extract information from http://finviz.com/quote.ashx?t=[SYMBOL]

3) From where and how can I get recent dividend history (for example, last 16 quarters with date paid)? Some equities, like Realty Income (O), pay a monthly dividend, which is yet a different case.

Tue Dec 25, 2012 10:53 am (PST) . Posted by:

"Randy Harmelink" rharmelink

For (1), I think those are proprietary. I don't know of a source from which
I could extract them.

For (2), there are two items that discuss it in the LINKS area of the group.

For (3), check out the RCHGetYahooHistory() function. But it only has
ex-dividend dates.

On Tue, Dec 25, 2012 at 11:33 AM, rjemery7 <rjemery@gmail.com> wrote:

> 1) For a given symbol, from where and how can I include from Standard &
> Poor's their:
>
> a) GICS Sector and Sub-Industry information
> b) Beta
> c) STARS, Credit and Quality Ratings
> d) Qualitative Risk Assessment
> e) Relative Strength Rank
> f) Fair Value Rank
> g) Fair Value Calculation
> h) etc.
>
> in my spreadsheets using RCH or SMF functions?
>
> 2) How can I extract information from
> http://finviz.com/quote.ashx?t=[SYMBOL]
>
> 3) From where and how can I get recent dividend history (for example, last
> 16 quarters with date paid)? Some equities, like Realty Income (O), pay a
> monthly dividend, which is yet a different case.
>

Tue Dec 25, 2012 5:26 pm (PST) . Posted by:

"rjemery7" rjemery7



Do you have a list of websites from which useful stock and/or economic data can be extracted using your functions?

Tue Dec 25, 2012 5:44 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Just take a look at the "Source" column of the EXCEL file distributed with
the add-in. The primary websites most people use have elements defined.

But, really, there are too many to list -- and it depends so much on what
use you put the data to. I even use the add-in to access sites like NetFlix
and IMDB.

On Tue, Dec 25, 2012 at 6:26 PM, rjemery7 <rjemery@gmail.com> wrote:

>
> Do you have a list of websites from which useful stock and/or economic
> data can be extracted using your functions?
>

Tue Dec 25, 2012 6:02 pm (PST) . Posted by:

"rjemery7" rjemery7

Thank you for all your help -- and for writing and making the RCH/SMF functions freely available to all.

Tue Dec 25, 2012 9:36 pm (PST) . Posted by:

"rjemery7" rjemery7

When one visits finance.yahoo.com and enters a symbol, the Beta for the equity is displayed with other financial data. Yet, RCHGetYahooQuotes() lacks a data code for that particular item.

1) Is it undocumented? What other undocumented data codes are valid for RCHGetYahooQuotes()?

2) On the documentation page for RCHGetYahooQuotes(), what does ECN mean?

FWIW, I am able to retrieve Beta by using RCHGetElementNumber(Ticker,972)

Tue Dec 25, 2012 9:52 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Just because the data is on Yahoo doesn't mean that RCHGetYahooQuotes()
will get it. RCHGetYahooQuotes() is an interface for Yahoo's current quotes
CSV file, which has a limited number of data items. It sometimes even has
different values than what you can find on the Yahoo web pages. I don't
know if that's because each have different data sources, or that Yahoo
updates them at different intervals.

There could be undocumented data codes. I only have documented the ones I
know of. I've never seen any official documentation from Yahoo on what is
available.

I believe ECN is now obsolete. I'm not even sure if those data items even
work any more. Their online web pages now use BATS for real time bid/ask
books.

Element 972 comes from Yahoo's Key Statistics page. The advantage of the
CSV file is that you can get multiple data items from multiple ticker
symbols, with just a single Internet access. With most other SMF functions,
like RCHGetElementNumber(), you will have one Internet access per needed
web page. So, if you retrieved beta for 200 stocks, you would need to
retrieve 200 web pages. But to get stock quotes for 200 different ticker
symbols, you can use a single array-entered RCHGetYahooQuotes() function
and get the data with a single Internet access. Much quicker!

And, BTW, note that there is not a universal definition of Beta. If you
retrieve it from different data sources, you may find widely varying
values. So if you're planning to use it, make sure what the definition of
it is from the data source you're using. If you've read an article about
Beta, it may have used a different time frame than Yahoo.

On Tue, Dec 25, 2012 at 10:36 PM, rjemery7 <rjemery@gmail.com> wrote:

> When one visits finance.yahoo.com and enters a symbol, the Beta for the
> equity is displayed with other financial data. Yet, RCHGetYahooQuotes()
> lacks a data code for that particular item.
>
> 1) Is it undocumented? What other undocumented data codes are valid for
> RCHGetYahooQuotes()?
>
> 2) On the documentation page for RCHGetYahooQuotes(), what does ECN mean?
>
> FWIW, I am able to retrieve Beta by using RCHGetElementNumber(Ticker,972)
>

Tue Dec 25, 2012 10:37 pm (PST) . Posted by:

"Pete A" option2z

It does...I use it every day with Excel 2010...and with Win 8 too.
Pete A

--- In smf_addin@yahoogroups.com, rharmelink@... wrote:
>
> As far as I know, the add-in works with EXCEL 2010...
>
> On Mon, Dec 24, 2012 at 10:20 AM, franksemar <franksemar@...> wrote:
>
> > Newbie question - Just getting ready to start loading the add-ins, Ccn I
> > use Excel 2010 or should I back rev to Excel 2007?
> >
>

Tidak ada komentar:

Posting Komentar