Selasa, 06 Desember 2011

[smf_addin] Digest Number 2037

Messages In This Digest (5 Messages)

Messages

1a.

Reuters data using RCHGetElementNumber

Posted by: "jrgeico" rerren.jeroen@gmail.com   jrgeico

Mon Dec 5, 2011 3:15 pm (PST)



Hye guys,

since I discovered this site a few weeks back I have occupied myself with reading VBA books (unfortunately i had to start with the one for dummies :D) and trying to learn excel.

Recently I drew out my "own" approach to pricing stocks and I am now trying to assemble sheets that are available here together with my own input in terms of ratios etc..

Unfortunately, I am experiencing the same problem as a few other users with loading data from Reuters. As I favor a proactive approach I tried to solve this problem on my own and used the following site to download Reuters data into my excel file:

http://www.aaii.com/computerized-investing/article/using-excel-web-queries-to-retrieve-data.mobile#fig5

I thought that if I was able to enable this web query the cookie (and other) problems would be solved. I managed to download the financial statement for Google (I just followed the example) but the connection did not make the RCHGetElementNumber work....

Also, when I try to edit my query to provide input for Statement, Period and ticker like this:

WEB
1
http://www.reuters.com/finance/stocks/incomeStatement/detail?perType=["Statement", "Enter INC, BAL, or CAS"]&perType=["Period", "Enter Ann or INT"]&symbol=["symbol", "Enter ticker symbol"]

Selection=AllTables
Formatting=None
PreFormattedTextToColumns=True
ConsecutiveDelimitersAsOne=True
SingleBlockTextImport=False
DisableDateRecognition=False
DisableRedirections=False
"

the cookie is displayed in excel as "broken" or not the right file type...

Anyone who can help me with this?

Summary:

Able to download Reuters data using web query
Not able to download using RCHGetElementNumber number

I am operating on Excel 2010. If additional information is needed please do ask :)

Thanks

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)
1b.

Re: Reuters data using RCHGetElementNumber

Posted by: "Mike McQuaid" mikemcq802@yahoo.com   mikemcq802

Mon Dec 5, 2011 3:26 pm (PST)



I"m not familiar with problems others are having but the following works
fine for me:

=RCHGetElementNumber("MCD",13626)

This is a Reuters ttm P/E Ratio for MCD. I did nothing special to get this
to work. What Reuters element and ticker are you trying?

_____

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf
Of jrgeico
Sent: Monday, December 05, 2011 4:18 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Reuters data using RCHGetElementNumber

Hye guys,

since I discovered this site a few weeks back I have occupied myself with
reading VBA books (unfortunately i had to start with the one for dummies :D)
and trying to learn excel.

Recently I drew out my "own" approach to pricing stocks and I am now trying
to assemble sheets that are available here together with my own input in
terms of ratios etc..

Unfortunately, I am experiencing the same problem as a few other users with
loading data from Reuters. As I favor a proactive approach I tried to solve
this problem on my own and used the following site to download Reuters data
into my excel file:

http://www.aaii.com/computerized-investing/article/using-excel-web-queries-t
o-retrieve-data.mobile#fig5

I thought that if I was able to enable this web query the cookie (and other)
problems would be solved. I managed to download the financial statement for
Google (I just followed the example) but the connection did not make the
RCHGetElementNumber work....

Also, when I try to edit my query to provide input for Statement, Period and
ticker like this:

WEB
1
http://www.reuters.com/finance/stocks/incomeStatement/detail?perType=["State
ment", "Enter INC, BAL, or CAS"]&perType=["Period", "Enter Ann or
INT"]&symbol=["symbol", "Enter ticker symbol"]

Selection=AllTables
Formatting=None
PreFormattedTextToColumns=True
ConsecutiveDelimitersAsOne=True
SingleBlockTextImport=False
DisableDateRecognition=False
DisableRedirections=False
"

the cookie is displayed in excel as "broken" or not the right file type...

Anyone who can help me with this?

Summary:

Able to download Reuters data using web query
Not able to download using RCHGetElementNumber number

I am operating on Excel 2010. If additional information is needed please do
ask :)

Thanks

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)
1c.

Re: Reuters data using RCHGetElementNumber

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

Mon Dec 5, 2011 3:33 pm (PST)



You probably just need the updated element definitions for Reuters from the
"Works in Progress" folder of the files area. They made changes to their
website structure earlier this year. However, none of those elements are
financial statements data. But you should be able to get the financial
statements data with the other add-in functions.

For example:

=RCHGetHTMLTable("
http://www.reuters.com/finance/stocks/incomeStatement/detail?stmtType=INC&perType=ANN&symbol=MMM.N
",">Revenue",-1,"",1)

=RCHGetTableCell("
http://www.reuters.com/finance/stocks/incomeStatement/detail?stmtType=INC&perType=ANN&symbol=MMM.N
",1,">Revenue")

On Mon, Dec 5, 2011 at 2:18 PM, jrgeico <rerren.jeroen@gmail.com> wrote:

> Hye guys,
>
> since I discovered this site a few weeks back I have occupied myself with
> reading VBA books (unfortunately i had to start with the one for dummies
> :D) and trying to learn excel.
>
> Recently I drew out my "own" approach to pricing stocks and I am now
> trying to assemble sheets that are available here together with my own
> input in terms of ratios etc..
>
> Unfortunately, I am experiencing the same problem as a few other users
> with loading data from Reuters. As I favor a proactive approach I tried to
> solve this problem on my own and used the following site to download
> Reuters data into my excel file:
>
>
> http://www.aaii.com/computerized-investing/article/using-excel-web-queries-to-retrieve-data.mobile#fig5
>
> I thought that if I was able to enable this web query the cookie (and
> other) problems would be solved. I managed to download the financial
> statement for Google (I just followed the example) but the connection did
> not make the RCHGetElementNumber work....
>
> Also, when I try to edit my query to provide input for Statement, Period
> and ticker like this:
>
> WEB
> 1
> http://www.reuters.com/finance/stocks/incomeStatement/detail?perType=["Statement",
> "Enter INC, BAL, or CAS"]&perType=["Period", "Enter Ann or
> INT"]&symbol=["symbol", "Enter ticker symbol"]
>
> Selection=AllTables
> Formatting=None
> PreFormattedTextToColumns=True
> ConsecutiveDelimitersAsOne=True
> SingleBlockTextImport=False
> DisableDateRecognition=False
> DisableRedirections=False
> "
>
> the cookie is displayed in excel as "broken" or not the right file type...
>
> Anyone who can help me with this?
>
> Summary:
>
> Able to download Reuters data using web query
> Not able to download using RCHGetElementNumber number
>
> I am operating on Excel 2010. If additional information is needed please
> do ask :)
>
> Thanks
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)
1d.

Re: Reuters data using RCHGetElementNumber

Posted by: "jrgeico" rerren.jeroen@gmail.com   jrgeico

Tue Dec 6, 2011 12:05 am (PST)



Thanks Randy!

Just needed the quickfix with the updated elements from the work in progress folder, if I had only known this yesterday I would have saved a lot of time :)

Thanks anyway, greatly appreciated!!

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> You probably just need the updated element definitions for Reuters from the
> "Works in Progress" folder of the files area. They made changes to their
> website structure earlier this year. However, none of those elements are
> financial statements data. But you should be able to get the financial
> statements data with the other add-in functions.
>
> For example:
>
> =RCHGetHTMLTable("
> http://www.reuters.com/finance/stocks/incomeStatement/detail?stmtType=INC&perType=ANN&symbol=MMM.N
> ",">Revenue",-1,"",1)
>
> =RCHGetTableCell("
> http://www.reuters.com/finance/stocks/incomeStatement/detail?stmtType=INC&perType=ANN&symbol=MMM.N
> ",1,">Revenue")
>
> On Mon, Dec 5, 2011 at 2:18 PM, jrgeico <rerren.jeroen@...> wrote:
>
> > Hye guys,
> >
> > since I discovered this site a few weeks back I have occupied myself with
> > reading VBA books (unfortunately i had to start with the one for dummies
> > :D) and trying to learn excel.
> >
> > Recently I drew out my "own" approach to pricing stocks and I am now
> > trying to assemble sheets that are available here together with my own
> > input in terms of ratios etc..
> >
> > Unfortunately, I am experiencing the same problem as a few other users
> > with loading data from Reuters. As I favor a proactive approach I tried to
> > solve this problem on my own and used the following site to download
> > Reuters data into my excel file:
> >
> >
> > http://www.aaii.com/computerized-investing/article/using-excel-web-queries-to-retrieve-data.mobile#fig5
> >
> > I thought that if I was able to enable this web query the cookie (and
> > other) problems would be solved. I managed to download the financial
> > statement for Google (I just followed the example) but the connection did
> > not make the RCHGetElementNumber work....
> >
> > Also, when I try to edit my query to provide input for Statement, Period
> > and ticker like this:
> >
> > WEB
> > 1
> > http://www.reuters.com/finance/stocks/incomeStatement/detail?perType=["Statement",
> > "Enter INC, BAL, or CAS"]&perType=["Period", "Enter Ann or
> > INT"]&symbol=["symbol", "Enter ticker symbol"]
> >
> > Selection=AllTables
> > Formatting=None
> > PreFormattedTextToColumns=True
> > ConsecutiveDelimitersAsOne=True
> > SingleBlockTextImport=False
> > DisableDateRecognition=False
> > DisableRedirections=False
> > "
> >
> > the cookie is displayed in excel as "broken" or not the right file type...
> >
> > Anyone who can help me with this?
> >
> > Summary:
> >
> > Able to download Reuters data using web query
> > Not able to download using RCHGetElementNumber number
> >
> > I am operating on Excel 2010. If additional information is needed please
> > do ask :)
> >
> > Thanks
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)
1e.

Re: Reuters data using RCHGetElementNumber

Posted by: "jrgeico" rerren.jeroen@gmail.com   jrgeico

Tue Dec 6, 2011 1:49 am (PST)



So still not quite there yet. I am experiencing the same problems with Valueline and advfn.

I created an account and logged into advfn using the web query. I also managed to download data into my sheet (and saved the query like the tutorial on that one website) but the advfin links unfortunately do not update.

I also restarted excel but to no avail..

I am using formulas such as:

=RCHGetElementNumber(Ticker, 5451)

Yahoo, MSN, Google, Reuters links do work..

Any ideas?

Thanks!

--- In smf_addin@yahoogroups.com, "jrgeico" <rerren.jeroen@...> wrote:
>
> Thanks Randy!
>
> Just needed the quickfix with the updated elements from the work in progress folder, if I had only known this yesterday I would have saved a lot of time :)
>
> Thanks anyway, greatly appreciated!!
>
> --- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@> wrote:
> >
> > You probably just need the updated element definitions for Reuters from the
> > "Works in Progress" folder of the files area. They made changes to their
> > website structure earlier this year. However, none of those elements are
> > financial statements data. But you should be able to get the financial
> > statements data with the other add-in functions.
> >
> > For example:
> >
> > =RCHGetHTMLTable("
> > http://www.reuters.com/finance/stocks/incomeStatement/detail?stmtType=INC&perType=ANN&symbol=MMM.N
> > ",">Revenue",-1,"",1)
> >
> > =RCHGetTableCell("
> > http://www.reuters.com/finance/stocks/incomeStatement/detail?stmtType=INC&perType=ANN&symbol=MMM.N
> > ",1,">Revenue")
> >
> > On Mon, Dec 5, 2011 at 2:18 PM, jrgeico <rerren.jeroen@> wrote:
> >
> > > Hye guys,
> > >
> > > since I discovered this site a few weeks back I have occupied myself with
> > > reading VBA books (unfortunately i had to start with the one for dummies
> > > :D) and trying to learn excel.
> > >
> > > Recently I drew out my "own" approach to pricing stocks and I am now
> > > trying to assemble sheets that are available here together with my own
> > > input in terms of ratios etc..
> > >
> > > Unfortunately, I am experiencing the same problem as a few other users
> > > with loading data from Reuters. As I favor a proactive approach I tried to
> > > solve this problem on my own and used the following site to download
> > > Reuters data into my excel file:
> > >
> > >
> > > http://www.aaii.com/computerized-investing/article/using-excel-web-queries-to-retrieve-data.mobile#fig5
> > >
> > > I thought that if I was able to enable this web query the cookie (and
> > > other) problems would be solved. I managed to download the financial
> > > statement for Google (I just followed the example) but the connection did
> > > not make the RCHGetElementNumber work....
> > >
> > > Also, when I try to edit my query to provide input for Statement, Period
> > > and ticker like this:
> > >
> > > WEB
> > > 1
> > > http://www.reuters.com/finance/stocks/incomeStatement/detail?perType=["Statement",
> > > "Enter INC, BAL, or CAS"]&perType=["Period", "Enter Ann or
> > > INT"]&symbol=["symbol", "Enter ticker symbol"]
> > >
> > > Selection=AllTables
> > > Formatting=None
> > > PreFormattedTextToColumns=True
> > > ConsecutiveDelimitersAsOne=True
> > > SingleBlockTextImport=False
> > > DisableDateRecognition=False
> > > DisableRedirections=False
> > > "
> > >
> > > the cookie is displayed in excel as "broken" or not the right file type...
> > >
> > > Anyone who can help me with this?
> > >
> > > Summary:
> > >
> > > Able to download Reuters data using web query
> > > Not able to download using RCHGetElementNumber number
> > >
> > > I am operating on Excel 2010. If additional information is needed please
> > > do ask :)
> > >
> > > Thanks
> > >
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)
Recent Activity
Visit Your Group
Yahoo! Finance

It's Now Personal

Guides, news,

advice & more.

Ads on Yahoo!

Learn more now.

Reach customers

searching for you.

Yahoo! News

Fashion News

What's the word on

fashion and style?

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
MARKETPLACE

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

Diposting oleh EXCEL FEED LEARNING di 02.35

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)