Jumat, 31 Januari 2014

[smf_addin] Digest Number 2950

15 New Messages

Digest #2950
1a
Ycharts by gobi5
1b
Re: Ycharts by "Randy Harmelink" rharmelink
1c
Re: Ycharts by "Kermit W. Prather" kermitpra
2a
Re: SMF Get .XLS ? by Charles8839
6b
Re: What did I do wrong? by "Randy Harmelink" rharmelink

Messages

Fri Jan 31, 2014 5:14 am (PST) . Posted by:

gobi5

I'm trying to pull the value in the row marked "Average" from this table "ARCC Dividend Yield (TTM) Range, Past 5 Years" on this page:


http://ycharts.com/companies/ARCC/dividend_yield



I'm using a formula like the below but its not working. Any ideas?


=(RCHGetTableCell("http://ycharts.com/companies/"&A2&"/dividend_yield",1,"Dividend Yield (TTM) Range, Past 5 Years","Average"))

Fri Jan 31, 2014 6:47 am (PST) . Posted by:

"Randy Harmelink" rharmelink

Not sure what to tell you -- your formula worked fine for me...

On Fri, Jan 31, 2014 at 6:14 AM, <cmaxmagee@gmail.com> wrote:

>
> I'm trying to pull the value in the row marked "Average" from this table
> "ARCC Dividend Yield (TTM) Range, Past 5 Years" on this page:
>
> http://ycharts.com/companies/ARCC/dividend_yield
>
> I'm using a formula like the below but its not working. Any ideas?
>
> =(RCHGetTableCell("http://ycharts.com/companies/"&A2&"/dividend_yield",1,"Dividend
> Yield (TTM) Range, Past 5 Years","Average&quot;))
>

Fri Jan 31, 2014 9:14 am (PST) . Posted by:

"Kermit W. Prather" kermitpra

It also worked for me. Hope this helps

Kermit

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of Randy Harmelink
Sent: Friday, January 31, 2014 9:48 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Ycharts


Not sure what to tell you -- your formula worked fine for me...

On Fri, Jan 31, 2014 at 6:14 AM, <cmaxmagee@gmail.com> wrote:

I'm trying to pull the value in the row marked "Average" from this table "ARCC Dividend Yield (TTM) Range, Past 5 Years" on this page:

http://ycharts.com/companies/ARCC/dividend_yield

I'm using a formula like the below but its not working. Any ideas?

=(RCHGetTableCell("http://ycharts.com/companies/"&A2&"/dividend_yield",1,"Dividend Yield (TTM) Range, Past 5 Years","Average&quot;))


Fri Jan 31, 2014 6:49 am (PST) . Posted by:

Charles8839

In the recent example for getting data from Guru Focus, you used ASX:SHV


I'm assuming ASX means American Stock Exchange, can this also be used to get data fir the Nasdaq and the NYSE exchanges as well, and if so what symbol would I use?


Thanks for your response.

Fri Jan 31, 2014 11:20 am (PST) . Posted by:

"Jacob Jose" pepecan47

Randy, it seems there is an error with elements 13935, 13940, 13945, 13950. Looking at smf-elements-4, it is grabbing "Price/Sales" instead of "Dividend Yield %"

I am still with the latest Beta version.

Regards,
Jose L. Jacob

Fri Jan 31, 2014 12:45 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Thanks for the heads-up. I uploaded a corrected smf-elements-4.txt file to
the "Works in Progress" folder.

On Fri, Jan 31, 2014 at 12:20 PM, Jacob Jose <pepecan47@yahoo.ca> wrote:

>
> Randy, it seems there is an error with elements 13935, 13940, 13945,
> 13950. Looking at smf-elements-4, it is grabbing "Price/Sales" instead of
> "Dividend Yield %"
>
> I am still with the latest Beta version.
>
>

Fri Jan 31, 2014 1:35 pm (PST) . Posted by:

"Kermit W. Prather" kermitpra

Those elements are no longer valid. You need the latest version of the
addin.



From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf
Of Jacob Jose
Sent: Friday, January 31, 2014 2:21 PM
To: smf_addin
Subject: [smf_addin] M* Dividend yields elements 13935, 13940, 13945, 13950


Randy, it seems there is an error with elements 13935, 13940, 13945, 13950.
Looking at smf-elements-4, it is grabbing "Price/Sales" instead of "Dividend
Yield %"

I am still with the latest Beta version.

Regards,
Jose L. Jacob

Fri Jan 31, 2014 1:38 pm (PST) . Posted by:

matthewpaulreid

Do we need to reinstall the add-in now that you have updated it?

Fri Jan 31, 2014 1:41 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Only if you want the updates...

Best practice is to exit EXCEL, download the file, unzip *all* files into
the add-in's folder, replacing files as needed.

On Fri, Jan 31, 2014 at 2:23 PM, <matthewpaulreid@gmail.com> wrote:

> Do we need to reinstall the add-in now that you have updated it?
>

Fri Jan 31, 2014 7:10 pm (PST) . Posted by:

"PC_BABE" cs.holdings

Thanks Randy

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of rharmelink@gmail.com
Sent: Thursday, January 30, 2014 1:36 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] New official release of the add-in -- version 2.1.2014.01.30

I just uploaded a new official version of the add-in ZIP archive. It contains all the latest element definitions, as well as several new functions and fixed functions. I had been holding off on a new official release, waiting until AdvFN changed over to the new "Beta" format. But, given AdvFN's change process, that may take a while...

Changes made to the add-in since the 2012-12-29 release:

Date

Routine

Description

2013-01-04

smfGetMSNOptionQuote
smfGetOXOptionQuote
smfGetYahooOptionQuote

Remove day 1, 30, and 31 assumptions for option expiration date (because weekly options can fall on those days)

2013-01-06

smfGetOptionExpirations

Modified Yahoo processing to pick up expiration dates from Yahoo's API feed (a complete list)

2013-02-06

smfGetOptionQuotes
smfGetYahooOptionQuotes

Add workaround to fix the Yahoo "^VIX" / "VIX" issue

2013-03-02

smfGetBigChartsOptionQuote

New function to get current and historical option quotes from bigcharts.com

2013-03-13

RCHGetElementNumber

Fixed definition of element #13873 to pick up 2-word recommendations (i.e. "Strong Buy")

2013-03-16

RCHGetElementNumber

Fixed elements #13774-13776, "5-yr avg effective tax rates" from Reuters

2013-05-20

RCHGetElementNumber

Changed element #1285 (Yahoo next earnings date) to pick the date up from Yahoo's main quote page (smf-elements-2.txt)

2013-05-20

RCHGetElementNumber

Obsoleted StockCharts P&F elements #1513-#1515 because they no longer offer a text P&F chart (smf-elements-9.txt)

2013-06-03

smfGetOptionQuotes
smfGetYahooOptionQuote

Allow mini-options to be retrieved from Yahoo by appending a "7" to the end of the ticker symbol (i.e. AAPL7)

2013-06-19

RCHGetElementNumber

Changed element #13862, MSN -- Company Name, on smf-elements-1.txt

2013-06-28

smfGetOptionQuotes
smfGetYahooOptionQuote

Expanded mini-option processing to include special adjusted options as well (i.e. numeric right-side character on ticker symbol)

2013-07-06

RCHGetElementNumber

Fixed ETFScreen element definitions in file smf-element-9.txt (changed http://etfscreen.com to http://www.etfscreen.com)

2013-09-29

RCHGetElementNumber

Changed elements #253-#352, on smf-elements-1.txt, because MSN changed the sort order on a few of the 10-year summary tables.

2013-10-16

smfGetAdvFNElement

Changed this routine to use the new AdvFN web site structure

2013-10-17

smfGetAdvFNElement

Additional fix of above change

2013-11-04

RCHGetElementNumber

Updated almost every Zacks element definition, on smf-elements-6.txt, because Zacks rearranged the content of their web pages. Also added several new elements (Beta, Next Earnings Date, etc).

2013-11-04

RCHGetElementNumber

Standardized the format of all obsolete element definitions

2013-11-04

RCHGetElementNumber

Changed all "evaluate"; element defintions to regular formulas

2013-11-05

RCHGetElementNumber

General updates based on review of all element definitions

2013-11-05

RCHGetElementNumber

Replaced the earnings.com earnings announcement element definitions, #1286 thru #1400, with element definitions from Zacks.

2013-11-06

RCHGetElementNumber

Reinstated obsolete elements #13931-#14057, on smf-elements-4.txt, to pull valuation ratios from static MorningStar web pages.

2013-11-06

RCHGetElementNumber

Reinstated obsolete elements #14058-#14343, on smf-elements-4.txt, to pull key ratios from static MorningStar web pages.

2013-11-14

RCHGetElementNumber

Update/added some MorningStar "Take" and "Profile" element definitions, #877-#891, to smf-elements-4.txt.

2013-12-21

smfGetMSNOptionQuote
smfGetYahooOptionQuote

Fixed so that "Put" and "Call" strings can be passed as parameters instead of just "P" and "C".

2014-01-14

RCHGetYahooQuotes

Use "XXXXXX" as a placeholder symbol where spaces are found in the passed ticker array

2014-01-30

RCHGetElementNumber

Update element #884 on smf-elements-4.txt. MorningStar moved the item to a different web page.

Fri Jan 31, 2014 1:47 pm (PST) . Posted by:

adam_sommers

Thank you, Randy for the updated version. But now that I've installed it, my SMFGetYahooOptionQuote function is no longer working when I refer to a strike price in a cell that is formatted as number or currency.


I can get it to work if I put "OTM1" in the formula, but if I put in a cell reference for the strike of a Put, it generates "Error".'


Here is my formula: =smfGetYahooOptionQuote(D16,"P",DATE(YEAR($E$1),MONTH($E$1),DAY($E$1)),H16,"a"


Do you know why this is happening, and can it be fixed?

Fri Jan 31, 2014 2:18 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

How a cell is formatted should be irrelevant. And whether it's a cell
reference or a number or a literal should be irrelevant. An EXCEL (or
user-defined) function would only use the value of the parameter.

Without knowing your cell values, I have no details to look at.

I just tried an example with both the literal "OTM1" and a cell with the
value of "OTM1". Both worked fine for
me. I even added a numeric format on the "OTM1" cell value.

But I will mentions that "OTMx" and "ITMx" are unreliable with Yahoo on web
page where they combine multiple expiration dates. It can also be
unreliable on equities with a small number of options, since the ITM/OTM
decisions key off of the shading Yahoo uses. So if there is no change in
shading, the function will fail.

I always use smfGetOptionStrikes() to determine my ITM and OTM strike
prices.

I probably should obsolete the "ITMx" and "OTMx" designations. Or change
them to use the smfGetOptionStrikes() function instead -- which would allow
it to be done for all sources, but slow down data retrieval times.

On Fri, Jan 31, 2014 at 2:47 PM, <adam@sommersfinancial.com> wrote:

>
> Thank you, Randy for the updated version. But now that I've installed it,
> my SMFGetYahooOptionQuote function is no longer working when I refer to a
> strike price in a cell that is formatted as number or currency.
>
> I can get it to work if I put "OTM1" in the formula, but if I put in a
> cell reference for the strike of a Put, it generates "Error".'
>
> Here is my formula:
> =smfGetYahooOptionQuote(D16,"P",DATE(YEAR($E$1),MONTH($E$1),DAY($E$1)),H16,"a"
>
> Do you know why this is happening, and can it be fixed?
>

Fri Jan 31, 2014 3:30 pm (PST) . Posted by:

tonyestep

Hi Randy,


Okay, in the Members Uploads folder I put a file called test.xslx. It gets the quotes fine when I use it with the SMF version from 1/1/2009, but when used with the newest version it gets confused as shown in my earlier post. I didn't try every newer version, but the same thing happens with some of the 2012 versions. So something must have changed way back in time that I didn't catch. Thanks again,
Tony Estep

Fri Jan 31, 2014 4:44 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Your problem is the "Z85-L.T. TREND" string that you have in cell J1.
That's part of your B1:M1 range of Yahoo codes. Delete that and all is well.

I'm not sure what changed and caused that to become an issue, but it's not
expected... :)

On Fri, Jan 31, 2014 at 4:30 PM, <tonyestep@yahoo.com> wrote:

> Okay, in the Members Uploads folder I put a file called test.xslx. It
> gets the quotes fine when I use it with the SMF version from 1/1/2009, but
> when used with the newest version it gets confused as shown in my earlier
> post. I didn't try every newer version, but the same thing happens with
> some of the 2012 versions. So something must have changed way back in time
> that I didn't catch. Thanks again,
>

Fri Jan 31, 2014 6:47 pm (PST) . Posted by:

tonyestep

THANKS, Randy! I put that up there as a note to myself, year ago, and for whatever reason it didn't clobber the quote fetching process until I updated. Thanks so much for taking the time to spot this!


Tony
READ MORE....