10 New Messages
Digest #2453
Messages
Mon Dec 31, 2012 5:36 am (PST) . Posted by:
"jcarlosd" jcarlosd
There is no other code between those two parts.
If I show the IE window ("objIE.Visible = True") when I do the "click", IE accepts the submit and returns to the initial screen (https://fundlab.credit-suisse.com/index.cfm? ).
Then I try to get the data (as any other URL without disclaimer) with RCHGetHTMLTable, but it gets stopped at the disclaimer page again.
It seems to me that the cookie is never set. I already had problems with other URL, if you remember, and I could not resolve the issue. You told me that once I enter with IE in the disclaimer page, cookie should be set. But it is not working for me. How can I set it?
BTW, happy new year and keep this extraordinary tool and forum alive
J.Carlos
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> What happens after the Click and before the RCHGetHTMLTable()?
>
> On Sun, Dec 30, 2012 at 10:00 AM, jcarlosd <jcdelrio@...> 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
> >
>
If I show the IE window ("objIE.Visible = True") when I do the "click", IE accepts the submit and returns to the initial screen (https://fundlab.
Then I try to get the data (as any other URL without disclaimer) with RCHGetHTMLTable, but it gets stopped at the disclaimer page again.
It seems to me that the cookie is never set. I already had problems with other URL, if you remember, and I could not resolve the issue. You told me that once I enter with IE in the disclaimer page, cookie should be set. But it is not working for me. How can I set it?
BTW, happy new year and keep this extraordinary tool and forum alive
J.Carlos
--- In smf_addin@yahoogrou
>
> What happens after the Click and before the RCHGetHTMLTable(
>
> On Sun, Dec 30, 2012 at 10:00 AM, jcarlosd <jcdelrio@..
>
> > 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
> >
>
Mon Dec 31, 2012 1:03 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Try using the EXCEL Web Query dialog (atl+d+d+w) to do the disclaimer. When
you get to the page with the HTML table, then CANCEL out and try the add-in
function...
That works for me. I'm not sure why your VBA code isn't doing the trick. It
looks like it should.
Hmmm. For me, the "click" button doesn't show up until AFTER the country
choice is selected. Is your VBA code trying to click on the button before
it has appeared?
On Mon, Dec 31, 2012 at 6:36 AM, jcarlosd <jcdelrio@procesando.com > wrote:
> There is no other code between those two parts.
> If I show the IE window ("objIE.Visible = True") when I do the "click", IE
> accepts the submit and returns to the initial screen (
> https://fundlab.credit-suisse.com/index.cfm? ).
> Then I try to get the data (as any other URL without disclaimer) with
> RCHGetHTMLTable, but it gets stopped at the disclaimer page again.
>
> It seems to me that the cookie is never set. I already had problems with
> other URL, if you remember, and I could not resolve the issue. You told me
> that once I enter with IE in the disclaimer page, cookie should be set. But
> it is not working for me. How can I set it?
>
>
you get to the page with the HTML table, then CANCEL out and try the add-in
function...
That works for me. I'm not sure why your VBA code isn't doing the trick. It
looks like it should.
Hmmm. For me, the "click" button doesn't show up until AFTER the country
choice is selected. Is your VBA code trying to click on the button before
it has appeared?
On Mon, Dec 31, 2012 at 6:36 AM, jcarlosd <jcdelrio@procesando
> There is no other code between those two parts.
> If I show the IE window ("objIE.Visible = True") when I do the "click", IE
> accepts the submit and returns to the initial screen (
> https://fundlab.
> Then I try to get the data (as any other URL without disclaimer) with
> RCHGetHTMLTable, but it gets stopped at the disclaimer page again.
>
> It seems to me that the cookie is never set. I already had problems with
> other URL, if you remember, and I could not resolve the issue. You told me
> that once I enter with IE in the disclaimer page, cookie should be set. But
> it is not working for me. How can I set it?
>
>
Mon Dec 31, 2012 7:44 am (PST) . Posted by:
"rho49m" rho49m
Thanks- that is service.
--- In smf_addin@yahoogrou
>
> In the FILES area of the group:
>
> Files > Templates and Examples > RCHGetYahooQuotes
>
>
http://finance.
Examples/RCHGetYaho
>
> On Mon, Dec 31, 2012 at 3:56 AM, rho49m rho49m@... wrote:
>
> > OK- but where do I find
"RCHGetYahooQuotes-
> > Tried your help file, Google search, site search but did not find
it!
> > Feeling pretty silly...
> >
>
Mon Dec 31, 2012 12:54 pm (PST) . Posted by:
"Jim Ranum" amt2100
This describes me also!!
Thanks,
Jim
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf
Of rho49m
Sent: Sunday, December 30, 2012 6:14 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Timed refresh during market hours
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
Thanks,
Jim
From: smf_addin@yahoogrou
Of rho49m
Sent: Sunday, December 30, 2012 6:14 PM
To: smf_addin@yahoogrou
Subject: [smf_addin] Timed refresh during market hours
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 12:55 pm (PST) . Posted by:
"yfbili" yfbili
I downloaded and unzipped the add-in file to the appropriate folder, then opened RCH_Stock_Market_Functions in Excel. I got some symbols (MMM etc) but no prices. I tried Ctrl-Alt-F9 to update, but that did nothing. What do I need to do to get the quotes to update periodically? Thanks.
Yaz
Yaz
Mon Dec 31, 2012 1:05 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
You may have location errors to resolve before you can use the workbook.
See the LINKS area of the group for more info on that.
You shouldn't be OPENING the XLA file. You need to activate it using the
add-in manager.
On Mon, Dec 31, 2012 at 9:44 AM, yfbili <yfbili@gmail.com > wrote:
> I downloaded and unzipped the add-in file to the appropriate folder, then
> opened RCH_Stock_Market_Functions in Excel. I got some symbols (MMM etc)
> but no prices. I tried Ctrl-Alt-F9 to update, but that did nothing. What
> do I need to do to get the quotes to update periodically? Thanks.
>
See the LINKS area of the group for more info on that.
You shouldn't be OPENING the XLA file. You need to activate it using the
add-in manager.
On Mon, Dec 31, 2012 at 9:44 AM, yfbili <yfbili@gmail.
> I downloaded and unzipped the add-in file to the appropriate folder, then
> opened RCH_Stock_Market_
> but no prices. I tried Ctrl-Alt-F9 to update, but that did nothing. What
> do I need to do to get the quotes to update periodically? Thanks.
>
Mon Dec 31, 2012 12:55 pm (PST) . Posted by:
"Marty" mtopper
Hi Randy
I have been using the following to capture the DJI average when the market is open. It seems to be stuck - doesnt change even when i run smfForceRecalc.
=0+smfGetTagContent("http://finance.yahoo.com/q?s= ^DJI","span",-1,"yfs_l10_")
Any suggestions?
thanks
Marty
I have been using the following to capture the DJI average when the market is open. It seems to be stuck - doesnt change even when i run smfForceRecalc.
=0+smfGetTagContent
Any suggestions?
thanks
Marty
Mon Dec 31, 2012 1:10 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
You probably don't have your Internet settings set to always get a new copy
of a web page. Check out the related item in the LINKS area about
smfForceRecalculation.
You can get the time of the last update with:
=smfGetTagContent("http://finance.yahoo.com/q?s= ^DJI","span",1,"yfs_t10_")
...or the current time on the web page with:
=smfGetTagContent("http://finance.yahoo.com/q?s=
^DJI","span",-1,"yfs_market_time")
On Mon, Dec 31, 2012 at 8:46 AM, Marty <mtopper@yahoo.com > wrote:
>
> I have been using the following to capture the DJI average when the market
> is open. It seems to be stuck - doesnt change even when i run
> smfForceRecalc.
>
> =0+smfGetTagContent("http://finance.yahoo.com/q?s=
> ^DJI","span",-1,"yfs_l10_")
>
of a web page. Check out the related item in the LINKS area about
smfForceRecalculati
You can get the time of the last update with:
=smfGetTagContent(
...or the current time on the web page with:
=smfGetTagContent(
^DJI","span"
On Mon, Dec 31, 2012 at 8:46 AM, Marty <mtopper@yahoo.
>
> I have been using the following to capture the DJI average when the market
> is open. It seems to be stuck - doesnt change even when i run
> smfForceRecalc.
>
> =0+smfGetTagContent
> ^DJI","span"
>
Mon Dec 31, 2012 5:08 pm (PST) . Posted by:
"Adam Singh" adamsingh1
I just started playing with the SMF Add-in. It's really slick, and I appreciate everyone's contributions.
I am attempting to calculate the one day return of a stock after an earnings announcement. I have used the RCHGetElementNumber to retrieve the earnings dates from earnings.com. From here I would like to pull the stock price previous to the announcement (closing price), and then the closing price for the day after the annoucement, and thus calculate the one-day return and average them. I intend to compare these returns to the price jump being implied by options prices for future dates (I already have this).
Any suggestions would be greatly appreciated.
I am attempting to calculate the one day return of a stock after an earnings announcement. I have used the RCHGetElementNumber to retrieve the earnings dates from earnings.com. From here I would like to pull the stock price previous to the announcement (closing price), and then the closing price for the day after the annoucement, and thus calculate the one-day return and average them. I intend to compare these returns to the price jump being implied by options prices for future dates (I already have this).
Any suggestions would be greatly appreciated.
Mon Dec 31, 2012 8:07 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
You could use the smfPricesByDates() function and get all of the closing
prices with one Internet access.
Another option would be to use RCHGetYahooHistory() to get the entire array
of history, and then do VLOOKUP() functions to get the appropriate prices.
I would think the latter would be better, since you have a mixture of
whether the announcements occur before, during, or after the market day.
Depending on when it occurs, you may want to look at something other than
just closing prices.
One problem with your model is that sometimes a company will release
guidance prior to the actual announcement, and that may be when the market
reaction occurs.
On Mon, Dec 31, 2012 at 5:31 PM, Adam Singh <singh.adam@gmail.com > wrote:
> I just started playing with the SMF Add-in. It's really slick, and I
> appreciate everyone's contributions.
>
> I am attempting to calculate the one day return of a stock after an
> earnings announcement. I have used the RCHGetElementNumber to retrieve the
> earnings dates from earnings.com. From here I would like to pull the
> stock price previous to the announcement (closing price), and then the
> closing price for the day after the annoucement, and thus calculate the
> one-day return and average them. I intend to compare these returns to the
> price jump being implied by options prices for future dates (I already have
> this).
>
> Any suggestions would be greatly appreciated.
>
prices with one Internet access.
Another option would be to use RCHGetYahooHistory(
of history, and then do VLOOKUP() functions to get the appropriate prices.
I would think the latter would be better, since you have a mixture of
whether the announcements occur before, during, or after the market day.
Depending on when it occurs, you may want to look at something other than
just closing prices.
One problem with your model is that sometimes a company will release
guidance prior to the actual announcement, and that may be when the market
reaction occurs.
On Mon, Dec 31, 2012 at 5:31 PM, Adam Singh <singh.adam@gmail.
> I just started playing with the SMF Add-in. It's really slick, and I
> appreciate everyone's contributions.
>
> I am attempting to calculate the one day return of a stock after an
> earnings announcement. I have used the RCHGetElementNumber to retrieve the
> earnings dates from earnings.com. From here I would like to pull the
> stock price previous to the announcement (closing price), and then the
> closing price for the day after the annoucement, and thus calculate the
> one-day return and average them. I intend to compare these returns to the
> price jump being implied by options prices for future dates (I already have
> this).
>
> Any suggestions would be greatly appreciated.
>
Tidak ada komentar:
Posting Komentar