Rabu, 10 Juni 2015

[smf_addin] Digest Number 3429

6 Messages

Digest #3429
1b
Re: Gurufocus 10 Year Quarterly view by "Randy Harmelink" rharmelink
1d
Re: Gurufocus 10 Year Quarterly view by "Randy Harmelink" rharmelink
2a
2b
Re: Missing ETF data by "Randy Harmelink" rharmelink

Messages

Tue Jun 9, 2015 4:25 am (PDT) . Posted by:

sirons1962

I was attempting to use this to test the data import:

=smfGetCSVFile("http://www.gurufocus.com/download_financials_in_CSV.php?symbol="ILMN)

and it wouldn't work so I used:

=smfGetCSVFile("http://www.gurufocus.com/download_financials_in_CSV.php?symbol=""ILMN")

and that was where I was getting the errors.

When I used the example you listed and set up the stock symbol to be in a cell it worked.



Thanks again Randy for going above and beyond!

Tue Jun 9, 2015 4:32 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

This:

=smfGetCSVFile("
http://www.gurufocus.com/download_financials_in_CSV.php?symbol="ILMN)
=smfGetCSVFile("
http://www.gurufocus.com/download_financials_in_CSV.php?symbol=""ILMN")

...should have been:

=smfGetCSVFile("
http://www.gurufocus.com/download_financials_in_CSV.php?symbol=ILMN")

Just one long string. In yours, it inserted a double quote in front of the
ticker symbol.

On Tue, Jun 9, 2015 at 4:25 AM, sirons1962@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
>
> I was attempting to use this to test the data import:
>
> =smfGetCSVFile("
> http://www.gurufocus.com/download_financials_in_CSV.php?symbol="ILMN)
>
> and it wouldn't work so I used:
>
> =smfGetCSVFile("
> http://www.gurufocus.com/download_financials_in_CSV.php?symbol=""ILMN")
>
> and that was where I was getting the errors.
>
> When I used the example you listed and set up the stock symbol to be in a
> cell it worked.
>
>

Tue Jun 9, 2015 5:12 am (PDT) . Posted by:

sirons1962

I am now mulling over which if the two ways would be better to grab the data. It seems quicker to grab the CSV file and then grab from that what I need.


Thanks for all of your help Randy it is appreciated!

Tue Jun 9, 2015 5:21 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

The drawback of the CSV file is you still need to look for what you need,
because it won't be in a fixed location. They really should have put the
change log on the back end so locations wouldn't change every time they add
a new change entry. But VLOOKUP() functions will probably be faster for
each element retrieved.

But the other way, you have three different web pages to retrieve.

Did you look at the XLS file? That has multiple worksheets, each with
different types of data.

On Tue, Jun 9, 2015 at 5:12 AM, sirons1962@... wrote:

>
> I am now mulling over which if the two ways would be better to grab the
> data. It seems quicker to grab the CSV file and then grab from that what I
> need.
>
>
>

Tue Jun 9, 2015 8:22 am (PDT) . Posted by:

biignez



The following ETF elements do not appear to have lookups:
Fees
Morningstar Rating
YTD (only 1 day, 1 month)
3 Year, 5 Year, 10 Year as-of trailing performance
Is this true or am I just overlooking something? - Thanks for any help.






http://ogres-crypt.com/SMF




Tue Jun 9, 2015 8:36 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

These are the items I've mapped since they've gone to dynamic web pages:

Web pageData ItemFormula Trailing Total ReturnsReturns as of
=DATEVALUE(smfstrExtr(smfGetTagContent("
http://performance.morningstar.com/Performance/cef/trailing-total-returns.action?t=SPY","div",-1,"return
as of"),"as of ",".")) Trailing Total ReturnsETF -- Price -- 1-Day
=RCHGetTableCell("
http://performance.morningstar.com/Performance/cef/trailing-total-returns.action?t=SPY",1,">Total
Return %","(Price)") Trailing Total ReturnsETF -- Price -- 1-Week
=RCHGetTableCell("
http://performance.morningstar.com/Performance/cef/trailing-total-returns.action?t=SPY",2,">Total
Return %","(Price)") Trailing Total ReturnsETF -- Price -- 1-Month
=RCHGetTableCell("
http://performance.morningstar.com/Performance/cef/trailing-total-returns.action?t=SPY",3,">Total
Return %","(Price)") Trailing Total ReturnsETF -- Price -- 3-Month
=RCHGetTableCell("
http://performance.morningstar.com/Performance/cef/trailing-total-returns.action?t=SPY",4,">Total
Return %","(Price)") Trailing Total ReturnsETF -- Price -- YTD
=RCHGetTableCell("
http://performance.morningstar.com/Performance/cef/trailing-total-returns.action?t=SPY",5,">Total
Return %","(Price)") Trailing Total ReturnsETF -- Price -- 1-Year
=RCHGetTableCell("
http://performance.morningstar.com/Performance/cef/trailing-total-returns.action?t=SPY",6,">Total
Return %","(Price)") Trailing Total ReturnsETF -- Price -- 3-Year
=RCHGetTableCell("
http://performance.morningstar.com/Performance/cef/trailing-total-returns.action?t=SPY",7,">Total
Return %","(Price)") Trailing Total ReturnsETF -- Price -- 5-Year
=RCHGetTableCell("
http://performance.morningstar.com/Performance/cef/trailing-total-returns.action?t=SPY",8,">Total
Return %","(Price)") Trailing Total ReturnsETF -- Price -- 10-Year
=RCHGetTableCell("
http://performance.morningstar.com/Performance/cef/trailing-total-returns.action?t=SPY",9,">Total
Return %","(Price)") Trailing Total ReturnsETF -- Price -- 15-Year
=RCHGetTableCell("
http://performance.morningstar.com/Performance/cef/trailing-total-returns.action?t=SPY",10,">Total
Return %","(Price)") Trailing Total ReturnsETF -- NAV -- 1-Day
=RCHGetTableCell("
http://performance.morningstar.com/Performance/cef/trailing-total-returns.action?t=SPY",1,">Total
Return %","(NAV)") Trailing Total ReturnsETF -- NAV -- 1-Week
=RCHGetTableCell("
http://performance.morningstar.com/Performance/cef/trailing-total-returns.action?t=SPY",2,">Total
Return %","(NAV)") Trailing Total ReturnsETF -- NAV -- 1-Month
=RCHGetTableCell("
http://performance.morningstar.com/Performance/cef/trailing-total-returns.action?t=SPY",3,">Total
Return %","(NAV)") Trailing Total ReturnsETF -- NAV -- 3-Month
=RCHGetTableCell("
http://performance.morningstar.com/Performance/cef/trailing-total-returns.action?t=SPY",4,">Total
Return %","(NAV)") Trailing Total ReturnsETF -- NAV -- YTD=RCHGetTableCell("
http://performance.morningstar.com/Performance/cef/trailing-total-returns.action?t=SPY",5,">Total
Return %","(NAV)") Trailing Total ReturnsETF -- NAV -- 1-Year
=RCHGetTableCell("
http://performance.morningstar.com/Performance/cef/trailing-total-returns.action?t=SPY",6,">Total
Return %","(NAV)") Trailing Total ReturnsETF -- NAV -- 3-Year
=RCHGetTableCell("
http://performance.morningstar.com/Performance/cef/trailing-total-returns.action?t=SPY",7,">Total
Return %","(NAV)") Trailing Total ReturnsETF -- NAV -- 5-Year
=RCHGetTableCell("
http://performance.morningstar.com/Performance/cef/trailing-total-returns.action?t=SPY",8,">Total
Return %","(NAV)") Trailing Total ReturnsETF -- NAV -- 10-Year
=RCHGetTableCell("
http://performance.morningstar.com/Performance/cef/trailing-total-returns.action?t=SPY",9,">Total
Return %","(NAV)") Trailing Total ReturnsETF -- NAV -- 15-Year
=RCHGetTableCell("
http://performance.morningstar.com/Performance/cef/trailing-total-returns.action?t=SPY",10,">Total
Return %","(NAV)") ETF SummaryExpenses=smfConvertData(smfGetTagContent("
http://etfs.morningstar.com/quote-banner?&t=SPY","span",1,"ExpenseRatio"))
Portfolio
SummaryStar Rating=smfConvertData(smfstrExtr(smfGetTagContent("
http://portfolios.morningstar.com/fund/summary?t=SPY
","div",-1,"r_star"),"r_star","'"))

On Tue, Jun 9, 2015 at 8:16 AM, biignez@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> The following ETF elements do not appear to have lookups:
>
> -
>
> Fees
> -
>
> Morningstar Rating
> -
>
> YTD (only 1 day, 1 month)
> -
>
> 3 Year, 5 Year, 10 Year as-of trailing performance
>
> Is this true or am I just overlooking something? - Thanks for any help.
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar