[smf_addin] Digest Number 3108

EXCEL Stock Market Functions Add-in Group

8 Messages

Digest #3108

1a

RCHGetYahooQuotes() function by DefelRadar

1b

Re: RCHGetYahooQuotes() function by "Randy Harmelink" rharmelink

2a

Re: problem accessing Reuters data by drminvest

2b

Re: problem accessing Reuters data by "Randy Harmelink" rharmelink

3a

Best Ben Graham Value Investing Template by electronicjason

3b

Re: Best Ben Graham Value Investing Template by "Randy Harmelink" rharmelink

4a

emma help by Buck_69_69

4b

Re: emma help by "Randy Harmelink" rharmelink

Messages

1a

RCHGetYahooQuotes() function

Mon Jun 30, 2014 4:58 am (PDT) . Posted by:

DefelRadar

Randy,

I'm trying to use the RCHGetYahooQuotes() function to return the weekly Open/High/Low/Close values for mutual funds and I'm having a few problems.

First if I follow your example in the documentation to get one day historical quote for a stock (i.e. IBM) it works great.

If I do it for a mutual fund for a week and making the start and end dates the exact same year,month,day then it always returns the same value and it appears to be the Open price no matter if I tell it High, Low, Close etc.

So then I tried to do the Monday of the week (i.e. 2014,5,27) and the Tuesday of the week (i.e. 2014,5,28) Everything comes back correctly except for the Close price. It looks like it is the High price for the week.

I was just trying to figure out what I was doing wrong.

Thanks,

Aaron

Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . Top ^

1b

Re: RCHGetYahooQuotes() function

Mon Jun 30, 2014 9:32 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Sounds like you're talking about RCHGetYahooHistory() instead of
RCHGetYahooQuotes().

For any given day, the open/high/low/close on a mutual fund will always be
the same. They only trade at the end of the day.

On Mon, Jun 30, 2014 at 4:58 AM, defelradar@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
>
> I'm trying to use the RCHGetYahooQuotes() function to return the weekly
> Open/High/Low/Close values for mutual funds and I'm having a few problems.
>
> First if I follow your example in the documentation to get one day
> historical quote for a stock (i.e. IBM) it works great.
>
> If I do it for a mutual fund for a week and making the start and end dates
> the exact same year,month,day then it always returns the same value and it
> appears to be the Open price no matter if I tell it High, Low, Close etc.
>
> So then I tried to do the Monday of the week (i.e. 2014,5,27) and the
> Tuesday of the week (i.e. 2014,5,28) Everything comes back correctly except
> for the Close price. It looks like it is the High price for the week.
>
> I was just trying to figure out what I was doing wrong.
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . Top ^

2a

Re: problem accessing Reuters data

Mon Jun 30, 2014 6:38 am (PDT) . Posted by:

drminvest

Thanks Randy,

Now I can get the data from Reuters.


Now I have a different problem, to get the data from the table:


Using the command =RCHGetWebData("http://www.reuters.com/finance/stocks/incomeStatement/detail?stmtType=INC&perType=ANN&symbol=KO",51133,,,) I see that there are the data of 5 years, the ones that I want to get.


The problem appears when I use the RCHGetTableCell


=RCHGetTableCell("http://www.reuters.com/finance/stocks/incomeStatement?perType=ANN&symbol=KO",1,"dataTable financial",,,,2,"</TABLE",,) works fine -> ("Revenue")


=RCHGetTableCell("http://www.reuters.com/finance/stocks/incomeStatement?perType=ANN&symbol=KO",1,"dataTable financial",,,,2,"</TABLE",,) also works fine and I get the Revenues of the first year -> (46854)



but


=RCHGetTableCell("http://www.reuters.com/finance/stocks/incomeStatement?perType=ANN&symbol=KO",3,"dataTable financial",,,,2,"</TABLE",,) does not work and give me an error
-> (error)


Thanks in advance for your help

Reply to sender . Reply to group . Reply via Web Post . All Messages (4) . Top ^

2b

Re: problem accessing Reuters data

Mon Jun 30, 2014 9:43 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Your later formulas are working properly, just not the way you expect,
because they are using a different URL than the first formula. If you go to
that web page in your last three formulas, it only has one period of data.
If you want more, you have to click a link for more detail. That link
brings you to the URL in your first formula -- note the "/detail" suffix on
the URL prior to the parameters.

On Mon, Jun 30, 2014 at 6:38 AM, diegoreal@... wrote:

>
> Now I can get the data from Reuters.
>
> Now I have a different problem, to get the data from the table:
>
> Using the command =RCHGetWebData("
> http://www.reuters.com/finance/stocks/incomeStatement/detail?stmtType=INC&perType=ANN&symbol=KO",51133,,,)
> I see that there are the data of 5 years, the ones that I want to get.
>
> The problem appears when I use the RCHGetTableCell
>
> =RCHGetTableCell("
> http://www.reuters.com/finance/stocks/incomeStatement?perType=ANN&symbol=KO",1,"dataTable
> financial",,,,2,"</TABLE",,) works fine -> ("Revenue")
>
> =RCHGetTableCell("
> http://www.reuters.com/finance/stocks/incomeStatement?perType=ANN&symbol=KO",1,"dataTable
> financial",,,,2,"</TABLE",,) also works fine and I get the Revenues of the
> first year -> (46854)
>
> but
>
> =RCHGetTableCell("
> http://www.reuters.com/finance/stocks/incomeStatement?perType=ANN&symbol=KO",3,"dataTable
> financial",,,,2,"</TABLE",,) does not work and give me an error
> -> (error)
>
> Thanks in advance for your help
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (4) . Top ^

3a

Best Ben Graham Value Investing Template

Mon Jun 30, 2014 9:21 am (PDT) . Posted by:

electronicjason

What is the best value investing template for the SMF Add In? Something along Ben Graham's Intelligent Investor or Security Analysis.

Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . Top ^

3b

Re: Best Ben Graham Value Investing Template

Mon Jun 30, 2014 9:45 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Sounds to me like you're more interesting in a screening tool. I'd suggest
Portfolio123.com or AAII's Stock Investor Pro.

On Mon, Jun 30, 2014 at 9:12 AM, electronicjason@...wrote:

>
> What is the best value investing template for the SMF Add In? Something
> along Ben Graham's Intelligent Investor or Security Analysis.
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . Top ^

4a

emma help

Mon Jun 30, 2014 2:42 pm (PDT) . Posted by:

Buck_69_69

hi i'm having problems extracting the trade date for this particular cusip 251129R61

on my excel the cusip is on cell A1 and i'm using this statement

RCHGetTableCell("http://emma.msrb.org/SecurityDetails/TradeActivity.aspx?cusip="&A1,1,"TradeDate&quot;,,,,1)

but nothing seems to be coming back

grateful for any assistance

Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . Top ^

4b

Re: emma help

Mon Jun 30, 2014 2:58 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

That comes back as a bad URL for me:

http://emma.msrb.org/SecurityDetails/TradeActivity.aspx?cusip=251129R61

On Mon, Jun 30, 2014 at 2:42 PM, buck_69_69@... wrote:

>
> hi i'm having problems extracting the trade date for this particular cusip
> 251129R61
>
> on my excel the cusip is on cell A1 and i'm using this statement
>
> RCHGetTableCell("
> http://emma.msrb.org/SecurityDetails/TradeActivity.aspx?cusip=
> "&A1,1,"TradeDate&quot;,,,,1)
>
> but nothing seems to be coming back
>
> grateful for any assistance
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . Top ^

For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Visit Your Group

• New Members 50

• Privacy • Unsubscribe • Terms of Use