15 New Messages
Digest #2410
Messages
Fri Nov 23, 2012 4:12 am (PST) . Posted by:
"jcarlosd" jcarlosd
Well, Randy for the purpose of the trial, it doesn't care what country one is located. I understand that one thing is just to retrieve the data and other different one is to use the data for financial purposes.
Could you please just select Luxembourg - Professional investor?
I was trying to use your RCHGetTableCell function. But it gets no data because it shows the disclaimer page in http://www.fundinfo.com/en/universe/. How can I let Excel know that it has to select one country and click on "I hereby confirm..."?
I tried to visit first this address http://www.fundinfo.com/en/universe/?displayUniverse=LU-prof&disclaimerAccepted=true, trying to fill the POST form with GET stuff, but i can not make it work.
Could you please take a look on that?
J. Carlos
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> None of those are my country of domicile.
>
> On Mon, Oct 15, 2012 at 10:21 PM, jcarlosd <jcdelrio@...> wrote:
>
> > I don't understand why you could not get to the web page I mentioned.
> > Could you access http://www.fundinfo.com/en/home/. From there, just
> > filter by any country domicile (or asset class, or provider, etc) and you
> > will be directed to a similar page to this link:
> > http://www.fundinfo.com/en/search/?q=domicile%3AUK and a list of funds
> > will be shown
> >
>
Could you please just select Luxembourg - Professional investor?
I was trying to use your RCHGetTableCell function. But it gets no data because it shows the disclaimer page in http://www.fundinfo
I tried to visit first this address http://www.fundinfo
Could you please take a look on that?
J. Carlos
--- In smf_addin@yahoogrou
>
> None of those are my country of domicile.
>
> On Mon, Oct 15, 2012 at 10:21 PM, jcarlosd <jcdelrio@..
>
> > I don't understand why you could not get to the web page I mentioned.
> > Could you access http://www.fundinfo
> > filter by any country domicile (or asset class, or provider, etc) and you
> > will be directed to a similar page to this link:
> > http://www.fundinfo
> > will be shown
> >
>
Fri Nov 23, 2012 5:41 am (PST) . Posted by:
"Randy Harmelink" rharmelink
I had no trouble accessing the data...for example:
=RCHGetTableCell("http://www.fundinfo.com/en/search/?q=domicile:FR
",8,"FR0010925594")
...returned the NAV of the fund. Have you not visited the above URL using
the EXCEL Web Query process or IE? You need to create the security cookie
that says you have "logged in" for the disclaimer. Otherwise, you'll
constantly get the disclaimer page when you try that URL.
On Fri, Nov 23, 2012 at 5:12 AM, jcarlosd <jcdelrio@procesando.com > wrote:
> Well, Randy for the purpose of the trial, it doesn't care what country one
> is located. I understand that one thing is just to retrieve the data and
> other different one is to use the data for financial purposes.
>
> Could you please just select Luxembourg - Professional investor?
>
> I was trying to use your RCHGetTableCell function. But it gets no data
> because it shows the disclaimer page in
> http://www.fundinfo.com/en/universe/. How can I let Excel know that it
> has to select one country and click on "I hereby confirm..."?
>
> I tried to visit first this address
> http://www.fundinfo.com/en/universe/?displayUniverse=LU-prof&disclaimerAccepted=true,
> trying to fill the POST form with GET stuff, but i can not make it work.
>
> Could you please take a look on that?
>
=RCHGetTableCell(
",8,"FR0010925594"
...returned the NAV of the fund. Have you not visited the above URL using
the EXCEL Web Query process or IE? You need to create the security cookie
that says you have "logged in" for the disclaimer. Otherwise, you'll
constantly get the disclaimer page when you try that URL.
On Fri, Nov 23, 2012 at 5:12 AM, jcarlosd <jcdelrio@procesando
> Well, Randy for the purpose of the trial, it doesn't care what country one
> is located. I understand that one thing is just to retrieve the data and
> other different one is to use the data for financial purposes.
>
> Could you please just select Luxembourg - Professional investor?
>
> I was trying to use your RCHGetTableCell function. But it gets no data
> because it shows the disclaimer page in
> http://www.fundinfo
> has to select one country and click on "I hereby confirm..."?
>
> I tried to visit first this address
> http://www.fundinfo
> trying to fill the POST form with GET stuff, but i can not make it work.
>
> Could you please take a look on that?
>
Fri Nov 23, 2012 6:51 am (PST) . Posted by:
"tomasi1957" tomasi1957
Im trying to set a spreadsheet using "AEP" AMERICAN ELECTRIC POWER and it returns "Error". Im using element 25 MSN last price. Im using spreadsheet version 2.12012,04.07. Any thoughts?
Tomas
Tomas
Fri Nov 23, 2012 7:28 am (PST) . Posted by:
"Randy Harmelink" rharmelink
The last I heard, MSN was posting the previous day's closing price as "Last
Price", so it's probably not what you want anyway. I would suggest using
the RCHGetYahooQuotes() function instead.
In any case, you probably need to update your MSN element definitions to
get rid of the "Error" result. See:
http://finance.groups.yahoo.com/group/smf_addin/message/19858
On Fri, Nov 23, 2012 at 7:51 AM, tomasi1957 <tomasi1957@yahoo.com > wrote:
> Im trying to set a spreadsheet using "AEP" AMERICAN ELECTRIC POWER and it
> returns "Error". Im using element 25 MSN last price. Im using spreadsheet
> version 2.12012,04.07. Any thoughts?
>
Price", so it's probably not what you want anyway. I would suggest using
the RCHGetYahooQuotes(
In any case, you probably need to update your MSN element definitions to
get rid of the "Error" result. See:
http://finance.
On Fri, Nov 23, 2012 at 7:51 AM, tomasi1957 <tomasi1957@yahoo.
> Im trying to set a spreadsheet using "AEP" AMERICAN ELECTRIC POWER and it
> returns "Error". Im using element 25 MSN last price. Im using spreadsheet
> version 2.12012,04.07. Any thoughts?
>
Fri Nov 23, 2012 8:23 am (PST) . Posted by:
"tomasi1957" tomasi1957
Thanks Randy......
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> The last I heard, MSN was posting the previous day's closing price as "Last
> Price", so it's probably not what you want anyway. I would suggest using
> the RCHGetYahooQuotes() function instead.
>
> In any case, you probably need to update your MSN element definitions to
> get rid of the "Error" result. See:
>
> http://finance.groups.yahoo.com/group/smf_addin/message/19858
>
> On Fri, Nov 23, 2012 at 7:51 AM, tomasi1957 <tomasi1957@...> wrote:
>
> > Im trying to set a spreadsheet using "AEP" AMERICAN ELECTRIC POWER and it
> > returns "Error". Im using element 25 MSN last price. Im using spreadsheet
> > version 2.12012,04.07. Any thoughts?
> >
>
--- In smf_addin@yahoogrou
>
> The last I heard, MSN was posting the previous day's closing price as "Last
> Price", so it's probably not what you want anyway. I would suggest using
> the RCHGetYahooQuotes(
>
> In any case, you probably need to update your MSN element definitions to
> get rid of the "Error" result. See:
>
> http://finance.
>
> On Fri, Nov 23, 2012 at 7:51 AM, tomasi1957 <tomasi1957@
>
> > Im trying to set a spreadsheet using "AEP" AMERICAN ELECTRIC POWER and it
> > returns "Error". Im using element 25 MSN last price. Im using spreadsheet
> > version 2.12012,04.07. Any thoughts?
> >
>
Fri Nov 23, 2012 10:34 am (PST) . Posted by:
"tomasi1957" tomasi1957
OK Randy That works really well on all my portfolio except for one which is Royal Dutch Shell PLC ADR Class B ticker symbol is RDS.B...
Any thoughts for this guy?
Tomas
--- In smf_addin@yahoogroups.com , "tomasi1957" <tomasi1957@...> wrote:
>
> Thanks Randy......
>
> --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@> wrote:
> >
> > The last I heard, MSN was posting the previous day's closing price as "Last
> > Price", so it's probably not what you want anyway. I would suggest using
> > the RCHGetYahooQuotes() function instead.
> >
> > In any case, you probably need to update your MSN element definitions to
> > get rid of the "Error" result. See:
> >
> > http://finance.groups.yahoo.com/group/smf_addin/message/19858
> >
> > On Fri, Nov 23, 2012 at 7:51 AM, tomasi1957 <tomasi1957@> wrote:
> >
> > > Im trying to set a spreadsheet using "AEP" AMERICAN ELECTRIC POWER and it
> > > returns "Error". Im using element 25 MSN last price. Im using spreadsheet
> > > version 2.12012,04.07. Any thoughts?
> > >
> >
>
Any thoughts for this guy?
Tomas
--- In smf_addin@yahoogrou
>
> Thanks Randy......
>
> --- In smf_addin@yahoogrou
> >
> > The last I heard, MSN was posting the previous day's closing price as "Last
> > Price", so it's probably not what you want anyway. I would suggest using
> > the RCHGetYahooQuotes(
> >
> > In any case, you probably need to update your MSN element definitions to
> > get rid of the "Error" result. See:
> >
> > http://finance.
> >
> > On Fri, Nov 23, 2012 at 7:51 AM, tomasi1957 <tomasi1957@
> >
> > > Im trying to set a spreadsheet using "AEP" AMERICAN ELECTRIC POWER and it
> > > returns "Error". Im using element 25 MSN last price. Im using spreadsheet
> > > version 2.12012,04.07. Any thoughts?
> > >
> >
>
Fri Nov 23, 2012 12:04 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
I think you just need to use Yahoo's ticker symbol -- RDS-B
On Fri, Nov 23, 2012 at 11:34 AM, tomasi1957 <tomasi1957@yahoo.com > wrote:
> OK Randy That works really well on all my portfolio except for one which
> is Royal Dutch Shell PLC ADR Class B ticker symbol is RDS.B...
>
> Any thoughts for this guy?
>
On Fri, Nov 23, 2012 at 11:34 AM, tomasi1957 <tomasi1957@yahoo.
> OK Randy That works really well on all my portfolio except for one which
> is Royal Dutch Shell PLC ADR Class B ticker symbol is RDS.B...
>
> Any thoughts for this guy?
>
Fri Nov 23, 2012 8:19 am (PST) . Posted by:
"jalea148" jalea148
Randy,
Is there any way to download the Beta for a large list of stocks?
Thanx,
Jay
Is there any way to download the Beta for a large list of stocks?
Thanx,
Jay
Fri Nov 23, 2012 8:47 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Easiest way would probably be FinViz -- check out the FinViz entries in the
LINKS area of the group.
But it may make a difference on what value of beta you want -- some sites
have 1-year, some 3-year, and others 5-year. And I think there are sites
that give you the correlation/beta based on any time period you choose.
On Fri, Nov 23, 2012 at 9:19 AM, jalea148 <drjay001@gmail.com > wrote:
> Is there any way to download the Beta for a large list of stocks?
>
LINKS area of the group.
But it may make a difference on what value of beta you want -- some sites
have 1-year, some 3-year, and others 5-year. And I think there are sites
that give you the correlation/
On Fri, Nov 23, 2012 at 9:19 AM, jalea148 <drjay001@gmail.
> Is there any way to download the Beta for a large list of stocks?
>
Fri Nov 23, 2012 7:39 pm (PST) . Posted by:
"yp_chandler" yp_chandler
Thanks.
It seems to be flaky because it started to work again after I posted this message and now its back to showing an error (although i'm logged in on IBD through IE). BTW, what is 'excel web query dialog'? Can you point me on how to do this 'preferred' method?
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> You do need to be logged in to the IBD web site, using either the EXCEL Web
> Query dialog (preferred) or IE. And, sometimes, you need to visit the web
> site first, because they occasionally put up an advertisement on the first
> visit of the day.
>
> On Mon, Nov 19, 2012 at 3:23 PM, yp_chandler <ferozma@...> wrote:
>
> > It was working great for a couple of months now but is now giving a error.
> > I'm using the IBD template from this website.
> >
>
It seems to be flaky because it started to work again after I posted this message and now its back to showing an error (although i'm logged in on IBD through IE). BTW, what is 'excel web query dialog'? Can you point me on how to do this 'preferred' method?
--- In smf_addin@yahoogrou
>
> You do need to be logged in to the IBD web site, using either the EXCEL Web
> Query dialog (preferred) or IE. And, sometimes, you need to visit the web
> site first, because they occasionally put up an advertisement on the first
> visit of the day.
>
> On Mon, Nov 19, 2012 at 3:23 PM, yp_chandler <ferozma@...
>
> > It was working great for a couple of months now but is now giving a error.
> > I'm using the IBD template from this website.
> >
>
Fri Nov 23, 2012 8:15 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Keyboard shortcut is alt+d+d+w. It brings up the IE object that EXCEL uses.
Usually this matches the version of th external browser version of IE, but
not always. That why I say the EXCEL Web Query dialog is preferred.
Note that you can only be logged in from one browser/object at a time. Most
of the time, IBD logs you out of an existing session if you start up a new
session with a different program.
On Fri, Nov 23, 2012 at 8:39 PM, yp_chandler <ferozma@gmail.com > wrote:
>
> It seems to be flaky because it started to work again after I posted this
> message and now its back to showing an error (although i'm logged in on IBD
> through IE). BTW, what is 'excel web query dialog'? Can you point me on how
> to do this 'preferred' method?
>
Usually this matches the version of th external browser version of IE, but
not always. That why I say the EXCEL Web Query dialog is preferred.
Note that you can only be logged in from one browser/object at a time. Most
of the time, IBD logs you out of an existing session if you start up a new
session with a different program.
On Fri, Nov 23, 2012 at 8:39 PM, yp_chandler <ferozma@gmail.
>
> It seems to be flaky because it started to work again after I posted this
> message and now its back to showing an error (although i'm logged in on IBD
> through IE). BTW, what is 'excel web query dialog'? Can you point me on how
> to do this 'preferred' method?
>
Fri Nov 23, 2012 8:34 pm (PST) . Posted by:
"bobjerritts@yahoo.com" bobjerritts
Hi,
I'd does not work. The response is that the date is incorrect if I leave it blank.
I am using excell 2003 student edition on a vista 64 home edition PC?
What is Pdim1 and PDim 2?
Sent from my iPad
On Nov 21, 2012, at 11:38 PM, Randy Harmelink <rharmelink@gmail.com > wrote:
> Just don't give it any dates, and the ending date will be the most recent date. Just as stated in the documentation, and on the example in the documentation.
>
> The number of days of history will be determined by the size of the range you entered the function over.
>
>
> On Thu, Nov 22, 2012 at 12:16 AM, bobjerritts <bobjerritts@yahoo.com > wrote:
>>
>> I am using the rchgetyahoohistory function for monthly adjusted prices.
>>
>> I do not want to specify an end year,month, day . I want the function to always display the most recent price so that i do not have to constantly ( each month) use a new end year, end month, end day.
>
>
I'd does not work. The response is that the date is incorrect if I leave it blank.
I am using excell 2003 student edition on a vista 64 home edition PC?
What is Pdim1 and PDim 2?
Sent from my iPad
On Nov 21, 2012, at 11:38 PM, Randy Harmelink <rharmelink@gmail.
> Just don't give it any dates, and the ending date will be the most recent date. Just as stated in the documentation, and on the example in the documentation.
>
> The number of days of history will be determined by the size of the range you entered the function over.
>
>
> On Thu, Nov 22, 2012 at 12:16 AM, bobjerritts <bobjerritts@
>>
>> I am using the rchgetyahoohistory function for monthly adjusted prices.
>>
>> I do not want to specify an end year,month, day . I want the function to always display the most recent price so that i do not have to constantly ( each month) use a new end year, end month, end day.
>
>
Fri Nov 23, 2012 8:40 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
These don't work for you?
=RCHGetYahooHistory("MMM")
=RCHGetYahooHistory("MMM",,,,,,,,,,1)
pDim1 and pDim2 are there so you can override the size of the array
returned. They're used on advanced applications of the function and VBA
usage of the function. The default is that they are set to the size of the
range you are array-entering the function over.
On Fri, Nov 23, 2012 at 9:34 PM, <bobjerritts@yahoo.com > wrote:
>
> I'd does not work. The response is that the date is incorrect if I leave
> it blank.
>
> I am using excell 2003 student edition on a vista 64 home edition PC?
>
> What is Pdim1 and PDim 2?
>
=RCHGetYahooHistory
=RCHGetYahooHistory
pDim1 and pDim2 are there so you can override the size of the array
returned. They're used on advanced applications of the function and VBA
usage of the function. The default is that they are set to the size of the
range you are array-entering the function over.
On Fri, Nov 23, 2012 at 9:34 PM, <bobjerritts@
>
> I'd does not work. The response is that the date is incorrect if I leave
> it blank.
>
> I am using excell 2003 student edition on a vista 64 home edition PC?
>
> What is Pdim1 and PDim 2?
>
Sat Nov 24, 2012 1:16 am (PST) . Posted by:
"Randy H" rharmelink
There aren't many elements for Reuters data. Pretty much just the
Reuters ratios web page. Check the elements definition workbook that is
distributed within the add-in ZIP file to see the elements that have
been defined.
For the data that is available from Reuters and Yahoo, you'd need to
visit their web sites. Almost anything on them is extractable with one
function or another. The templates in the files area just show which web
pages I've created examples for.
PS: In the future, please post all add-in questions to the Yahoo group.
On Fri, Nov 23, 2012 at 11:54 PM, andrewhills97 <andrewhills97@...
<mailto:andrewhills97@yahoo.com > > wrote:
The Excel Template, RCHGetTableCell-Template-Reuters-Analysts.xls,
retrieves Reuters estimates for Sales and EPS. What other data can we
retrieve from Reuters?
With Yahoo data, there are many element #'s which retrieve various data.
Is there something similar with Reuters?
Thanks and regards, Andrew
Reuters ratios web page. Check the elements definition workbook that is
distributed within the add-in ZIP file to see the elements that have
been defined.
For the data that is available from Reuters and Yahoo, you'd need to
visit their web sites. Almost anything on them is extractable with one
function or another. The templates in the files area just show which web
pages I've created examples for.
PS: In the future, please post all add-in questions to the Yahoo group.
On Fri, Nov 23, 2012 at 11:54 PM, andrewhills97 <andrewhills97@
<mailto:andrewhills97@
The Excel Template, RCHGetTableCell-
retrieves Reuters estimates for Sales and EPS. What other data can we
retrieve from Reuters?
With Yahoo data, there are many element #'s which retrieve various data.
Is there something similar with Reuters?
Thanks and regards, Andrew
Sat Nov 24, 2012 3:24 am (PST) . Posted by:
"andrewhills97" andrewhills97
ok thanks
--- In smf_addin@yahoogroups.com , "Randy H" <rharmelink@...> wrote:
>
> There aren't many elements for Reuters data. Pretty much just the
> Reuters ratios web page. Check the elements definition workbook that is
> distributed within the add-in ZIP file to see the elements that have
> been defined.
>
> For the data that is available from Reuters and Yahoo, you'd need to
> visit their web sites. Almost anything on them is extractable with one
> function or another. The templates in the files area just show which web
> pages I've created examples for.
>
> PS: In the future, please post all add-in questions to the Yahoo group.
>
> On Fri, Nov 23, 2012 at 11:54 PM, andrewhills97 <andrewhills97@
> <mailto:andrewhills97@...> > wrote:
>
> The Excel Template, RCHGetTableCell-Template-Reuters-Analysts.xls,
> retrieves Reuters estimates for Sales and EPS. What other data can we
> retrieve from Reuters?
>
> With Yahoo data, there are many element #'s which retrieve various data.
> Is there something similar with Reuters?
>
> Thanks and regards, Andrew
>
--- In smf_addin@yahoogrou
>
> There aren't many elements for Reuters data. Pretty much just the
> Reuters ratios web page. Check the elements definition workbook that is
> distributed within the add-in ZIP file to see the elements that have
> been defined.
>
> For the data that is available from Reuters and Yahoo, you'd need to
> visit their web sites. Almost anything on them is extractable with one
> function or another. The templates in the files area just show which web
> pages I've created examples for.
>
> PS: In the future, please post all add-in questions to the Yahoo group.
>
> On Fri, Nov 23, 2012 at 11:54 PM, andrewhills97 <andrewhills97@
> <mailto:andrewhills
>
> The Excel Template, RCHGetTableCell-
> retrieves Reuters estimates for Sales and EPS. What other data can we
> retrieve from Reuters?
>
> With Yahoo data, there are many element #'s which retrieve various data.
> Is there something similar with Reuters?
>
> Thanks and regards, Andrew
>
Tidak ada komentar:
Posting Komentar