Messages
Sat Apr 21, 2018 3:20 am (PDT) . Posted by:
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'
many thanks randy
Sat Apr 21, 2018 7:54 pm (PDT) . Posted by:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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.
>
>
>
