6 New Messages
Digest #2411
Messages
Sat Nov 24, 2012 10:37 am (PST) . Posted by:
"jcarlosd" jcarlosd
Ok, I see.
Is there any way to setup that security cookie you mentioned when I enter with my VBA macro? I do not want to have to create manually a web query and select manually the country. Or is there any way to change it to other condition, like change of domicile country?
Thanks
J. Carlos
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> 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@...> 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?
> >
>
Is there any way to setup that security cookie you mentioned when I enter with my VBA macro? I do not want to have to create manually a web query and select manually the country. Or is there any way to change it to other condition, like change of domicile country?
Thanks
J. Carlos
--- In smf_addin@yahoogrou
>
> I had no trouble accessing the data...for example:
>
> =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@..
>
> > 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?
> >
>
Sat Nov 24, 2012 12:52 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
You should be able to do that with VBA by interacting with the
InternetExplorer object. Do they allow changing? Otherwise, depending on
the expiration date of the cookie, the "login" may only need to be done
once.
On Sat, Nov 24, 2012 at 11:37 AM, jcarlosd <jcdelrio@procesando.com > wrote:
>
> Is there any way to setup that security cookie you mentioned when I enter
> with my VBA macro? I do not want to have to create manually a web query and
> select manually the country. Or is there any way to change it to other
> condition, like change of domicile country?
>
InternetExplorer object. Do they allow changing? Otherwise, depending on
the expiration date of the cookie, the "login" may only need to be done
once.
On Sat, Nov 24, 2012 at 11:37 AM, jcarlosd <jcdelrio@procesando
>
> Is there any way to setup that security cookie you mentioned when I enter
> with my VBA macro? I do not want to have to create manually a web query and
> select manually the country. Or is there any way to change it to other
> condition, like change of domicile country?
>
Sat Nov 24, 2012 12:49 pm (PST) . Posted by:
"jdavidsummers" jdavidsummers
I am a new member to this group. I see that I have Excel 2002 installed. Do I need 2007 or newer?
Sat Nov 24, 2012 12:52 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
It should work with EXCEL 2002.
On Sat, Nov 24, 2012 at 10:40 AM, jdavidsummers <dsummers@tampabay.rr.com >wrote:
> I am a new member to this group. I see that I have Excel 2002 installed.
> Do I need 2007 or newer?
>
On Sat, Nov 24, 2012 at 10:40 AM, jdavidsummers <dsummers@tampabay.
> I am a new member to this group. I see that I have Excel 2002 installed.
> Do I need 2007 or newer?
>
Sat Nov 24, 2012 3:29 pm (PST) . Posted by:
"Peter James" pmjzz
On 2012-11-24 15:52, Randy Harmelink wrote:
> It should work with EXCEL 2002.
>
> On Sat, Nov 24, 2012 at 10:40 AM, jdavidsummers
> <dsummers@tampabay.rr.com <mailto:dsummers@tampabay.rr.com >> wrote:
>
> I am a new member to this group. I see that I have Excel 2002
> installed. Do I need 2007 or newer?
I use Excel 2000. All the functions I have tried have worked.
--
Peter James
Patrick Hutber: Improvement means deterioration
> It should work with EXCEL 2002.
>
> On Sat, Nov 24, 2012 at 10:40 AM, jdavidsummers
> <dsummers@tampabay.
>
> I am a new member to this group. I see that I have Excel 2002
> installed. Do I need 2007 or newer?
I use Excel 2000. All the functions I have tried have worked.
--
Peter James
Patrick Hutber: Improvement means deterioration
Sat Nov 24, 2012 3:41 pm (PST) . Posted by:
"Bob Jerritts" bobjerritts
Hi,
Ok it works. I found my mistake.
Thanks
________________________________
From: Randy Harmelink <rharmelink@gmail.com >
To: smf_addin@yahoogroups.com
Sent: Friday, November 23, 2012 8:40 PM
Subject: Re: [smf_addin] historical data
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?
>
Ok it works. I found my mistake.
Thanks
____________
From: Randy Harmelink <rharmelink@gmail.
To: smf_addin@yahoogrou
Sent: Friday, November 23, 2012 8:40 PM
Subject: Re: [smf_addin] historical data
These don't work for you?
=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?
>
Tidak ada komentar:
Posting Komentar