Kamis, 26 April 2018

[smf_addin] Digest Number 4326[1 Attachment]

15 Messages

Digest #4326
2a
Re: Yahoo Earnings Growth by thealphainvestor
3a
3b
Re: Euro/Dollar exchange rate from Yahoo by "Randy Harmelink" rharmelink
4a
Yahoo 30 year US Bond Yield by "Leo Bueno" leobueno
4b
Yahoo 30 year US Bond Yield by "Leo Bueno" leobueno
4c
Re: Yahoo 30 year US Bond Yield by "Jose Jacob" pepecan47
6a
Functions by nautilustech
6b
Re: Functions by "Randy Harmelink" rharmelink
8b
Re: Insider Transactions table from Gurufocus by "Randy Harmelink" rharmelink
9b

Messages

Sat Apr 21, 2018 3:20 am (PDT) . Posted by:

patrickvb

Hi,

 just a little change http => https

RCHGetTableCell("https://quotes.wsj.com/ID/XIDX/SMDR/financials/Quarter/Income-Statement",5,"Net Income After Extraordinaries<")

WSJ offers an historic of 5 years and 5 quarters of data

Patrick

De : sri.yanto@yahoo.com [smf_addin] <smf_addin@yahoogroups.com>
À : smf_addin@yahoogroups.com
Objet : [smf_addin] no longer can extract from wsj
Date : 19/04/2018 05:12:47 CEST

 

haii randy.

i have an issue with wsj website.

2 days ago i found myself, can not any longer extract any data from wsj.com

is there any problem with the website or there is any changes with wsj randy?

here the link :

https://quotes.wsj.com/ID/XIDX/SMDR/financials/annual/income-statement

here im using smf :

 RCHGetTableCell("http://quotes.wsj.com/ID/XIDX/SMDR/financials/Quarter/Income-Statement",5,"Net Income After Extraordinaries<")

its return "error&#39;

many thanks randy 

Sat Apr 21, 2018 7:54 pm (PDT) . Posted by:

thealphainvestor

Randy,

You are a genius. Thank you so much. This was putting a hamper on some of my Fundamental Analysis work. Now I can get back to some real due diligence..


Thanks for all you do!


Bruce

Mon Apr 23, 2018 12:57 pm (PDT) . Posted by:

"Leo Bueno" leobueno


This

=RCHGetYahooQuotes($A33&B$29&"=X","l1")

used to work but no longer.

Please let me know call and parameters for Euros.

Thanks.


Leo Bueno
305-669-5260
1825 Ponce de Leon Boulevard # 483
Coral Gables, FL 33134
Leo@BuenoLaw.com<mailto:Leo@BuenoLaw.com>
Skype: BuenoLaw

[cid:image001.png@01D1E033.9E0A3CC0]


Mon Apr 23, 2018 1:52 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

RCHGetYahooQuotes() has been dead for months now, ever since Yahoo
unplugged their API that fed it. See:

https://smf-add-in.blogspot.com/2017/11/alert-official-notice-by-yahoo.html

The replacement is the new smfGetYahooPortfolioView() function. Template
and documentation are available on the website.

On Mon, Apr 23, 2018 at 12:57 PM, Leo Bueno Leo@
​...
wrote:

>
>
> This
>
>
>
> =RCHGetYahooQuotes($A33&B$29&"=X","l1")
>
>
>
> used to work but no longer.
>
>
>
> Please let me know call and parameters for Euros.
>
>
>
>
>

Mon Apr 23, 2018 1:11 pm (PDT) . Posted by:

"Leo Bueno" leobueno

In the old days, this would work, but no more:

=RCHGetYahooQuotes("^TYX","l1")/100

Will appreciate y'all pointing me to the right function parameters.


Leo Bueno
305-669-5260
1825 Ponce de Leon Boulevard # 483
Coral Gables, FL 33134
Leo@BuenoLaw.com<mailto:Leo@BuenoLaw.com>
Skype: BuenoLaw

[cid:image001.png@01D1E033.9E0A3CC0]



Mon Apr 23, 2018 1:23 pm (PDT) . Posted by:

"Leo Bueno" leobueno

In the old days, this would work, but no more:

=RCHGetYahooQuotes("^TYX","l1")/100

Will appreciate y'all pointing me to the right function parameters.


Leo Bueno
305-669-5260
1825 Ponce de Leon Boulevard # 483
Coral Gables, FL 33134
Leo@BuenoLaw.com<mailto:Leo@BuenoLaw.com>
Skype: BuenoLaw

[cid:image001.png@01D1E033.9E0A3CC0]



Mon Apr 23, 2018 8:16 pm (PDT) . Posted by:

"Jose Jacob" pepecan47

For the 10 Year Treasury I use
=smfGetYahooPortfolioView("^TNX", "15")/100
For 30 year Treasury, I think, the ticker is "^TYX"
 Regards, Jose L. Jacob

On Monday, April 23, 2018 4:35 PM, "Leo Bueno Leo@BuenoLaw.com [smf_addin]" <smf_addin@yahoogroups.com> wrote:


  In the old days, this would work, but no more:   =RCHGetYahooQuotes("^TYX","l1")/100   Will appreciate y'all pointing me to the right function parameters.    
| Leo Bueno
305-669-5260
1825 Ponce de Leon Boulevard # 483
Coral Gables, FL 33134
Leo@BuenoLaw.com
Skype: BuenoLaw | |

    #yiv2637097544 #yiv2637097544 -- #yiv2637097544ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv2637097544 #yiv2637097544ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv2637097544 #yiv2637097544ygrp-mkp #yiv2637097544hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv2637097544 #yiv2637097544ygrp-mkp #yiv2637097544ads {margin-bottom:10px;}#yiv2637097544 #yiv2637097544ygrp-mkp .yiv2637097544ad {padding:0 0;}#yiv2637097544 #yiv2637097544ygrp-mkp .yiv2637097544ad p {margin:0;}#yiv2637097544 #yiv2637097544ygrp-mkp .yiv2637097544ad a {color:#0000ff;text-decoration:none;}#yiv2637097544 #yiv2637097544ygrp-sponsor #yiv2637097544ygrp-lc {font-family:Arial;}#yiv2637097544 #yiv2637097544ygrp-sponsor #yiv2637097544ygrp-lc #yiv2637097544hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2637097544 #yiv2637097544ygrp-sponsor #yiv2637097544ygrp-lc .yiv2637097544ad {margin-bottom:10px;padding:0 0;}#yiv2637097544 #yiv2637097544actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2637097544 #yiv2637097544activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2637097544 #yiv2637097544activity span {font-weight:700;}#yiv2637097544 #yiv2637097544activity span:first-child {text-transform:uppercase;}#yiv2637097544 #yiv2637097544activity span a {color:#5085b6;text-decoration:none;}#yiv2637097544 #yiv2637097544activity span span {color:#ff7900;}#yiv2637097544 #yiv2637097544activity span .yiv2637097544underline {text-decoration:underline;}#yiv2637097544 .yiv2637097544attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv2637097544 .yiv2637097544attach div a {text-decoration:none;}#yiv2637097544 .yiv2637097544attach img {border:none;padding-right:5px;}#yiv2637097544 .yiv2637097544attach label {display:block;margin-bottom:5px;}#yiv2637097544 .yiv2637097544attach label a {text-decoration:none;}#yiv2637097544 blockquote {margin:0 0 0 4px;}#yiv2637097544 .yiv2637097544bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv2637097544 .yiv2637097544bold a {text-decoration:none;}#yiv2637097544 dd.yiv2637097544last p a {font-family:Verdana;font-weight:700;}#yiv2637097544 dd.yiv2637097544last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv2637097544 dd.yiv2637097544last p span.yiv2637097544yshortcuts {margin-right:0;}#yiv2637097544 div.yiv2637097544attach-table div div a {text-decoration:none;}#yiv2637097544 div.yiv2637097544attach-table {width:400px;}#yiv2637097544 div.yiv2637097544file-title a, #yiv2637097544 div.yiv2637097544file-title a:active, #yiv2637097544 div.yiv2637097544file-title a:hover, #yiv2637097544 div.yiv2637097544file-title a:visited {text-decoration:none;}#yiv2637097544 div.yiv2637097544photo-title a, #yiv2637097544 div.yiv2637097544photo-title a:active, #yiv2637097544 div.yiv2637097544photo-title a:hover, #yiv2637097544 div.yiv2637097544photo-title a:visited {text-decoration:none;}#yiv2637097544 div#yiv2637097544ygrp-mlmsg #yiv2637097544ygrp-msg p a span.yiv2637097544yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv2637097544 .yiv2637097544green {color:#628c2a;}#yiv2637097544 .yiv2637097544MsoNormal {margin:0 0 0 0;}#yiv2637097544 o {font-size:0;}#yiv2637097544 #yiv2637097544photos div {float:left;width:72px;}#yiv2637097544 #yiv2637097544photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv2637097544 #yiv2637097544photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv2637097544 #yiv2637097544reco-category {font-size:77%;}#yiv2637097544 #yiv2637097544reco-desc {font-size:77%;}#yiv2637097544 ..yiv2637097544replbq {margin:4px;}#yiv2637097544 #yiv2637097544ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv2637097544 #yiv2637097544ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv2637097544 #yiv2637097544ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv2637097544 #yiv2637097544ygrp-mlmsg select, #yiv2637097544 input, #yiv2637097544 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv2637097544 #yiv2637097544ygrp-mlmsg pre, #yiv2637097544 code {font:115% monospace;}#yiv2637097544 #yiv2637097544ygrp-mlmsg * {line-height:1.22em;}#yiv2637097544 #yiv2637097544ygrp-mlmsg #yiv2637097544logo {padding-bottom:10px;}#yiv2637097544 #yiv2637097544ygrp-msg p a {font-family:Verdana;}#yiv2637097544 #yiv2637097544ygrp-msg p#yiv2637097544attach-count span {color:#1E66AE;font-weight:700;}#yiv2637097544 #yiv2637097544ygrp-reco #yiv2637097544reco-head {color:#ff7900;font-weight:700;}#yiv2637097544 #yiv2637097544ygrp-reco {margin-bottom:20px;padding:0px;}#yiv2637097544 #yiv2637097544ygrp-sponsor #yiv2637097544ov li a {font-size:130%;text-decoration:none;}#yiv2637097544 #yiv2637097544ygrp-sponsor #yiv2637097544ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv2637097544 #yiv2637097544ygrp-sponsor #yiv2637097544ov ul {margin:0;padding:0 0 0 8px;}#yiv2637097544 #yiv2637097544ygrp-text {font-family:Georgia;}#yiv2637097544 #yiv2637097544ygrp-text p {margin:0 0 1em 0;}#yiv2637097544 #yiv2637097544ygrp-text tt {font-size:120%;}#yiv2637097544 #yiv2637097544ygrp-vital ul li:last-child {border-right:none !important;}#yiv2637097544

Attachment(s) from Jose Jacob
1 of 1 Photo(s)

Mon Apr 23, 2018 1:48 pm (PDT) . Posted by:

loudnumber

Randy and company,


Hi. My name is Kevin Chung and I have been a lurker on this site for years. And like most of you, I've found Randy's spreadsheet tool to be most useful and I was most appreciative of his efforts to maintain the tool for free. Of course, things became more and more challenging as sites such as MSN started to reduce their data offering. So I left and subscribed to a data service. And started to work with analytics tools beyond Excel. To make this short, I've launched a website that does machine learning based DCF, Mr. Market normal prices, 13F tracking/analysis, and financial data visualization. If you were using SMF_addin for any of the above, my site is only $99 a year. I have a fully functioning demo with Dow 30 stocks. Again, I apologize for the shameless plug, but I thought it would be of interest. The site is www.loudnumber.com http://www.loudnumber.com. Thank you.


Kevin


Mon Apr 23, 2018 2:05 pm (PDT) . Posted by:

nautilustech

I'm going to reveal my complete ignorance.

What's the difference between the functions GetWebData, GetHTMLTableCell, GetTagContent, & when should I use them?

Many thanks.


Mon Apr 23, 2018 2:20 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

RCHGetTableCell() would be used to extract data out of the cell of a coded
HTML table.

smfGetTagContent() would be used to extract data out of a coded HTML tag
(which could be a table cell). This function almost obsoletes
RCHGetTableCell(), since it is just a more general version that applies to
any pair of HTML tags.

RCHGetWebData() directly retrieves the source code of the web page, so you
can do custom extractions, usually unrelated to HTML tags.

Which one to use depends on how the web page is coded, and how it presents
the data. These days, I start with smfGetTagContent() and then go to
RCHGetWebData() if that can't do the trick. RCHGetWebData() is best used in
cascading extractions -- where patterns of the HTML code contain multiple
data items of the same type on the web page. For example, a search result
on Amazon that lists 60 different books on the web page.

I often play with the various worksheets
in SMF-Quick-Webpage-Examination.xls to get an idea of ways to extract data
from a given data source.

On Mon, Apr 23, 2018 at 2:03 PM, nautilustech@
​...
wrote:

>
> I'm going to reveal my complete ignorance.
>
> What's the difference between the functions GetWebData, GetHTMLTableCell,
> GetTagContent, & when should I use them?
>
>

Thu Apr 26, 2018 3:39 am (PDT) . Posted by:

lawleesh

Hi Randy


Is there a way to grab guru latest trades from https://www.gurufocus.com/gurutrades/AAPL https://www.gurufocus.com/gurutrades/AAPL


and insider transactions from https://www.gurufocus.com/insider/AAPL https://www.gurufocus.com/insider/AAPL


thanks

Thu Apr 26, 2018 4:13 am (PDT) . Posted by:

lawleesh

Hi Randy


Is there a way to grab insider transactions table from https://www.gurufocus.com/insider/AAPL https://www.gurufocus.com/insider/AAPL
and Gurus latest trades from https://www.gurufocus.com/gurutrades/AAPL https://www.gurufocus.com/gurutrades/AAPL


thanks



Thu Apr 26, 2018 11:15 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Insider transactions:

=RCHGetHTMLTable("https://www.gurufocus.com/insider/AAPL",">Shares owned")

The Guru Trades table is dynamically built from a JSON file and would need
to be extracted individually from it:

=RCHGetWebData("https://www.gurufocus.com/classes/screener/gurutrades/AAPL?
length=500",,,,3)

Not a trivial task. It appears that 500 trades is the limit for that method?

On Thu, Apr 26, 2018 at 3:32 AM, lawrence.leesh@
​...
wrote:

> Is there a way to grab insider transactions table from
> https://www.gurufocus.com/insider/AAPL
>
> and Gurus latest trades from https://www.gurufocus.com/gurutrades/AAPL
>
>
>

Thu Apr 26, 2018 10:49 am (PDT) . Posted by:

nmalhotr

Randy:
I am having options data being updated for several tickers:


For example EBAY190118C00018000
The Yahoo Finance page shows last trade, bid, ask, at 21.07, 20.60, 21.15..


The same data in my array for fields (15, 20, 22) shows up as 23.5, 22.3, 24.3, respectively.


Having similar problems with other symbols too.


Not sure if you are seeing the same.


Thanks


NM



Thu Apr 26, 2018 11:29 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

I've seen something like that on one of the option ticker symbols I use.
It's a Yahoo issue. As far as I can tell, even the Yahoo web page itself
can't be valid. For example, for your EBAY190118C00018000 symbol, it says "As
of April 23 3:10PM EDT" even though it's currently "April 26 2:19PM EDT".

Mine currently has nearly a zero value (down from a $0.30 purchase price),
but from time to time it shows up with an $8 price. I got real excited the
first time I saw it. :(

For some reason, it sometimes has stale data for options. I'm assuming one
or more servers aren't getting price updates, so when a request is fed from
those servers, it serves up the old data.

On Thu, Apr 26, 2018 at 10:10 AM, namit98@
​...
wrote:

> I am having options data being updated for several tickers:
>
> For example EBAY190118C00018000
>
> The Yahoo Finance page shows last trade, bid, ask, at 21.07, 20.60,
> 21.15.
>
> The same data in my array for fields (15, 20, 22) shows up as 23.5, 22..3,
> 24.3, respectively.
>
> Having similar problems with other symbols too.
>
> Not sure if you are seeing the same.
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Diposting oleh EXCEL FEED LEARNING di 11.29

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)