[smf_addin] Digest Number 2076

EXCEL Stock Market Functions Add-in

Messages In This Digest (17 Messages)

1.1.

Re: smfPrice by and between From: antonvanas1989

1.2.

Re: smfPrice by and between From: Randy Harmelink

1.3.

Re: smfPrice by and between From: antonvanas1989

1.4.

Re: smfPrice by and between From: Randy Harmelink

2a.

52w L & H From: V. Shankar

2b.

Re: 52w L & H From: Randy Harmelink

2c.

Re: 52w L & H From: V. Shankar

2d.

Re: 52w L & H From: Randy Harmelink

3a.

Help Using Template and Example Files From: nlavery

3b.

Re: Help Using Template and Example Files From: Randy Harmelink

4a.

smfPricesBetween(A35,NOW()-365, NOW(),"1008") From: krisha_mehta

4b.

Re: smfPricesBetween(A35,NOW()-365, NOW(),"1008") From: Randy Harmelink

4c.

Re: smfPricesBetween(A35,NOW()-365, NOW(),"1008") From: krisha_mehta

4d.

Re: smfPricesBetween(A35,NOW()-365, NOW(),"1008") From: Randy Harmelink

4e.

Re: smfPricesBetween(A35,NOW()-365, NOW(),"1008") From: krisha_mehta

4f.

Re: smfPricesBetween(A35,NOW()-365, NOW(),"1008") From: Randy Harmelink

4g.

Re: smfPricesBetween(A35,NOW()-365, NOW(),"1008") From: krisha_mehta

View All Topics | Create New Topic

Messages

1.1.

Re: smfPrice by and between

Posted by: "antonvanas1989" antonvanas1989@yahoo.com   antonvanas1989

Sat Jan 14, 2012 2:15 am (PST)

Randy,

One more question about the yahoo close price (not adjusted)

The close price of let say 31-12-2010 is the like 50 dollar. but if there was a stocksplit before the price is already adjusted and the annual report shows the "splitted outstanding shares" so the ratios i make are fine right? (i only do ratios like price to sales wich advfn not shows)

this would be oke right?

For an chart i use the adjusted yahoo historie so that the chart is correct

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> You can get them from here:
>
> =RCHGetHTMLTable("
> http://ycharts.com/companies/MMM/historical_data/dividend_yield?start_month=1&start_day=12&start_year=2001&end_month=1&end_day=12&end_year=2012
> ","<",1,"",1)
>
> On Thu, Jan 12, 2012 at 2:00 PM, antonvanas1989 <antonvanas1989@...>wrote:
>
> > Building the sheet now but i can't even have historical "dividend yield" ..
> >
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (30)

1.2.

Re: smfPrice by and between

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Sat Jan 14, 2012 2:24 am (PST)

I think P/S should be the same as AdvFN's Price/Revenue ratio.

In any case, I agree with your statement about splits and shares and dates.

On Sat, Jan 14, 2012 at 3:15 AM, antonvanas1989 <antonvanas1989@yahoo.com>wrote:

>
> One more question about the yahoo close price (not adjusted)
>
> The close price of let say 31-12-2010 is the like 50 dollar. but if there
> was a stocksplit before the price is already adjusted and the annual report
> shows the "splitted outstanding shares" so the ratios i make are fine
> right? (i only do ratios like price to sales wich advfn not shows)
>
> this would be oke right?
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (30)

1.3.

Re: smfPrice by and between

Posted by: "antonvanas1989" antonvanas1989@yahoo.com   antonvanas1989

Sat Jan 14, 2012 4:21 am (PST)

I see, thanxs

One thing i don't get about Advfn..
P/S Ratio usus shares outstanding (not diluted)
P/E ratio uses diluted earnings
Bookvalue uses shares outstanding (not diluted)

Why is advfn not using all ratios diluted or none diluted?

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> I think P/S should be the same as AdvFN's Price/Revenue ratio.
>
> In any case, I agree with your statement about splits and shares and dates.
>
> On Sat, Jan 14, 2012 at 3:15 AM, antonvanas1989 <antonvanas1989@...>wrote:
>
> >
> > One more question about the yahoo close price (not adjusted)
> >
> > The close price of let say 31-12-2010 is the like 50 dollar. but if there
> > was a stocksplit before the price is already adjusted and the annual report
> > shows the "splitted outstanding shares" so the ratios i make are fine
> > right? (i only do ratios like price to sales wich advfn not shows)
> >
> > this would be oke right?
> >
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (30)

1.4.

Re: smfPrice by and between

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Sat Jan 14, 2012 7:33 am (PST)

Not a question for me...

On Sat, Jan 14, 2012 at 5:21 AM, antonvanas1989 <antonvanas1989@yahoo.com>wrote:

>
> One thing i don't get about Advfn..
> P/S Ratio usus shares outstanding (not diluted)
> P/E ratio uses diluted earnings
> Bookvalue uses shares outstanding (not diluted)
>
> Why is advfn not using all ratios diluted or none diluted?
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (30)

2a.

52w L & H

Posted by: "V. Shankar" tarakayan@yahoo.com   tarakayan

Sat Jan 14, 2012 2:32 am (PST)

do we have a code for getting dates for these L & H prices?

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)

2b.

Re: 52w L & H

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Sat Jan 14, 2012 3:37 am (PST)

You can use the RCHGetYahooQuotes() function to get them from Yahoo.

BarChart has H/L for a number of periods, including their dates:

http://www.barchart.com/detailedquote/stocks/MMM

On Sat, Jan 14, 2012 at 3:32 AM, V. Shankar <tarakayan@yahoo.com> wrote:

>
> do we have a code for getting dates for these L & H prices?
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)

2c.

Re: 52w L & H

Posted by: "V. Shankar" tarakayan@yahoo.com   tarakayan

Sat Jan 14, 2012 8:46 pm (PST)

Thanks Randy.  
>
>
>You can use the RCHGetYahooQuotes() function to get them from Yahoo.
>
>Is there a code to get dates associated with "j" & "k" in excel?
>
>
>
>
>
>BarChart has H/L for a number of periods, including their dates:
>
>http://www.barchart.com/detailedquote/stocks/MMM
>
>
>On Sat, Jan 14, 2012 at 3:32 AM, V. Shankar <tarakayan@yahoo.com> wrote:
>
>
>>
>>do we have a code for getting dates for these L & H prices?
>>
>
>
>
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)

2d.

Re: 52w L & H

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Sat Jan 14, 2012 8:56 pm (PST)

Not that I'm aware of. You could get the dates if you extracted them from
the barchart.com link I gave.

Or, take a look at the smfPricesBetween() function.

But both of those methods will be require one Internet access per ticker
symbol, which could be slow if you need them for a lot of equities.

On Sat, Jan 14, 2012 at 9:46 PM, V. Shankar <tarakayan@yahoo.com> wrote:

>
> You can use the RCHGetYahooQuotes() function to get them from Yahoo.
> Is there a code to get dates associated with "j" & "k" in excel?
>
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (4)

3a.

Help Using Template and Example Files

Posted by: "nlavery" toby.avery@gmail.com   nlavery

Sat Jan 14, 2012 6:20 am (PST)

I wondered if anyone can help me with problems I've been having opening the and example files. I am using a new Win 7 x64 laptop and did not seem to have this same problem with my older XP laptop. I have installed the .xla add-in into C:\Program Files\SMF Add-In and added the add-in in Tools/Add-Ins in Excel. But when I download and 'save as' the example or template files I am not able to get them to work properly. I click on "Update" and then "Edit Links" and "Change Source" and navigate to the xla add-in. But I then get error messages that say something to the effect that Excel cannot find RCHGetTableCell on RCH_Stock_Market_Function.xla.....or smfStrExt or smfgetTagContent.

It seems I'm doing something fundamentally wrong but I cannot figure it out, and hope that someone can set me straight.

Thanks........Toby

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)

3b.

Re: Help Using Template and Example Files

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Sat Jan 14, 2012 7:35 am (PST)

Check the "Location Error" item in the "Links" area of the group -- it's
not you, it's an EXCEL thing.

On Sat, Jan 14, 2012 at 7:20 AM, nlavery <toby.avery@gmail.com> wrote:

> I wondered if anyone can help me with problems I've been having opening
> the and example files. I am using a new Win 7 x64 laptop and did not seem
> to have this same problem with my older XP laptop. I have installed the
> .xla add-in into C:\Program Files\SMF Add-In and added the add-in in
> Tools/Add-Ins in Excel. But when I download and 'save as' the example or
> template files I am not able to get them to work properly. I click on
> "Update" and then "Edit Links" and "Change Source" and navigate to the xla
> add-in. But I then get error messages that say something to the effect
> that Excel cannot find RCHGetTableCell on
> RCH_Stock_Market_Function.xla.....or smfStrExt or smfgetTagContent.
>
> It seems I'm doing something fundamentally wrong but I cannot figure it
> out, and hope that someone can set me straight.
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)

4a.

smfPricesBetween(A35,NOW()-365, NOW(),"1008")

Posted by: "krisha_mehta" krisha_mehta@yahoo.com   krisha_mehta

Sat Jan 14, 2012 3:33 pm (PST)

I am getting an unexpected result when using this formula. For example if I have HDB in A35, I get 2980%. I am trying to calculated 1 year, 3 years return including dividends.

Thanks in advance

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (7)

4b.

Re: smfPricesBetween(A35,NOW()-365, NOW(),"1008")

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Sat Jan 14, 2012 3:44 pm (PST)

The function isn't returning a percentage change. It would be returning two
adjusted prices. Today, those two values are $29.80 and $27.85. So the
2980% you're seeing is actually the first price. You'd need to calculate
the percentage return yourself using those two prices.

On Sat, Jan 14, 2012 at 4:33 PM, krisha_mehta <krisha_mehta@yahoo.com>wrote:

> I am getting an unexpected result when using this formula. For example if
> I have HDB in A35, I get 2980%. I am trying to calculated 1 year, 3 years
> return including dividends.
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (7)

4c.

Re: smfPricesBetween(A35,NOW()-365, NOW(),"1008")

Posted by: "krisha_mehta" krisha_mehta@yahoo.com   krisha_mehta

Sat Jan 14, 2012 4:14 pm (PST)

OK, understood. Can you please suggest the best way to calculate 1-year, 5-year annualized returns that includes dividends re-invested.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> The function isn't returning a percentage change. It would be returning two
> adjusted prices. Today, those two values are $29.80 and $27.85. So the
> 2980% you're seeing is actually the first price. You'd need to calculate
> the percentage return yourself using those two prices.
>
> On Sat, Jan 14, 2012 at 4:33 PM, krisha_mehta <krisha_mehta@...>wrote:
>
> > I am getting an unexpected result when using this formula. For example if
> > I have HDB in A35, I get 2980%. I am trying to calculated 1 year, 3 years
> > return including dividends.
> >
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (7)

4d.

Re: smfPricesBetween(A35,NOW()-365, NOW(),"1008")

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Sat Jan 14, 2012 4:19 pm (PST)

I would just use smfPricesByDates() to get the necessary prices, then
calculate the returns.

On Sat, Jan 14, 2012 at 5:14 PM, krisha_mehta <krisha_mehta@yahoo.com>wrote:

>
> Can you please suggest the best way to calculate 1-year, 5-year annualized
> returns that includes dividends re-invested.
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (7)

4e.

Re: smfPricesBetween(A35,NOW()-365, NOW(),"1008")

Posted by: "krisha_mehta" krisha_mehta@yahoo.com   krisha_mehta

Sat Jan 14, 2012 6:46 pm (PST)

Hi Randy,

I re-ran RCH_Stock_Market_Functions.xla in my Excel, somehow I don't see smfPricesByDates() available to use in Insert Functions. I can see smfPricesBetween but not this one.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> I would just use smfPricesByDates() to get the necessary prices, then
> calculate the returns.
>
> On Sat, Jan 14, 2012 at 5:14 PM, krisha_mehta <krisha_mehta@...>wrote:
>
> >
> > Can you please suggest the best way to calculate 1-year, 5-year annualized
> > returns that includes dividends re-invested.
> >
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (7)

4f.

Re: smfPricesBetween(A35,NOW()-365, NOW(),"1008")

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Sat Jan 14, 2012 6:57 pm (PST)

I'm not sure what you mean by "re-ran" the xla...

What version of the add-in are you using? I think the function has been
around since version 2.0i.

=RCHGetElementNumber("Version")

On Sat, Jan 14, 2012 at 7:46 PM, krisha_mehta <krisha_mehta@yahoo.com>wrote:

>
> Hi Randy,
>
> I re-ran RCH_Stock_Market_Functions.xla in my Excel, somehow I don't see
> smfPricesByDates() available to use in Insert Functions. I can see
> smfPricesBetween but not this one.
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (7)

4g.

Re: smfPricesBetween(A35,NOW()-365, NOW(),"1008")

Posted by: "krisha_mehta" krisha_mehta@yahoo.com   krisha_mehta

Sat Jan 14, 2012 8:11 pm (PST)

Got it, my windows 7 machine virtualized the new version install hence not available in Excel. Now it works, I fixed it.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> I'm not sure what you mean by "re-ran" the xla...
>
> What version of the add-in are you using? I think the function has been
> around since version 2.0i.
>
> =RCHGetElementNumber("Version")
>
> On Sat, Jan 14, 2012 at 7:46 PM, krisha_mehta <krisha_mehta@...>wrote:
>
> >
> > Hi Randy,
> >
> > I re-ran RCH_Stock_Market_Functions.xla in my Excel, somehow I don't see
> > smfPricesByDates() available to use in Insert Functions. I can see
> > smfPricesBetween but not this one.
> >
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (7)

Recent Activity

•  114
  New Members

Visit Your Group

Yahoo! News

Fashion News

What's the word on

fashion and style?

Yahoo! Finance

It's Now Personal

Guides, news,

advice & more.

Ads on Yahoo!

Learn more now.

Reach customers

searching for you.

Need to Reply?

Click one of the "Reply" links to respond to a specific message in the Daily Digest.

Create New Topic | Visit Your Group on the Web

Messages | Files | Photos | Polls

MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Individual | Switch format to Traditional
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe