6 Messages
Digest #3429
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!
=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=""
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.
>
>
=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=""
>
> 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!
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.
>
>
>
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@.
>
> 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.
>
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:
Posting Komentar