Minggu, 01 Februari 2015

[smf_addin] Digest Number 3308

4 Messages

Digest #3308

Messages

Sat Jan 31, 2015 5:00 am (PST) . Posted by:

panda317

First, please accept my apology for my ineptness...

I've asked for help before get Yield and 1yr. Return data for stock quotes using finviz.

Now, I'm trying to get the same thing from Yahoo but for Mutual Funds.

What would I need to change in the following formulae to get Yield and 1Yr. Return data for Mutual Funds from Yahoo.

In my Spreadsheets, the symbol is in Column D, so for my stock quotes I have;

=RCHGetTableCell("http://finviz.com/quote.ashx?t="&smfJoin($D2:$D$16,","),1,"?t="&$D2&"&",">Dividend %")

which gives me the yield

and

=RCHGetTableCell("http://finviz.com/quote.ashx?t="&smfJoin($D2:$D$16,","),1,"?t="&$D2&"&",">Perf Year")

which gives me the 1yr. return

Any help would be greatly appreciated (again)!

Best,

Pat




Sat Jan 31, 2015 5:13 am (PST) . Posted by:

"Randy Harmelink" rharmelink

They are defined as elements:

=RCHGetElementNumber("VFINX",5063)
=RCHGetElementNumber("VFINX",4946)

Note that the performance data on Yahoo is usually not current:

http://finance.yahoo.com/q/pm?s=VFINX

...says "as of Dec 31". A month old. Same for yield, although that won't
change as much.

On Sat, Jan 31, 2015 at 6:00 AM, pat@patrosenheim.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> First, please accept my apology for my ineptness...
>
> I've asked for help before get Yield and 1yr. Return data for stock quotes
> using finviz.
>
> Now, I'm trying to get the same thing from Yahoo but for Mutual Funds.
>
> What would I need to change in the following formulae to get Yield and
> 1Yr. Return data for Mutual Funds from Yahoo.
>
> In my Spreadsheets, the symbol is in Column D, so for my stock quotes I
> have;
>
> =RCHGetTableCell("http://finviz.com/quote.ashx?t="&smfJoin($D2:$D$16,","),1,"?t="&$D2&"&",">Dividend
> %")
>
> which gives me the yield
>
> and
>
> =RCHGetTableCell("http://finviz.com/quote.ashx?t="&smfJoin($D2:$D$16,","),1,"?t="&$D2&"&",">Perf
> Year")
>
> which gives me the 1yr. return
>
> Any help would be greatly appreciated (again)!
>

Sat Jan 31, 2015 8:10 pm (PST) . Posted by:

panda317

Is there a better place to get current yield and return for mutual funds?

And what's the format for that?

Thanks in advance!

Sat Jan 31, 2015 9:33 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

For performance, I usually compute them myself by getting the adjusted
closing prices from Yahoo using the smfPricesByDates() function. See these
templates:

http://ogres-crypt.com/SMF/Templates/#smfPricesByDates%28%29

You could go to MorningStar. They are the ones that provide Yahoo with
performance data. There data is currently as of 01/30/2015, but I don't
know if it's up-to-date because we're currently *AT* a month-end, or if
they update it daily. To get it from their website:

=RCHGetTableCell("
http://performance.morningstar.com/Performance/fund/trailing-total-returns.action?t=VFINX
",6,"class=""row_lbl""")

For yield from MorningStar:

=smfConvertData(smfGetTagContent("
http://quotes.morningstar.com/fund/c-header?t=VFINX
","span",1,"gkey=""ttmYield"""))

However, note that that will be two Internet accesses per ticker symbol.
You wouldn't want to do that for a large number of mutual funds.

On Sat, Jan 31, 2015 at 9:10 PM, pat@patrosenheim.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Is there a better place to get current yield and return for mutual funds?
>
> And what's the format for that?
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Diposting oleh EXCEL FEED LEARNING di 05.09

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)