13 Messages
Digest #4238
Messages
Tue Nov 14, 2017 7:53 pm (PST) . Posted by:
"Matthew Crowe" mpcrowe2
Has anyone been having a problem with data retrieval from smfGetBarchartPortfolioView? When I run smfGetBarchartPortfolioView-Example the header fields seem to be rendering exactly as expected but the rest of the array data is all blank --, making me think it could be an issue/change with Barchart and not necessarily the smf function.
Amazing work on these new enhancements, Randy - thanks!
Amazing work on these new enhancements, Randy - thanks!
Tue Nov 14, 2017 9:15 pm (PST) . Posted by:
ehrlichk
Deleting None in the first symbol cell worked for me. After I did that the spreadsheet wrked perfectly.
Wed Nov 15, 2017 10:03 am (PST) . Posted by:
"Matthew Crowe" mpcrowe2
That worked for me as well, thank you.
On Tuesday, November 14, 2017, 11:36:49 PM CST, ehrlichk@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
Deleting None in the first symbol cell worked for me. After I did that the spreadsheet wrked perfectly.
#yiv1684402145 #yiv1684402145 -- #yiv1684402145ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv1684402145 #yiv1684402145ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv1684402145 #yiv1684402145ygrp-mkp #yiv1684402145hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv1684402145 #yiv1684402145ygrp-mkp #yiv1684402145ads {margin-bottom:10px;}#yiv1684402145 #yiv1684402145ygrp-mkp .yiv1684402145ad {padding:0 0;}#yiv1684402145 #yiv1684402145ygrp-mkp .yiv1684402145ad p {margin:0;}#yiv1684402145 #yiv1684402145ygrp-mkp .yiv1684402145ad a {color:#0000ff;text-decoration:none;}#yiv1684402145 #yiv1684402145ygrp-sponsor #yiv1684402145ygrp-lc {font-family:Arial;}#yiv1684402145 #yiv1684402145ygrp-sponsor #yiv1684402145ygrp-lc #yiv1684402145hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv1684402145 #yiv1684402145ygrp-sponsor #yiv1684402145ygrp-lc .yiv1684402145ad {margin-bottom:10px;padding:0 0;}#yiv1684402145 #yiv1684402145actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv1684402145 #yiv1684402145activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv1684402145 #yiv1684402145activity span {font-weight:700;}#yiv1684402145 #yiv1684402145activity span:first-child {text-transform:uppercase;}#yiv1684402145 #yiv1684402145activity span a {color:#5085b6;text-decoration:none;}#yiv1684402145 #yiv1684402145activity span span {color:#ff7900;}#yiv1684402145 #yiv1684402145activity span .yiv1684402145underline {text-decoration:underline;}#yiv1684402145 .yiv1684402145attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv1684402145 .yiv1684402145attach div a {text-decoration:none;}#yiv1684402145 .yiv1684402145attach img {border:none;padding-right:5px;}#yiv1684402145 .yiv1684402145attach label {display:block;margin-bottom:5px;}#yiv1684402145 .yiv1684402145attach label a {text-decoration:none;}#yiv1684402145 blockquote {margin:0 0 0 4px;}#yiv1684402145 .yiv1684402145bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv1684402145 .yiv1684402145bold a {text-decoration:none;}#yiv1684402145 dd.yiv1684402145last p a {font-family:Verdana;font-weight:700;}#yiv1684402145 dd.yiv1684402145last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv1684402145 dd.yiv1684402145last p span.yiv1684402145yshortcuts {margin-right:0;}#yiv1684402145 div.yiv1684402145attach-table div div a {text-decoration:none;}#yiv1684402145 div.yiv1684402145attach-table {width:400px;}#yiv1684402145 div.yiv1684402145file-title a, #yiv1684402145 div.yiv1684402145file-title a:active, #yiv1684402145 div.yiv1684402145file-title a:hover, #yiv1684402145 div.yiv1684402145file-title a:visited {text-decoration:none;}#yiv1684402145 div.yiv1684402145photo-title a, #yiv1684402145 div.yiv1684402145photo-title a:active, #yiv1684402145 div.yiv1684402145photo-title a:hover, #yiv1684402145 div.yiv1684402145photo-title a:visited {text-decoration:none;}#yiv1684402145 div#yiv1684402145ygrp-mlmsg #yiv1684402145ygrp-msg p a span.yiv1684402145yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv1684402145 .yiv1684402145green {color:#628c2a;}#yiv1684402145 .yiv1684402145MsoNormal {margin:0 0 0 0;}#yiv1684402145 o {font-size:0;}#yiv1684402145 #yiv1684402145photos div {float:left;width:72px;}#yiv1684402145 #yiv1684402145photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv1684402145 #yiv1684402145photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv1684402145 #yiv1684402145reco-category {font-size:77%;}#yiv1684402145 #yiv1684402145reco-desc {font-size:77%;}#yiv1684402145 .yiv1684402145replbq {margin:4px;}#yiv1684402145 #yiv1684402145ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv1684402145 #yiv1684402145ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv1684402145 #yiv1684402145ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv1684402145 #yiv1684402145ygrp-mlmsg select, #yiv1684402145 input, #yiv1684402145 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv1684402145 #yiv1684402145ygrp-mlmsg pre, #yiv1684402145 code {font:115% monospace;}#yiv1684402145 #yiv1684402145ygrp-mlmsg * {line-height:1.22em;}#yiv1684402145 #yiv1684402145ygrp-mlmsg #yiv1684402145logo {padding-bottom:10px;}#yiv1684402145 #yiv1684402145ygrp-msg p a {font-family:Verdana;}#yiv1684402145 #yiv1684402145ygrp-msg p#yiv1684402145attach-count span {color:#1E66AE;font-weight:700;}#yiv1684402145 #yiv1684402145ygrp-reco #yiv1684402145reco-head {color:#ff7900;font-weight:700;}#yiv1684402145 #yiv1684402145ygrp-reco {margin-bottom:20px;padding:0px;}#yiv1684402145 #yiv1684402145ygrp-sponsor #yiv1684402145ov li a {font-size:130%;text-decoration:none;}#yiv1684402145 #yiv1684402145ygrp-sponsor #yiv1684402145ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv1684402145 #yiv1684402145ygrp-sponsor #yiv1684402145ov ul {margin:0;padding:0 0 0 8px;}#yiv1684402145 #yiv1684402145ygrp-text {font-family:Georgia;}#yiv1684402145 #yiv1684402145ygrp-text p {margin:0 0 1em 0;}#yiv1684402145 #yiv1684402145ygrp-text tt {font-size:120%;}#yiv1684402145 #yiv1684402145ygrp-vital ul li:last-child {border-right:none !important;}#yiv1684402145
On Tuesday, November 14, 2017, 11:36:49 PM CST, ehrlichk@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
Deleting None in the first symbol cell worked for me. After I did that the spreadsheet wrked perfectly.
#yiv1684402145 #yiv1684402145 -- #yiv1684402145ygrp-
Wed Nov 15, 2017 10:46 am (PST) . Posted by:
ridgebacksexcel
Randy,
I seem to be having trouble getting the RCHGetTablecell Function to lookup a table for me on yCharts.
I am looking for the EV/EBITDA of AAPL, currently 12.03 on the top of the table below.
I am using: =RCHGetTableCell("https://ycharts.com/companies/AAPL/ev_ebitda",1,"Data for this Date Range") but it pulls up "" 2 and 3 are an error.
Any thoughts on what I am doing wrong here? I bolded the font I am interested in below.
Thanks.
<h1 id="pgName" class="floatLVal tight">Apple EV to EBITDA (TTM):</h1><span id="pgNameVal">12.03 for Nov. 14, 2017</span>
<div class="clear"></div>
<!-- metricDropdown will render html here -->
<div id="metricDropdownControl" ng-controller="MetricDropdownCtrl">
<div class="metricSearch">
<div class="uiLbl">View 4,000+ financial data types</div>
<div yc-autocomplete
input-class="txt metricTxt smlTxt"
input-placeholder="Search"
block-invalid-input="true"
select-first="true"
submit-class="submit smlSubmit metricSubmit"
submit-label="Add"
submit-handler = "metricComplete(object, input)"
result-type = "list"
result-class="searchAutoComp metrics"
search-type="stock_history_calc"
></div>
<a class="smlBut" ng-click="$broadcast('showMetricPopup')">Browse...</a>
<div yc-metric-popup
menu-structure="metricMenu"
search-type="stock_history_calc"
select-metric-handler="metricSelect(metric, featureNeeded)"
show-popup-event-name="showMetricPopup"
yc-popup-helper
></div>
</div>
</div>
<!-- Chart section -->
<div class="box boxData" ng-controller="ChartCtrl">
<a href="http://ycharts.com/companies/AAPL/chart/#/?useHttps=false&startDate=&securities=id:AAPL,include:true,,&legendOnChart=&displayTicker=&scaleType="es=&units=&securitylistName=&recessions=false&endDate=&zoom=5&useEstimates=&securityGroup=&calcs=id:ev_ebitda,include:true,,&maxPoints=&securitylistSecurityId=&source=&splitType="eLegend=&partner=¬e=&title=&correlations=&format=real" class="sectHedLink";>View Full Chart</a>
<h2 class="sectHed">Apple EV to EBITDA (TTM) Chart </h2>
<div id="dataChartWrapAll">
<div id="chartCtrls">
<div yc-chart-zoom
selected-zoom="chartInfo.zoom"
zoom-options="zoomOptions"
zoom-change-handler="zoomChange(zoom)">
</div>
<div class="chartButsProData">
<div ng-cloak
yc-chart-export-data
export-handler="dataExport()">
Export Data
</div>
<div ng-cloak
yc-chart-export-image
action="Save"
image-url="chartUrls.imageUrl">
Save Image
</div>
<div ng-cloak
yc-chart-export-image
action="Print"
image-url="chartUrls.imageUrl">
Print Image
</div>
</div>
<div class="clear"></div>
</div>
<div id="dataChart">
<div id="fullChartLink">
For advanced charting, view our full-featured
<a href="/companies/AAPL/chart/">Fundamental Chart</a>
</div>
<div
yc-fundamental-chart
chart-id='dataChartCanvas'
chart-options="chartOptions"
chart-data-url="chartUrls.dataUrl"
clickable="true">
</div>
</div>
</div>
</div><!-- .box -->
<!-- angular historical controller -->
<div id="dataTableBox" class="box boxData" ng-controller="HistoricalDataCtrl">
<h2 class="sectHed xtraMargin">Apple Historical EV to EBITDA (TTM) Data</h2>
<!-- insert historical data template -->
<div ng-if="historicalData.userHasFullHistory">
<a id="butExpt"
class="smlBut proDataBut"
ng-click="getDataExport()">
Export Data
</a>
<span class="dateRangeLabel">Date Range: </span>
<div class="dateRangeControl" yc-date-range
start-date="historicalData.startDate"
end-date="historicalData.endDate"
></div>
<input type="button" class="submit smlSubmit dateRngSbmt" value="Get Data" ng-click="getHistoricalData()" />
<div class="clear"></div>
<!-- main data table div frame -->
<div id="paginData" yc-pagination
pagination-info="paginationInfo"
pagination-label-style="pages"
pagination-update-handler="getHistoricalData()"></div>
</div>
<div ng-show="initPhase">
<div class="dataColLeft";>
<div class="padR">
<table class="histDataTable">
<tr>
<th scope="col" class="col1 colHeadLrg">Data for this Date Range</th>
<th scope="col" class="col2 colHeadLrg"> </th>
</tr>
<tr>
<td class="col1">Nov. 14, 2017</td>
<td class="col2">
12.03
</td>
</tr>
<tr>
<td class="col1">Nov. 13, 2017</td>
<td class="col2">
12.21
</td>
</tr>
<tr>
<td class="col1">Nov. 10, 2017</td>
<td class="col2">
12.25
</td>
</tr>
<tr>
<td class="col1">Nov. 9, 2017</td>
<td class="col2">
12.34
</td>
</tr>
<tr>
<td class="col1">Nov. 8, 2017</td>
<td class="col2">
12.36
</td>
</tr>
<tr>
<td class="col1">Nov. 7, 2017</td>
<td class="col2">
12.26
</td>
</tr>
<tr>
<td class="col1">Nov. 6, 2017</td>
<td class="col2">
12.23
</td>
</tr>
<tr>
<td class="col1">Nov. 3, 2017</td>
<td class="col2">
12.11
</td>
</tr>
<tr>
<td class="col1">Nov. 2, 2017</td>
<td class="col2">
11.81
</td>
</tr>
<tr>
<td class="col1">Nov. 1, 2017</td>
<td class="col2">
11.73
</td>
</tr>
<tr>
<td class="col1">Oct. 31, 2017</td>
<td class="col2">
11.88
</td>
</tr>
<tr>
<td class="col1">Oct. 30, 2017</td>
<td class="col2">
11.72
</td>
</tr>
<tr>
<td class="col1">Oct. 27, 2017</td>
<td class="col2">
11.48
</td>
</tr>
<tr>
<td class="col1">Oct. 26, 2017</td>
<td class="col2">
11.10
</td>
</tr>
<tr>
<td class="col1">Oct. 25, 2017</td>
<td class="col2">
11.03
</td>
</tr>
<tr>
<td class="col1">Oct. 24, 2017</td>
<td class="col2">
11.08
</td>
</tr>
<tr>
<td class="col1">Oct. 23, 2017</td>
<td class="col2">
11.01
</td>
</tr>
<tr>
<td class="col1">Oct. 20, 2017</td>
<td class="col2">
11.02
</td>
</tr>
<tr>
<td class="col1">Oct. 19, 2017</td>
<td class="col2">
10.98
</td>
</tr>
<tr>
<td class="col1">Oct. 18, 2017</td>
<td class="col2">
11.24
</td>
</tr>
<tr>
<td class="col1">Oct. 17, 2017</td>
<td class="col2">
11.29
</td>
</tr>
<tr>
<td class="col1">Oct. 16, 2017</td>
<td class="col2">
11.25
</td>
</tr>
<tr>
<td class="col1">Oct. 13, 2017</td>
<td class="col2">
11.05
</td>
</tr>
<tr>
<td class="col1">Oct. 12, 2017</td>
<td class="col2">
10.99
</td>
</tr>
<tr>
<td class="col1">Oct. 11, 2017</td>
<td class="col2">
11.02
</td>
</tr>
</table>
</div>
</div>
I seem to be having trouble getting the RCHGetTablecell Function to lookup a table for me on yCharts.
I am looking for the EV/EBITDA of AAPL, currently 12.03 on the top of the table below.
I am using: =RCHGetTableCell("https://ycharts.com/companies/AAPL/ev_ebitda",1,"Data for this Date Range") but it pulls up "" 2 and 3 are an error.
Any thoughts on what I am doing wrong here? I bolded the font I am interested in below.
Thanks.
<h1 id="pgName" class="floatLVal tight">Apple EV to EBITDA (TTM):</h1><span id="pgNameVal">12.03 for Nov. 14, 2017</span>
<div class="clear"></div>
<!-- metricDropdown will render html here -->
<div id="metricDropdownControl" ng-controller="MetricDropdownCtrl">
<div class="metricSearch">
<div class="uiLbl">View 4,000+ financial data types</div>
<div yc-autocomplete
input-class="txt metricTxt smlTxt"
input-placeholder="Search"
block-invalid-input="true"
select-first="true"
submit-class="submit smlSubmit metricSubmit"
submit-label="Add"
submit-handler = "metricComplete(object, input)"
result-type = "list"
result-class="searchAutoComp metrics"
search-type="stock_history_calc"
></div>
<a class="smlBut" ng-click="$broadcast('showMetricPopup')">Browse...</a>
<div yc-metric-popup
menu-structure="metricMenu"
search-type="stock_history_calc"
select-metric-handler="metricSelect(metric, featureNeeded)"
show-popup-event-name="showMetricPopup"
yc-popup-helper
></div>
</div>
</div>
<!-- Chart section -->
<div class="box boxData" ng-controller="ChartCtrl">
<a href="http://ycharts.com/companies/AAPL/chart/#/?useHttps=false&startDate=&securities=id:AAPL,include:true,,&legendOnChart=&displayTicker=&scaleType="es=&units=&securitylistName=&recessions=false&endDate=&zoom=5&useEstimates=&securityGroup=&calcs=id:ev_ebitda,include:true,,&maxPoints=&securitylistSecurityId=&source=&splitType="eLegend=&partner=¬e=&title=&correlations=&format=real" class="
<h2 class="
<div id="dataChartW
<div id="chartCtrls
<div yc-chart-zoom
selected-zoom=
zoom-options=
zoom-change-
</div>
<div class="
<div ng-cloak
yc-chart-export-
export-handler=
Export Data
</div>
<div ng-cloak
yc-chart-export-
action="
image-url="
Save Image
</div>
<div ng-cloak
yc-chart-export-
action="
image-url="
Print Image
</div>
</div>
<div class="
</div>
<div id="dataChart&
<div id="fullChartL
For advanced charting, view our full-featured
<a href="/
</div>
<div
yc-fundamental-
chart-id='
chart-options=
chart-data-url=
clickable="
</div>
</div>
</div>
</div>
<!-- angular historical controller -->
<div id="dataTableB
<h2 class="
<!-- insert historical data template -->
<div ng-if="
<a id="butExpt&qu
class="
ng-click="
Export Data
</a>
<span class="
<div class="
start-date="
end-date="
></div>
<input type="button&q
<div class="
<!-- main data table div frame -->
<div id="paginData&
pagination-info=
pagination-label-
pagination-update-
</div>
<div ng-show="
<div class="
<div class="
<table class="
<tr>
<th scope="
<th scope="
</tr>
<tr>
<td class="
<td class="
12.03
</td>
</tr>
<tr>
<td class="
<td class="
12.21
</td>
</tr>
<tr>
<td class="
<td class="
12.25
</td>
</tr>
<tr>
<td class="
<td class="
12.34
</td>
</tr>
<tr>
<td class="
<td class="
12.36
</td>
</tr>
<tr>
<td class="
<td class="
12.26
</td>
</tr>
<tr>
<td class="
<td class="
12.23
</td>
</tr>
<tr>
<td class="
<td class="
12.11
</td>
</tr>
<tr>
<td class="
<td class="
11.81
</td>
</tr>
<tr>
<td class="
<td class="
11.73
</td>
</tr>
<tr>
<td class="
<td class="
11.88
</td>
</tr>
<tr>
<td class="
<td class="
11.72
</td>
</tr>
<tr>
<td class="
<td class="
11.48
</td>
</tr>
<tr>
<td class="
<td class="
11.10
</td>
</tr>
<tr>
<td class="
<td class="
11.03
</td>
</tr>
<tr>
<td class="
<td class="
11.08
</td>
</tr>
<tr>
<td class="
<td class="
11.01
</td>
</tr>
<tr>
<td class="
<td class="
11.02
</td>
</tr>
<tr>
<td class="
<td class="
10.98
</td>
</tr>
<tr>
<td class="
<td class="
11.24
</td>
</tr>
<tr>
<td class="
<td class="
11.29
</td>
</tr>
<tr>
<td class="
<td class="
11.25
</td>
</tr>
<tr>
<td class="
<td class="
11.05
</td>
</tr>
<tr>
<td class="
<td class="
10.99
</td>
</tr>
<tr>
<td class="
<td class="
11.02
</td>
</tr>
</table>
</div>
</div>
Wed Nov 15, 2017 10:50 am (PST) . Posted by:
ghart21
YCharts was unexpectedly offline for a couple of hours this
morning.
It would help to check "health" of the website you are accessing
before dropping another problem in Randy's lap. At some point
here he is going to blow a breaker.
[Logo (slash black).png]
<http://go.ycharts.com/e1t/c/*W63L7TJ3VBv2cMVn6vJtNhmQ0/*N957LZ0W\
4QkGW3nQxWZ77kW7k0/5/f18dQhb0Smh_8XJ888W7HgCNZ2qwv2rVpSYyp1hB0JLM\
f5qSTXD6prW39DrZh7lPs5LW1nxpW_96LsblW61SSZm7mG7sDW51vX4y6HlsvyW50\
Cxrw3VpyzYW9dSlS635rgClW94-4T07sLfyrW5DBw5F7v70xcW34mKv98mQMYTW7N\
M5zG33v7B9W2x-ccw7d094fW6G7Fbl4DFfS3W6RrmlN1xqSzfW8rlm6D5DtvKFW5j\
GFc32xk5r8W4Fsg8f2yXJ5hW3rwFPY42F03VW5kVm2_6p53hQVPn8qf7cdC7BVPGl\
M_8r1H-pW62jFjD7mBB1HW26r0wQ1K3HsDW3KZVQW5jkVw0W2BsTvv5brc74N1Vtd\
WZv-Lj0VVR6H24q1Pz5W2wQ0By2gKlWzW2F5DlG1hmrDJW3kXmjD2w8xKKW5bN25_\
2HFVbVW7HB7xm4mbg1gW8yGyPZ9397mXW54yd3l4zjQSyW3lywPG73Q0vRV1-RXt4\
wc8Yy102>
Hi George,
Thank you for your patience as we migrated over to our back-up
database. YCharts website is now back up and running after a
brief outage casued by an issue with an upstream service
provider.
We'll continue to monitor systems and provide updates if anything
changes but expect a seamless experience from here. Again, we
would like to apologize for any inconveniences caused and thank
you for your business.
Best,
The YCharts Team
-----Original Message-----
From: "tmallen2@bellsouth.net [smf_addin]"
Sent: Nov 15, 2017 1:46 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] yChart Lookup
Randy,
I seem to be having trouble getting the RCHGetTablecell Function
to lookup a table for me on yCharts.
I am looking for the EV/EBITDA of AAPL, currently 12.03 on the
top of the table below.
I am using:
=RCHGetTableCell("https://ycharts.com/companies/AAPL/ev_ebitda",1\
,"Data for this Date Range") but it pulls up "" 2 and 3 are an
error.
Any thoughts on what I am doing wrong here? I bolded the font I
am interested in below.
Thanks.
<h1 id="pgName" class="floatLVal tight">Apple EV to EBITDA
(TTM):</h1><span id="pgNameVal">12.03 for Nov. 14, 2017</span>
<div class="clear"></div>
<!-- metricDropdown will render html here -->
<div id="metricDropdownControl"
ng-controller="MetricDropdownCtrl">
<div class="metricSearch">
<div class="uiLbl">View 4,000+ financial data types</div>
<div yc-autocomplete
input-class="txt metricTxt smlTxt"
input-placeholder="Search"
block-invalid-input="true"
select-first="true"
submit-class="submit smlSubmit metricSubmit"
submit-label="Add"
submit-handler = "metricComplete(object, input)"
result-type = "list"
result-class="searchAutoComp metrics"
search-type="stock_history_calc"
></div>
<a class="smlBut"
ng-click="$broadcast('showMetricPopup')">Browse...</a>
<div yc-metric-popup
menu-structure="metricMenu"
search-type="stock_history_calc"
select-metric-handler="metricSelect(metric,
featureNeeded)"
show-popup-event-name="showMetricPopup"
yc-popup-helper
></div>
</div>
</div>
<!-- Chart section -->
<div class="box boxData" ng-controller="ChartCtrl">
<a
href="http://ycharts.com/companies/AAPL/chart/#/?useHttps=false&a\
mp;startDate=&securities=id:AAPL,include:true,,&legendOnC\
hart=&displayTicker=&scaleType="es=&units=&am\
p;securitylistName=&recessions=false&endDate=&zoom=5&\
amp;useEstimates=&securityGroup=&calcs=id:ev_ebitda,inclu\
de:true,,&maxPoints=&securitylistSecurityId=&source=&\
amp;splitType="eLegend=&partner=¬e=&title=\
&correlations=&format=real" class="sectHedLink";>View Full
Chart</a>
<h2 class="sectHed">Apple EV to EBITDA (TTM) Chart </h2>
<div id="dataChartWrapAll">
<div id="chartCtrls">
<div yc-chart-zoom
selected-zoom="chartInfo.zoom"
zoom-options="zoomOptions"
zoom-change-handler="zoomChange(zoom)">
</div>
<div class="chartButsProData">
<div ng-cloak
yc-chart-export-data
export-handler="dataExport()">
Export Data
</div>
<div ng-cloak
yc-chart-export-image
action="Save"
image-url="chartUrls.imageUrl">
Save Image
</div>
<div ng-cloak
yc-chart-export-image
action="Print"
image-url="chartUrls.imageUrl">
Print Image
</div>
</div>
<div class="clear"></div>
</div>
<div id="dataChart">
<div id="fullChartLink">
For advanced charting, view our full-featured
<a href="/companies/AAPL/chart/">Fundamental
Chart</a>
</div>
<div
yc-fundamental-chart
chart-id='dataChartCanvas'
chart-options="chartOptions"
chart-data-url="chartUrls.dataUrl"
clickable="true">
</div>
</div>
</div>
</div><!-- .box -->
<!-- angular historical controller -->
<div id="dataTableBox" class="box boxData"
ng-controller="HistoricalDataCtrl">
<h2 class="sectHed xtraMargin">Apple Historical EV to EBITDA
(TTM) Data</h2>
<!-- insert historical data template -->
<div ng-if="historicalData.userHasFullHistory">
<a id="butExpt"
class="smlBut proDataBut"
ng-click="getDataExport()">
Export Data
</a>
<span class="dateRangeLabel">Date Range: </span>
<div class="dateRangeControl" yc-date-range
start-date="historicalData.startDate"
end-date="historicalData.endDate"
></div>
<input type="button" class="submit smlSubmit dateRngSbmt"
value="Get Data" ng-click="getHistoricalData()" />
<div class="clear"></div>
<!-- main data table div frame -->
<div id="paginData" yc-pagination
pagination-info="paginationInfo"
pagination-label-style="pages"
pagination-update-handler="getHistoricalData()"></div>
</div>
<div ng-show="initPhase">
<div class="dataColLeft";>
<div class="padR">
<table class="histDataTable">
<tr>
<th scope="col" class="col1 colHeadLrg">Data for this
Date Range</th>
<th scope="col" class="col2 colHeadLrg"> </th>
</tr>
<tr>
<td class="col1">Nov. 14, 2017</td>
<td class="col2">
12.03
</td>
</tr>
<tr>
<td class="col1">Nov. 13, 2017</td>
<td class="col2">
12.21
</td>
</tr>
<tr>
<td class="col1">Nov. 10, 2017</td>
<td class="col2">
12.25
</td>
</tr>
<tr>
<td class="col1">Nov. 9, 2017</td>
<td class="col2">
12.34
</td>
</tr>
<tr>
<td class="col1">Nov. 8, 2017</td>
<td class="col2">
12.36
</td>
</tr>
<tr>
<td class="col1">Nov. 7, 2017</td>
<td class="col2">
12.26
</td>
</tr>
<tr>
<td class="col1">Nov. 6, 2017</td>
<td class="col2">
12.23
</td>
</tr>
<tr>
<td class="col1">Nov. 3, 2017</td>
<td class="col2">
12.11
</td>
</tr>
<tr>
<td class="col1">Nov. 2, 2017</td>
<td class="col2">
11.81
</td>
</tr>
<tr>
<td class="col1">Nov. 1, 2017</td>
<td class="col2">
11.73
</td>
</tr>
<tr>
<td class="col1">Oct. 31, 2017</td>
<td class="col2">
11.88
</td>
</tr>
<tr>
<td class="col1">Oct. 30, 2017</td>
<td class="col2">
11.72
</td>
</tr>
<tr>
<td class="col1">Oct. 27, 2017</td>
<td class="col2">
11.48
</td>
</tr>
<tr>
<td class="col1">Oct. 26, 2017</td>
<td class="col2">
11.10
</td>
</tr>
<tr>
<td class="col1">Oct. 25, 2017</td>
<td class="col2">
11.03
</td>
</tr>
<tr>
<td class="col1">Oct. 24, 2017</td>
<td class="col2">
11.08
</td>
</tr>
<tr>
<td class="col1">Oct. 23, 2017</td>
<td class="col2">
11.01
</td>
</tr>
<tr>
<td class="col1">Oct. 20, 2017</td>
<td class="col2">
11.02
</td>
</tr>
<tr>
<td class="col1">Oct. 19, 2017</td>
<td class="col2">
10.98
</td>
</tr>
<tr>
<td class="col1">Oct. 18, 2017</td>
<td class="col2">
11.24
</td>
</tr>
<tr>
<td class="col1">Oct. 17, 2017</td>
<td class="col2">
11.29
</td>
</tr>
<tr>
<td class="col1">Oct. 16, 2017</td>
<td class="col2">
11.25
</td>
</tr>
<tr>
<td class="col1">Oct. 13, 2017</td>
<td class="col2">
11.05
</td>
</tr>
<tr>
<td class="col1">Oct. 12, 2017</td>
<td class="col2">
10.99
</td>
</tr>
<tr>
<td class="col1">Oct. 11, 2017</td>
<td class="col2">
11.02
</td>
</tr>
</table>
</div>
</div>
morning.
It would help to check "health" of the website you are accessing
before dropping another problem in Randy's lap. At some point
here he is going to blow a breaker.
[Logo (slash black).png]
<http://go.ycharts.com/e1t/c/*W63L7TJ3VBv2cMVn6vJtNhmQ0/*N957LZ0W\
4QkGW3nQxWZ77kW7k0/5/f18dQhb0Smh_8XJ888W7HgCNZ2qwv2rVpSYyp1hB0JLM\
f5qSTXD6prW39DrZh7lPs5LW1nxpW_96LsblW61SSZm7mG7sDW51vX4y6HlsvyW50\
Cxrw3VpyzYW9dSlS635rgClW94-4T07sLfyrW5DBw5F7v70xcW34mKv98mQMYTW7N\
M5zG33v7B9W2x-ccw7d094fW6G7Fbl4DFfS3W6RrmlN1xqSzfW8rlm6D5DtvKFW5j\
GFc32xk5r8W4Fsg8f2yXJ5hW3rwFPY42F03VW5kVm2_6p53hQVPn8qf7cdC7BVPGl\
M_8r1H-pW62jFjD7mBB1HW26r0wQ1K3HsDW3KZVQW5jkVw0W2BsTvv5brc74N1Vtd\
WZv-Lj0VVR6H24q1Pz5W2wQ0By2gKlWzW2F5DlG1hmrDJW3kXmjD2w8xKKW5bN25_\
2HFVbVW7HB7xm4mbg1gW8yGyPZ9397mXW54yd3l4zjQSyW3lywPG73Q0vRV1-RXt4\
wc8Yy102>
Hi George,
Thank you for your patience as we migrated over to our back-up
database. YCharts website is now back up and running after a
brief outage casued by an issue with an upstream service
provider.
We'll continue to monitor systems and provide updates if anything
changes but expect a seamless experience from here. Again, we
would like to apologize for any inconveniences caused and thank
you for your business.
Best,
The YCharts Team
-----Original Message-----
From: "tmallen2@bellsouth.net [smf_addin]"
Sent: Nov 15, 2017 1:46 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] yChart Lookup
Randy,
I seem to be having trouble getting the RCHGetTablecell Function
to lookup a table for me on yCharts.
I am looking for the EV/EBITDA of AAPL, currently 12.03 on the
top of the table below.
I am using:
=RCHGetTableCell("https://ycharts.com/companies/AAPL/ev_ebitda",1\
,"Data for this Date Range") but it pulls up "" 2 and 3 are an
error.
Any thoughts on what I am doing wrong here? I bolded the font I
am interested in below.
Thanks.
<h1 id="pgName" class="floatLVal tight">Apple EV to EBITDA
(TTM):</h1><span id="pgNameVal">12.03 for Nov. 14, 2017</span>
<div class="clear"></div>
<!-- metricDropdown will render html here -->
<div id="metricDropdownControl"
ng-controller="MetricDropdownCtrl">
<div class="metricSearch">
<div class="uiLbl">View 4,000+ financial data types</div>
<div yc-autocomplete
input-class="txt metricTxt smlTxt"
input-placeholder="Search"
block-invalid-input="true"
select-first="true"
submit-class="submit smlSubmit metricSubmit"
submit-label="Add"
submit-handler = "metricComplete(object, input)"
result-type = "list"
result-class="searchAutoComp metrics"
search-type="stock_history_calc"
></div>
<a class="smlBut"
ng-click="$broadcast('showMetricPopup')">Browse...</a>
<div yc-metric-popup
menu-structure="metricMenu"
search-type="stock_history_calc"
select-metric-handler="metricSelect(metric,
featureNeeded)"
show-popup-event-name="showMetricPopup"
yc-popup-helper
></div>
</div>
</div>
<!-- Chart section -->
<div class="box boxData" ng-controller="ChartCtrl">
<a
href="http://ycharts.com/companies/AAPL/chart/#/?useHttps=false&a\
mp;startDate=&securities=id:AAPL,include:true,,&legendOnC\
hart=&displayTicker=&scaleType="es=&units=&am\
p;securitylistName=&recessions=false&endDate=&zoom=5&\
amp;useEstimates=&securityGroup=&calcs=id:ev_ebitda,inclu\
de:true,,&maxPoints=&securitylistSecurityId=&source=&\
amp;splitType="eLegend=&partner=¬e=&title=\
&correlations=&format=real" class="
Chart</a>
<h2 class="
<div id="dataChartW
<div id="chartCtrls
<div yc-chart-zoom
selected-zoom=
zoom-options=
zoom-change-
</div>
<div class="
<div ng-cloak
yc-chart-export-
export-handler=
Export Data
</div>
<div ng-cloak
yc-chart-export-
action="
image-url="
Save Image
</div>
<div ng-cloak
yc-chart-export-
action="
image-url="
Print Image
</div>
</div>
<div class="
</div>
<div id="dataChart&
<div id="fullChartL
For advanced charting, view our full-featured
<a href="/
Chart</a>
</div>
<div
yc-fundamental-
chart-id='
chart-options=
chart-data-url=
clickable="
</div>
</div>
</div>
</div>
<!-- angular historical controller -->
<div id="dataTableB
ng-controller=
<h2 class="
(TTM) Data</h2>
<!-- insert historical data template -->
<div ng-if="
<a id="butExpt&qu
class="
ng-click="
Export Data
</a>
<span class="
<div class="
start-date="
end-date="
></div>
<input type="button&q
value="
<div class="
<!-- main data table div frame -->
<div id="paginData&
pagination-info=
pagination-label-
pagination-update-
</div>
<div ng-show="
<div class="
<div class="
<table class="
<tr>
<th scope="
Date Range</th>
<th scope="
</tr>
<tr>
<td class="
<td class="
12.03
</td>
</tr>
<tr>
<td class="
<td class="
12.21
</td>
</tr>
<tr>
<td class="
<td class="
12.25
</td>
</tr>
<tr>
<td class="
<td class="
12.34
</td>
</tr>
<tr>
<td class="
<td class="
12.36
</td>
</tr>
<tr>
<td class="
<td class="
12.26
</td>
</tr>
<tr>
<td class="
<td class="
12.23
</td>
</tr>
<tr>
<td class="
<td class="
12.11
</td>
</tr>
<tr>
<td class="
<td class="
11.81
</td>
</tr>
<tr>
<td class="
<td class="
11.73
</td>
</tr>
<tr>
<td class="
<td class="
11.88
</td>
</tr>
<tr>
<td class="
<td class="
11.72
</td>
</tr>
<tr>
<td class="
<td class="
11.48
</td>
</tr>
<tr>
<td class="
<td class="
11.10
</td>
</tr>
<tr>
<td class="
<td class="
11.03
</td>
</tr>
<tr>
<td class="
<td class="
11.08
</td>
</tr>
<tr>
<td class="
<td class="
11.01
</td>
</tr>
<tr>
<td class="
<td class="
11.02
</td>
</tr>
<tr>
<td class="
<td class="
10.98
</td>
</tr>
<tr>
<td class="
<td class="
11.24
</td>
</tr>
<tr>
<td class="
<td class="
11.29
</td>
</tr>
<tr>
<td class="
<td class="
11.25
</td>
</tr>
<tr>
<td class="
<td class="
11.05
</td>
</tr>
<tr>
<td class="
<td class="
10.99
</td>
</tr>
<tr>
<td class="
<td class="
11.02
</td>
</tr>
</table>
</div>
</div>
Wed Nov 15, 2017 11:29 am (PST) . Posted by:
"Randy Harmelink" rharmelink
You're getting a blank because that's what is in the cell immediately
following
"Data for this Date Range". And using a 2 or 3 will cause an error because
there is only one more table cell on that row (hitting the end of a table
row stops the search for more table cells).
Try either:
=RCHGetTableCell($E$5,2,"Data for this Date Range","<tr")
=smfGetTagContent($E$5,"td",3,"Data for this Date Range",,,,1)
Thanks for including the source code. Since the data you're after requires
a login, I wouldn't have been able to view it or access it anyway. However,
I was able to throw the source code you sent into a temporary web page and
try extracting it from there.
On Wed, Nov 15, 2017 at 11:46 AM, tmallen2@
...
wrote:
> I seem to be having trouble getting the RCHGetTablecell Function to lookup
> a table for me on yCharts.
>
> I am looking for the EV/EBITDA of AAPL, currently 12.03 on the top of the
> table below.
>
> I am using: =RCHGetTableCell("https://ycharts.com/companies/AAPL/ev_ebitda
> ",1,
>
> "Data for this Date Range") but it pulls up "" 2 and 3 are an error.
>
> Any thoughts on what I am doing wrong here? I bolded the font I am
> interested in below.
>
>
>
following
"Data for this Date Range". And using a 2 or 3 will cause an error because
there is only one more table cell on that row (hitting the end of a table
row stops the search for more table cells).
Try either:
=RCHGetTableCell($E$5,2,"Data for this Date Range","<tr")
=smfGetTagContent($E$5,"td",3,"Data for this Date Range",,,,1)
Thanks for including the source code. Since the data you're after requires
a login, I wouldn't have been able to view it or access it anyway. However,
I was able to throw the source code you sent into a temporary web page and
try extracting it from there.
On Wed, Nov 15, 2017 at 11:46 AM, tmallen2@
...
wrote:
> I seem to be having trouble getting the RCHGetTablecell Function to lookup
> a table for me on yCharts.
>
> I am looking for the EV/EBITDA of AAPL, currently 12.03 on the top of the
> table below.
>
> I am using: =RCHGetTableCell("https://ycharts.com/companies/AAPL/ev_ebitda
> ",1,
>
> "Data for this Date Range") but it pulls up "" 2 and 3 are an error.
>
> Any thoughts on what I am doing wrong here? I bolded the font I am
> interested in below.
>
>
>
Wed Nov 15, 2017 11:31 am (PST) . Posted by:
ridgebacksexcel
I know he is very busy and normally figure this stuff out myself. However I am considering signing up for the yChart service and need to know if I can extract data from the site afterwards. I am on a trial week now.
I added 1 to PRows and that pulls up the date Nov. 14, 2017. I then added a 2 to PCells and the it says Upgrade which is what I feared instead of 12.03
I have Internet Explorer load a new page with every visit. I signed into yCharts from Internet Explorer so that is good. I deleted all history etc... I restarted Internet Explorer and Excel.
Not sure what else I can do to get past the upgrade result problem. Its not the Database.
Maybe I'll save the money and not signup if I can't extract the data.
I added 1 to PRows and that pulls up the date Nov. 14, 2017. I then added a 2 to PCells and the it says Upgrade which is what I feared instead of 12.03
I have Internet Explorer load a new page with every visit. I signed into yCharts from Internet Explorer so that is good. I deleted all history etc... I restarted Internet Explorer and Excel.
Not sure what else I can do to get past the upgrade result problem. Its not the Database.
Maybe I'll save the money and not signup if I can't extract the data.
Wed Nov 15, 2017 11:38 am (PST) . Posted by:
ridgebacksexcel
Thanks for the reply Randy. Your two formulas and my new one all say "Upgrade". Its blocking the data somehow and I don't think we can get around it. I thought it would work during the one week trial but maybe not.
The last thing I want to do is waste money if I cant extract data. I like the site but only if I can download into Excel. They charge BIG $ to do that with their add in unfortunately.
I'd pay just for web access but only if your add in would work. It may not be worth the trouble.
Thanks for the reply.
The last thing I want to do is waste money if I cant extract data. I like the site but only if I can download into Excel. They charge BIG $ to do that with their add in unfortunately.
I'd pay just for web access but only if your add in would work. It may not be worth the trouble.
Thanks for the reply.
Wed Nov 15, 2017 11:57 am (PST) . Posted by:
"Randy Harmelink" rharmelink
You do have to create the IE security cookie to allow EXCEL and the add-in
to have access to the data.
Use the EXCEL IE object (alt+d+d+w) and log in to the web site to create
the security cookie. Then do an smfForceRecalculation and try again.
That particular data item is available from Yahoo and GuruFocus.
On Wed, Nov 15, 2017 at 12:38 PM, tmallen2@
...
wrote:
> Thanks for the reply Randy. Your two formulas and my new one all say
> "Upgrade". Its blocking the data somehow and I don't think we can get
> around it. I thought it would work during the one week trial but maybe not.
>
> The last thing I want to do is waste money if I cant extract data. I like
> the site but only if I can download into Excel. They charge BIG $ to do
> that with their add in unfortunately.
>
> I'd pay just for web access but only if your add in would work. It may not
> be worth the trouble.
>
>
>
to have access to the data.
Use the EXCEL IE object (alt+d+d+w) and log in to the web site to create
the security cookie. Then do an smfForceRecalculati
That particular data item is available from Yahoo and GuruFocus.
On Wed, Nov 15, 2017 at 12:38 PM, tmallen2@
...
wrote:
> Thanks for the reply Randy. Your two formulas and my new one all say
> "Upgrade"
> around it. I thought it would work during the one week trial but maybe not.
>
> The last thing I want to do is waste money if I cant extract data. I like
> the site but only if I can download into Excel. They charge BIG $ to do
> that with their add in unfortunately.
>
> I'd pay just for web access but only if your add in would work. It may not
> be worth the trouble.
>
>
>
Wed Nov 15, 2017 2:34 pm (PST) . Posted by:
ridgebacksexcel
Randy you are a computer genius. That fixed the problem. I would have spent hours trying and still not figured that one out. Thank you.
Wed Nov 15, 2017 2:37 pm (PST) . Posted by:
ridgebacksexcel
PS. I know EV/EBITDA is available on Yahoo and GuruFocus but I was just using that as a test for all the other data points that are not. I also create backup if statements in case Yahoo does not work.
Wed Nov 15, 2017 10:55 am (PST) . Posted by:
gbullr
Help once again...
url. "http://www.indexmundi.com/energy/?country=ve&product=oil&graph=production http://www.indexmundi.com/energy/?country=ve&product=oil&graph=production"
current cell content copied down in array gets me on nly the year column.
=RCHGetHTMLTable("http://www.indexmundi.com/energy/?country=ve&product=oil&graph=production","chemical content",1)
Would like all three columns.
Thank you very much.
url. "http://www.indexmundi.com/energy/?country=ve&product=oil&graph=production http://www.indexmundi.com/energy/?country=ve&product=oil&graph=production"
current cell content copied down in array gets me on nly the year column.
=RCHGetHTMLTable("http://www.indexmundi.com/energy/?country=ve&product=oil&graph=production","
Would like all three columns.
Thank you very much.
Wed Nov 15, 2017 11:10 am (PST) . Posted by:
"Craig Passow" passow
If you want to get three columns of data, you need to array-enter the
formula across three columns.
On 11/15/2017 12:55 PM, gaston.bullrich@gmail.com [smf_addin] wrote:
>
>
> Help once again...
>
> url.
> "http://www.indexmundi.com/energy/?country=ve&product=oil&graph=production"
>
>
> current cell content copied down in array gets me on nly the year column.
>
> =RCHGetHTMLTable("http://www.indexmundi.com/energy/?country=ve&product=oil&graph=production","chemical
> content",1)
>
> Would like all three columns.
>
> Thank you very much.
>
formula across three columns.
On 11/15/2017 12:55 PM, gaston.bullrich@gmail.com [smf_addin] wrote:
>
>
> Help once again...
>
> url.
> "http://www.indexmundi.com/energy/?country=ve&product=oil&graph=production"
>
>
> current cell content copied down in array gets me on nly the year column.
>
> =RCHGetHTMLTable("http://www.indexmundi.com/energy/?country=ve&product=oil&graph=production","
> content"
>
> Would like all three columns.
>
> Thank you very much.
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar