Minggu, 14 Januari 2018

[smf_addin] Digest Number 4291

7 Messages

Digest #4291
1a
Re: smfGetCSVFile by "Randy Randall" randyr_cds
1b
1c
Re: smfGetCSVFile by "Randy Harmelink" rharmelink
1d
Re: smfGetCSVFile by "Randy Harmelink" rharmelink
2a
smfGetTagContent by doghandler978
2b
Re: smfGetTagContent by "Randy Harmelink" rharmelink

Messages

Sun Jan 14, 2018 10:17 am (PST) . Posted by:

"Randy Randall" randyr_cds

Did your paid subscription expire? Do you get 10 years of data displaying
on their website?

Randy Randall

On Sat, Jan 13, 2018 at 6:13 PM, rimanda1@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
>
> Apologies for lack of clarity.
>
> Yes I can (and always do) login to Morning Star using the Excel WEB Query
> Dialog. By changing pages, I meant clicking on the menu Morning Star web
> site option Portfolio whilst still in the WEB query dialog.
>
> This morning, to verify my situation, I followed the following process:
> 1. Open a new instance of Excel and created a blank worksheet
> 2. Array entered the following formula ensuring I had included sufficient
> columns to display 10 years data:
> =smfGetCSVFile("http://financials.morningstar.com/
> ajax/ReportProcess4CSV.html?t=" & A1 & "&reportType=is&period=12&
> dataType=A&order=asc&columnYear=10&rounding=3&denominatorView=raw")
> 3. Activated the Excel Web Query dialog and logged into Morning Star. I
> waited until the "login" link had changed to "logout" to ensure I was in
> fact logged in
> 3. Closed the WEB query dialog and verified that only 5 years of data was
> displayed
> 4. Ran the smfForceReculation macro, but still only 5 years data was
> displayed.
>
> If you follow a similar process, do you get back 10 years data?
> I am using version 2.1.2017.11.04 as defined by the constant kVersion
>
>
>
>

Sun Jan 14, 2018 12:47 pm (PST) . Posted by:

rimanda1

In response to the two functions you asked me to try I get:
December. ,2012-12,2013-12,2014-12,2015-12,2016-12,TTMRevenue,29904000000,30871000000,31821000000,30



and

Welcome!



Yes I have converted to Morning Star beta site
Yes my subscription is still current and not exopired
Yes I get 10 years data displayed on their web site
Spreadsheet attached with functions as requested


Sun Jan 14, 2018 2:11 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

I think the "Welcome!" means you're not logged in for EXCEL usage, which is
why you're only getting 5 years of data. I get that before I log in, and
"Welcome, Randy!" when I log in.

What do you get in the EXCEL IE object (alt+d+d+w) using this URL:

http://financials.morningstar.com/ratios/r.html?t=MMM

Does it redirect you to a different URL? What happens if you use that URL
in your browser (or in IE)? Does your browser show a "Welcome!" or a
"Welcome, xxxx!" message at the top?

I'm not sure how the beta site might affect the process. You may need to
use a different URL? Or, logging into the beta site may not log you into
the site that is delivering the CSV file used in that function?

On Sun, Jan 14, 2018 at 1:47 PM, rimanda1@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> In response to the two functions you asked me to try I get:
> December. ,2012-12,2013-12,2014-12,2015-12,2016-12,TTMRevenue,
> 29904000000,30871000000,31821000000,30
>
> and
> Welcome!
>
> Yes I have converted to Morning Star beta site
> Yes my subscription is still current and not exopired
> Yes I get 10 years data displayed on their web site
> Spreadsheet attached with functions as requested
>
>

Sun Jan 14, 2018 2:13 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

P.S. Your attached workbook worked fine here, returning the same things I
would normally see...

On Sun, Jan 14, 2018 at 1:47 PM, rimanda1@
​...
wrote:

>
> In response to the two functions you asked me to try I get:
> December. ,2012-12,2013-12,2014-12,2015-12,2016-12,TTMRevenue,
> 29904000000,30871000000,31821000000,30
>
> and
> Welcome!
>
> Yes I have converted to Morning Star beta site
> Yes my subscription is still current and not exopired
> Yes I get 10 years data displayed on their web site
> Spreadsheet attached with functions as requested
>
>

Sun Jan 14, 2018 10:44 am (PST) . Posted by:

doghandler978

I'm can't get smdGetTagContent to find the string in the following data. It works for other strings. Is there a limit to string length? I did try to extract a pert of the string and that also failed.


Any ideas what I've done wrong?


Thanks,
Don




This is the function that results in "ERROR"


=smfGetTagContent("https://www.ftportfolios.com/retail/dp/dpprice.aspx?fundid=12412","td",1,"Remaining Deferred Sales Charge:")


Data that fails::
<tr>
<td><span id="ContentPlaceHolder1_Dpsummary1_Label1" class="DPFieldLabel&quot;>Remaining Deferred Sales Charge:</span></td>
<td style="text-align: right; vertical-align: middle;"><span id="ContentPlaceHolder1_Dpsummary1_lblDefSalesCharge" class="DPPortPagesBody&quot;>$0.0000</span></td>
<tr>
</tr>
</table>
</td>


This extract works.


<td><span id="ContentPlaceHolder1_Dpsummary1_lblNAVLabel"; class="DPFieldLabel&quot;>NAV(*):</span></td>
<td align="right"><span id="ContentPlaceHolder1_Dpsummary1_lblNAV" class="DPPortPagesBody&quot;>$11.2373</span></td>
</tr>





Sun Jan 14, 2018 11:08 am (PST) . Posted by:

"Randy Harmelink" rharmelink

The data isn't on the web page you're using. The "Summary" tab data is on
this web page:

https://www.ftportfolios.com/Retail/dp/dpsummary.aspx?fundid=12412&Trust=CSBW31

Either of these appear to work:

=smfGetTagContent("
https://www.ftportfolios.com/Retail/dp/dpsummary.aspx?fundid=12412&Trust=CSBW31","td",1,"Remaining
Deferred Sales Charge:",,,,1)

=smfGetTagContent("
https://www.ftportfolios.com/Retail/dp/dpsummary.aspx?fundid=12412&Trust=CSBW31","span",1,"Remaining
Deferred Sales Charge:",,,,1)

On Sun, Jan 14, 2018 at 11:44 AM, doghandler978@
​...
wrote:

> I'm can't get smdGetTagContent to find the string in the following data.
> It works for other strings. Is there a limit to string length? I did try
> to extract a pert of the string and that also failed.
>
> Any ideas what I've done wrong?
>
> This is the function that results in "ERROR"
>
> =smfGetTagContent("https://www.ftportfolios.com/retail/
> dp/dpprice.aspx?fundid=12412&quot;,"td",1,"Remaining Deferred Sales Charge:")
>
> Data that fails::
>
> <tr>
>
> <td><span id="ContentPlaceHolder1_Dpsummary1_Label1"
> class="DPFieldLabel&quot;>Remaining Deferred Sales Charge:</span></td>
>
> <td style="text-align: right; vertical-align:
> middle;"><span id="ContentPlaceHolder1_Dpsummary1_lblDefSalesCharge"
> class="DPPortPagesBody&quot;>$0.0000</span></td>
>
> <tr>
>
> </tr>
>
> </table>
>
> </td>
>
> This extract works.
>
> <td><span id="ContentPlaceHolder1_Dpsummary1_lblNAVLabel";
> class="DPFieldLabel&quot;>NAV(*):</span></td>
>
> <td align="right"><span id="ContentPlaceHolder1_Dpsummary1_lblNAV"
> class="DPPortPagesBody&quot;>$11.2373</span></td>
>
> </tr>
>
>
>

Sun Jan 14, 2018 10:52 am (PST) . Posted by:

doghandler978

Thanks for the help. I used the log file and located a site with a 21 second delay! That probably is the reason the response just recently occurred and was variable.

It's now responding very fast after removing that link.


Thanks again for a great software tool!


Don

For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Diposting oleh EXCEL FEED LEARNING di 18.04

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)