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(
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(
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...
>
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(
...which gives a result of 12.89%.
On Thu, Jan 1, 2015 at 10:31 AM, krisha_mehta@
> I searched some of your messages and as I understand the
> smfPricesByDates(
> 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(
> smfPricesByDates(
>
> 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:27 pm (PST) . Posted by:
askrohit20
IS SMF addin does not retrieve indian stocks ??
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 ??
>
order for smfPricesByDates(
But if you have a data source that carries data for Indian stocks, you may
be able to use functions like RCHGetTableCell(
RCHGetWebData(
On Thu, Jan 1, 2015 at 1:16 PM, askrohit20@.
>
> 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