8 New Messages
Digest #2452
Messages
Sun Dec 30, 2012 7:42 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Your formula works fine for me. So does this:
=RCHGetHTMLTable("https://fundlab.credit-suisse.com/index.cfm?nav=list
","Benchmark",-1,"",1)
Have you gone past the front country-choice screen with the EXCEL Web Query
dialog (preferred) or IE? If you've only done it with something like
FireFox, EXCEL and the add-in won't be able to get to the web page in
question.
Also, note that if you use RCHGetHTMLTable() in VBA, you may need to use
the pDim1 (i.e. rows) and pDim2 (i.e. columns) to tell the function what
size array to return. Otherwise, you get the default value of 10 by 10.
On Sun, Dec 30, 2012 at 3:31 AM, jcarlosd <jcdelrio@procesando.com > wrote:
>
> I don't find anyway to get data from
> https://fundlab.credit-suisse.com/index.cfm?nav=list (it doesn't matter
> what country is selected in the disclaimer page).
>
> It seems stupid, because I see in the page and in the source code the
> table I want below the text "Show performance figures". But when I use a
> standard procedure:
> myURL = "https://fundlab.credit-suisse.com/index.cfm?nav=list "
> myData = RCHGetHTMLTable(myURL, "Show performance figures", 1, "", 1)
>
> There is no content there! I check in the macro code, and at
> iSel1 = InStr(sdata2, UCase(pFind1))
>
> The result is equal to 0, so it doesn't find those words in the page
> source code. It seems that the content of "sdata2" variable is different
> from the actual page. It is strange to me.
>
> What other procedure do you recommend me to use instead of RCHGetHTMLTable?
>
=RCHGetHTMLTable(
","Benchmark"
Have you gone past the front country-choice screen with the EXCEL Web Query
dialog (preferred) or IE? If you've only done it with something like
FireFox, EXCEL and the add-in won't be able to get to the web page in
question.
Also, note that if you use RCHGetHTMLTable(
the pDim1 (i.e. rows) and pDim2 (i.e. columns) to tell the function what
size array to return. Otherwise, you get the default value of 10 by 10.
On Sun, Dec 30, 2012 at 3:31 AM, jcarlosd <jcdelrio@procesando
>
> I don't find anyway to get data from
> https://fundlab.
> what country is selected in the disclaimer page).
>
> It seems stupid, because I see in the page and in the source code the
> table I want below the text "Show performance figures". But when I use a
> standard procedure:
> myURL = "https://fundlab.
> myData = RCHGetHTMLTable(
>
> There is no content there! I check in the macro code, and at
> iSel1 = InStr(sdata2, UCase(pFind1)
>
> The result is equal to 0, so it doesn't find those words in the page
> source code. It seems that the content of "sdata2" variable is different
> from the actual page. It is strange to me.
>
> What other procedure do you recommend me to use instead of RCHGetHTMLTable?
>
Sun Dec 30, 2012 9:00 am (PST) . Posted by:
"jcarlosd" jcarlosd
It's strange. Before going to that screen I run this code, to overpass the country-code screen (I removed declarations and load waiting to simplify):
URLset = ""https://fundlab.credit-suisse.com/index.cfm?disclaimer=no&change=true "
Set objIE = New InternetExplorer
objIE.Navigate URLset
Set oForm = objIE.Document.forms(0)
On Error Resume Next 'sometimes IE cache does not go to this page
oForm.elements("DOMICILE").Value = "LUX"
oForm.elements("Disclaimer").Value = "YES"
oForm("acceptButton").Click
On Error GoTo 0
'And then I use SMF macro
myURL = "https://fundlab.credit-suisse.com/index.cfm?nav=list "
myData = RCHGetHTMLTable(myURL, "Show performance figures", 1, "", 1)
I use to work just with VBA, not Excel, so I do not how to program the Excel Web query and I work with the Internet Explorer object.
It seems that the page I get with RCHGetHTMLTable is different from the one I can get at that moment with "objIE.Navigate myURL".
If this is true, I do not know how to override it
J. Carlos
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Your formula works fine for me. So does this:
>
> =RCHGetHTMLTable("https://fundlab.credit-suisse.com/index.cfm?nav=list
> ","Benchmark",-1,"",1)
>
> Have you gone past the front country-choice screen with the EXCEL Web Query
> dialog (preferred) or IE? If you've only done it with something like
> FireFox, EXCEL and the add-in won't be able to get to the web page in
> question.
>
> Also, note that if you use RCHGetHTMLTable() in VBA, you may need to use
> the pDim1 (i.e. rows) and pDim2 (i.e. columns) to tell the function what
> size array to return. Otherwise, you get the default value of 10 by 10.
>
> On Sun, Dec 30, 2012 at 3:31 AM, jcarlosd <jcdelrio@...> wrote:
>
> >
> > I don't find anyway to get data from
> > https://fundlab.credit-suisse.com/index.cfm?nav=list (it doesn't matter
> > what country is selected in the disclaimer page).
> >
> > It seems stupid, because I see in the page and in the source code the
> > table I want below the text "Show performance figures". But when I use a
> > standard procedure:
> > myURL = "https://fundlab.credit-suisse.com/index.cfm?nav=list "
> > myData = RCHGetHTMLTable(myURL, "Show performance figures", 1, "", 1)
> >
> > There is no content there! I check in the macro code, and at
> > iSel1 = InStr(sdata2, UCase(pFind1))
> >
> > The result is equal to 0, so it doesn't find those words in the page
> > source code. It seems that the content of "sdata2" variable is different
> > from the actual page. It is strange to me.
> >
> > What other procedure do you recommend me to use instead of RCHGetHTMLTable?
> >
>
URLset = ""https://fundlab.
Set objIE = New InternetExplorer
objIE.Navigate URLset
Set oForm = objIE.Document.
On Error Resume Next 'sometimes IE cache does not go to this page
oForm.elements(
oForm.elements(
oForm("acceptButton
On Error GoTo 0
'And then I use SMF macro
myURL = "https://fundlab.
myData = RCHGetHTMLTable(
I use to work just with VBA, not Excel, so I do not how to program the Excel Web query and I work with the Internet Explorer object.
It seems that the page I get with RCHGetHTMLTable is different from the one I can get at that moment with "objIE.Navigate myURL".
If this is true, I do not know how to override it
J. Carlos
--- In smf_addin@yahoogrou
>
> Your formula works fine for me. So does this:
>
> =RCHGetHTMLTable(
> ","Benchmark"
>
> Have you gone past the front country-choice screen with the EXCEL Web Query
> dialog (preferred) or IE? If you've only done it with something like
> FireFox, EXCEL and the add-in won't be able to get to the web page in
> question.
>
> Also, note that if you use RCHGetHTMLTable(
> the pDim1 (i.e. rows) and pDim2 (i.e. columns) to tell the function what
> size array to return. Otherwise, you get the default value of 10 by 10.
>
> On Sun, Dec 30, 2012 at 3:31 AM, jcarlosd <jcdelrio@..
>
> >
> > I don't find anyway to get data from
> > https://fundlab.
> > what country is selected in the disclaimer page).
> >
> > It seems stupid, because I see in the page and in the source code the
> > table I want below the text "Show performance figures". But when I use a
> > standard procedure:
> > myURL = "https://fundlab.
> > myData = RCHGetHTMLTable(
> >
> > There is no content there! I check in the macro code, and at
> > iSel1 = InStr(sdata2, UCase(pFind1)
> >
> > The result is equal to 0, so it doesn't find those words in the page
> > source code. It seems that the content of "sdata2" variable is different
> > from the actual page. It is strange to me.
> >
> > What other procedure do you recommend me to use instead of RCHGetHTMLTable?
> >
>
Sun Dec 30, 2012 9:50 am (PST) . Posted by:
"David Nicholas" davidnicholas738
You guys know way too much about all of this. Thank heaven and thank you
Sent from my iPad
On Dec 30, 2012, at 11:00 AM, "jcarlosd" <jcdelrio@procesando.com > wrote:
> It's strange. Before going to that screen I run this code, to overpass the country-code screen (I removed declarations and load waiting to simplify):
>
> URLset = ""https://fundlab.credit-suisse.com/index.cfm?disclaimer=no&change=true "
> Set objIE = New InternetExplorer
> objIE.Navigate URLset
> Set oForm = objIE.Document.forms(0)
> On Error Resume Next 'sometimes IE cache does not go to this page
> oForm.elements("DOMICILE").Value = "LUX"
> oForm.elements("Disclaimer").Value = "YES"
> oForm("acceptButton").Click
> On Error GoTo 0
>
> 'And then I use SMF macro
> myURL = "https://fundlab.credit-suisse.com/index.cfm?nav=list "
> myData = RCHGetHTMLTable(myURL, "Show performance figures", 1, "", 1)
>
> I use to work just with VBA, not Excel, so I do not how to program the Excel Web query and I work with the Internet Explorer object.
>
> It seems that the page I get with RCHGetHTMLTable is different from the one I can get at that moment with "objIE.Navigate myURL".
>
> If this is true, I do not know how to override it
> J. Carlos
>
> --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
> >
> > Your formula works fine for me. So does this:
> >
> > =RCHGetHTMLTable("https://fundlab.credit-suisse.com/index.cfm?nav=list
> > ","Benchmark",-1,"",1)
> >
> > Have you gone past the front country-choice screen with the EXCEL Web Query
> > dialog (preferred) or IE? If you've only done it with something like
> > FireFox, EXCEL and the add-in won't be able to get to the web page in
> > question.
> >
> > Also, note that if you use RCHGetHTMLTable() in VBA, you may need to use
> > the pDim1 (i.e. rows) and pDim2 (i.e. columns) to tell the function what
> > size array to return. Otherwise, you get the default value of 10 by 10.
> >
> > On Sun, Dec 30, 2012 at 3:31 AM, jcarlosd <jcdelrio@...> wrote:
> >
> > >
> > > I don't find anyway to get data from
> > > https://fundlab.credit-suisse.com/index.cfm?nav=list (it doesn't matter
> > > what country is selected in the disclaimer page).
> > >
> > > It seems stupid, because I see in the page and in the source code the
> > > table I want below the text "Show performance figures". But when I use a
> > > standard procedure:
> > > myURL = "https://fundlab.credit-suisse.com/index.cfm?nav=list "
> > > myData = RCHGetHTMLTable(myURL, "Show performance figures", 1, "", 1)
> > >
> > > There is no content there! I check in the macro code, and at
> > > iSel1 = InStr(sdata2, UCase(pFind1))
> > >
> > > The result is equal to 0, so it doesn't find those words in the page
> > > source code. It seems that the content of "sdata2" variable is different
> > > from the actual page. It is strange to me.
> > >
> > > What other procedure do you recommend me to use instead of RCHGetHTMLTable?
> > >
> >
>
>
Sent from my iPad
On Dec 30, 2012, at 11:00 AM, "jcarlosd" <jcdelrio@procesando
> It's strange. Before going to that screen I run this code, to overpass the country-code screen (I removed declarations and load waiting to simplify):
>
> URLset = ""https://fundlab.
> Set objIE = New InternetExplorer
> objIE.Navigate URLset
> Set oForm = objIE.Document.
> On Error Resume Next 'sometimes IE cache does not go to this page
> oForm.elements(
> oForm.elements(
> oForm("acceptButton
> On Error GoTo 0
>
> 'And then I use SMF macro
> myURL = "https://fundlab.
> myData = RCHGetHTMLTable(
>
> I use to work just with VBA, not Excel, so I do not how to program the Excel Web query and I work with the Internet Explorer object.
>
> It seems that the page I get with RCHGetHTMLTable is different from the one I can get at that moment with "objIE.Navigate myURL".
>
> If this is true, I do not know how to override it
> J. Carlos
>
> --- In smf_addin@yahoogrou
> >
> > Your formula works fine for me. So does this:
> >
> > =RCHGetHTMLTable(
> > ","Benchmark"
> >
> > Have you gone past the front country-choice screen with the EXCEL Web Query
> > dialog (preferred) or IE? If you've only done it with something like
> > FireFox, EXCEL and the add-in won't be able to get to the web page in
> > question.
> >
> > Also, note that if you use RCHGetHTMLTable(
> > the pDim1 (i.e. rows) and pDim2 (i.e. columns) to tell the function what
> > size array to return. Otherwise, you get the default value of 10 by 10.
> >
> > On Sun, Dec 30, 2012 at 3:31 AM, jcarlosd <jcdelrio@..
> >
> > >
> > > I don't find anyway to get data from
> > > https://fundlab.
> > > what country is selected in the disclaimer page).
> > >
> > > It seems stupid, because I see in the page and in the source code the
> > > table I want below the text "Show performance figures". But when I use a
> > > standard procedure:
> > > myURL = "https://fundlab.
> > > myData = RCHGetHTMLTable(
> > >
> > > There is no content there! I check in the macro code, and at
> > > iSel1 = InStr(sdata2, UCase(pFind1)
> > >
> > > The result is equal to 0, so it doesn't find those words in the page
> > > source code. It seems that the content of "sdata2" variable is different
> > > from the actual page. It is strange to me.
> > >
> > > What other procedure do you recommend me to use instead of RCHGetHTMLTable?
> > >
> >
>
>
Sun Dec 30, 2012 11:40 am (PST) . Posted by:
"Randy Harmelink" rharmelink
What happens after the Click and before the RCHGetHTMLTable()?
On Sun, Dec 30, 2012 at 10:00 AM, jcarlosd <jcdelrio@procesando.com > wrote:
> It's strange. Before going to that screen I run this code, to overpass the
> country-code screen (I removed declarations and load waiting to simplify):
>
> URLset = ""
> https://fundlab.credit-suisse.com/index.cfm?disclaimer=no&change=true "
> Set objIE = New InternetExplorer
> objIE.Navigate URLset
> Set oForm = objIE.Document.forms(0)
> On Error Resume Next 'sometimes IE cache does not go to this page
> oForm.elements("DOMICILE").Value = "LUX"
> oForm.elements("Disclaimer").Value = "YES"
> oForm("acceptButton").Click
> On Error GoTo 0
>
> 'And then I use SMF macro
> myURL = "https://fundlab.credit-suisse.com/index.cfm?nav=list "
> myData = RCHGetHTMLTable(myURL, "Show performance figures", 1, "", 1)
>
> I use to work just with VBA, not Excel, so I do not how to program the
> Excel Web query and I work with the Internet Explorer object.
>
> It seems that the page I get with RCHGetHTMLTable is different from the
> one I can get at that moment with "objIE.Navigate myURL".
>
> If this is true, I do not know how to override it
>
On Sun, Dec 30, 2012 at 10:00 AM, jcarlosd <jcdelrio@procesando
> It's strange. Before going to that screen I run this code, to overpass the
> country-code screen (I removed declarations and load waiting to simplify):
>
> URLset = ""
> https://fundlab.
> Set objIE = New InternetExplorer
> objIE.Navigate URLset
> Set oForm = objIE.Document.
> On Error Resume Next 'sometimes IE cache does not go to this page
> oForm.elements(
> oForm.elements(
> oForm("acceptButton
> On Error GoTo 0
>
> 'And then I use SMF macro
> myURL = "https://fundlab.
> myData = RCHGetHTMLTable(
>
> I use to work just with VBA, not Excel, so I do not how to program the
> Excel Web query and I work with the Internet Explorer object.
>
> It seems that the page I get with RCHGetHTMLTable is different from the
> one I can get at that moment with "objIE.Navigate myURL".
>
> If this is true, I do not know how to override it
>
Sun Dec 30, 2012 3:23 pm (PST) . Posted by:
"rho49m" rho49m
Really have no idea what I am doing, basically I would like to download stock data from Yahoo every 10 minutes during market hours, would like to set start and end times with a refresh interval. I assume it has already been done but did not find the post. I am none too smart so need an explicit guide. Thanks
Sun Dec 30, 2012 4:01 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Take a look at this file:
RCHGetYahooQuotes-Example-Timed-Update.xls
On Sun, Dec 30, 2012 at 4:13 PM, rho49m <rho49m@yahoo.it > wrote:
> Really have no idea what I am doing, basically I would like to download
> stock data from Yahoo every 10 minutes during market hours, would like to
> set start and end times with a refresh interval. I assume it has already
> been done but did not find the post. I am none too smart so need an
> explicit guide. Thanks
>
RCHGetYahooQuotes-
On Sun, Dec 30, 2012 at 4:13 PM, rho49m <rho49m@yahoo.
> Really have no idea what I am doing, basically I would like to download
> stock data from Yahoo every 10 minutes during market hours, would like to
> set start and end times with a refresh interval. I assume it has already
> been done but did not find the post. I am none too smart so need an
> explicit guide. Thanks
>
Mon Dec 31, 2012 2:56 am (PST) . Posted by:
"rho49m" rho49m
OK- but where do I find "RCHGetYahooQuotes-Example-Timed-Update.xls"?
Tried your help file, Google search, site search but did not find it! Feeling pretty silly...
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Take a look at this file:
>
> RCHGetYahooQuotes-Example-Timed-Update.xls
>
> On Sun, Dec 30, 2012 at 4:13 PM, rho49m <rho49m@...> wrote:
>
> > Really have no idea what I am doing, basically I would like to download
> > stock data from Yahoo every 10 minutes during market hours, would like to
> > set start and end times with a refresh interval. I assume it has already
> > been done but did not find the post. I am none too smart so need an
> > explicit guide. Thanks
> >
>
Tried your help file, Google search, site search but did not find it! Feeling pretty silly...
--- In smf_addin@yahoogrou
>
> Take a look at this file:
>
> RCHGetYahooQuotes-
>
> On Sun, Dec 30, 2012 at 4:13 PM, rho49m <rho49m@...> wrote:
>
> > Really have no idea what I am doing, basically I would like to download
> > stock data from Yahoo every 10 minutes during market hours, would like to
> > set start and end times with a refresh interval. I assume it has already
> > been done but did not find the post. I am none too smart so need an
> > explicit guide. Thanks
> >
>
Mon Dec 31, 2012 3:04 am (PST) . Posted by:
"Randy Harmelink" rharmelink
In the FILES area of the group:
Files > Templates and Examples > RCHGetYahooQuotes
http://finance.groups.yahoo.com/group/smf_addin/files/Templates%20and%20Examples/RCHGetYahooQuotes/
On Mon, Dec 31, 2012 at 3:56 AM, rho49m <rho49m@yahoo.it > wrote:
> OK- but where do I find "RCHGetYahooQuotes-Example-Timed-Update.xls"?
> Tried your help file, Google search, site search but did not find it!
> Feeling pretty silly...
>
Files > Templates and Examples > RCHGetYahooQuotes
http://finance.
On Mon, Dec 31, 2012 at 3:56 AM, rho49m <rho49m@yahoo.
> OK- but where do I find "RCHGetYahooQuotes-
> Tried your help file, Google search, site search but did not find it!
> Feeling pretty silly...
>
Tidak ada komentar:
Posting Komentar