Jumat, 02 Januari 2015

[smf_addin] Digest Number 3283

5 Messages

Digest #3283

Messages

Thu Jan 1, 2015 9:31 am (PST) . Posted by:

krisha_mehta


Hi Randy,
I searched some of your messages and as I understand the smfPricesByDates() function includes dividends and distributions,etc. However, I am confused when using this for a specific mutual fund - FCNTX.
It's showing me an annual return of about 4%, however yahoo finance shows annual return of about 12% which is really confusing..
I am using the following formula to calculate 1 year return -
= (smfPricesByDates(A47,NOW()-1) - smfPricesByDates(A47,NOW()-366))/ smfPricesByDates(A47, NOW()-366)


Thanks in advance and wish you Happy New Year and appreciate everything that you do to keep this group alive and active.


Thu Jan 1, 2015 9:57 am (PST) . Posted by:

"Randy Harmelink" rharmelink

That's because the numbers on the performance page:

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

...say they are "as of Nov 29, 2014". So the formula you would want for
comparison is:

=(smfPricesByDates(L3,DATE(2014,11,29))-smfPricesByDates(L3,DATE(2013,11,29)))/smfPricesByDates(L3,DATE(2013,11,29))

...which gives a result of 12.89%.

On Thu, Jan 1, 2015 at 10:31 AM, krisha_mehta@...wrote:

> I searched some of your messages and as I understand the
> smfPricesByDates() function includes dividends and distributions,etc.
> However, I am confused when using this for a specific mutual fund - FCNTX.
>
> It's showing me an annual return of about 4%, however yahoo finance shows
> annual return of about 12% which is really confusing..
>
> I am using the following formula to calculate 1 year return -
>
> = (smfPricesByDates(A47,NOW()-1) - smfPricesByDates(A47,NOW()-366))/
> smfPricesByDates(A47, NOW()-366)
>
> Thanks in advance...
>

Thu Jan 1, 2015 10:44 am (PST) . Posted by:

krisha_mehta

Thanks for the quick response, I didn't realize a big swing in about a month.

Thu Jan 1, 2015 12:30 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Probably not on most of the source-specific functions. For example, in
order for smfPricesByDates() to work, Yahoo has to have historical quotes.

But if you have a data source that carries data for Indian stocks, you may
be able to use functions like RCHGetTableCell(), smfGetTagContent(), or
RCHGetWebData() to extract the data you want.

On Thu, Jan 1, 2015 at 1:16 PM, askrohit20@... wrote:

>
> IS SMF addin does not retrieve indian stocks ??
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Posting Komentar