Messages In This Digest (5 Messages)
- 1a.
- After-hours quote from Yahoo From: bizmark_ee
- 1b.
- Re: After-hours quote from Yahoo From: Randy Harmelink
- 1c.
- Re: After-hours quote from Yahoo From: bizmark_ee
- 1d.
- Re: After-hours quote from Yahoo From: Randy Harmelink
- 2a.
- Re: beginner's excel errors. :( From: upsquare78
Messages
- 1a.
-
After-hours quote from Yahoo
Posted by: "bizmark_ee" markpadden@hotmail.com bizmark_ee
Wed Jan 4, 2012 2:57 pm (PST)
Curious if anyone can diagnose why the following formula has recently stopped working:
=smfGetTagContent("http://finance. yahoo.com/ ","span",-1,q?s=IBM "yfs_l91_ ","")
It is supposed to pull in the After Hours price from Yahoo's quote page, and it worked as of last week. I assume some recent change to Yahoo's page, but I forget where I got the original formula from (I assume this msg. board), and so am not sure how to troubleshoot it. Thanks.
- 1b.
-
Re: After-hours quote from Yahoo
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Wed Jan 4, 2012 3:05 pm (PST)
I just cut and pasted the formula into EXCEL, and it's working fine here...
Do you have your Internet Options set to always get a new copy of a web
page? Did you run smfForceRecalculation to get a fresh copy of the web
page? See the related items in the "Links" area of the group for more info
on those suggestions...
On Wed, Jan 4, 2012 at 3:57 PM, bizmark_ee <markpadden@hotmail.com > wrote:
> Curious if anyone can diagnose why the following formula has recently
> stopped working:
>
> =smfGetTagContent("http://finance. yahoo.com/ q?s=IBM
> ","span",-1,"yfs_l91_ ","")
>
> It is supposed to pull in the After Hours price from Yahoo's quote page,
> and it worked as of last week. I assume some recent change to Yahoo's
> page, but I forget where I got the original formula from (I assume this
> msg. board), and so am not sure how to troubleshoot it. Thanks.
>
- 1c.
-
Re: After-hours quote from Yahoo
Posted by: "bizmark_ee" markpadden@hotmail.com bizmark_ee
Wed Jan 4, 2012 3:43 pm (PST)
Thanks. I did have my internet settings to always get a new copy of the page. But, I usually use Ctrl+shift+R to refresh the sheet. For some reason was not working today -- for any stock, not just IBM. Anyway, I deleted my IE cache for good measure and re-opened the sheet, and it is working for me now. Thanks for the quick reply.
Going forward, it is better to use smfForceRecalculation instead of Ctrl+shift+R?
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> I just cut and pasted the formula into EXCEL, and it's working fine here...
>
> Do you have your Internet Options set to always get a new copy of a web
> page? Did you run smfForceRecalculation to get a fresh copy of the web
> page? See the related items in the "Links" area of the group for more info
> on those suggestions...
>
> On Wed, Jan 4, 2012 at 3:57 PM, bizmark_ee <markpadden@...> wrote:
>
> > Curious if anyone can diagnose why the following formula has recently
> > stopped working:
> >
> > =smfGetTagContent("http://finance. yahoo.com/ q?s=IBM
> > ","span",-1,"yfs_l91_ ","")
> >
> > It is supposed to pull in the After Hours price from Yahoo's quote page,
> > and it worked as of last week. I assume some recent change to Yahoo's
> > page, but I forget where I got the original formula from (I assume this
> > msg. board), and so am not sure how to troubleshoot it. Thanks.
> >
>
- 1d.
-
Re: After-hours quote from Yahoo
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Wed Jan 4, 2012 3:52 pm (PST)
Ctrl+Shift+R may not always be reliable, since any worksheet you open can
change the keyboard shortcut.
I always use a button on my toolbar to run smfForceRecalculation.
On Wed, Jan 4, 2012 at 4:36 PM, bizmark_ee <markpadden@hotmail.com > wrote:
>
> Thanks. I did have my internet settings to always get a new copy of the
> page. But, I usually use Ctrl+shift+R to refresh the sheet. For some
> reason was not working today -- for any stock, not just IBM. Anyway, I
> deleted my IE cache for good measure and re-opened the sheet, and it is
> working for me now. Thanks for the quick reply.
>
> Going forward, it is better to use smfForceRecalculation instead of
> Ctrl+shift+R?
>
- 2a.
-
Re: beginner's excel errors. :(
Posted by: "upsquare78" dwvancouver@yahoo.com dwvancouver
Wed Jan 4, 2012 10:39 pm (PST)
Sorry for not being specific. I was looking for a way to get the table completely from say http://online.wsj.com/mdc/ I realize I could potentially use the RCHGetHTMLTable(public/page/ 2_3022-mfgppl- moneyflow. html. ) function but from the examples from the documentation its all done manually. I have a general update button for my file but some worksheets don't update. There is no error retrieving the webpage...
excerpt:
[...]
longOrShort = UCase(longOrShort)
If longOrShort = "LONG" Then
url = "http://online.wsj.com/mdc/ "public/page/ 2_3022-mfgppl- moneyflow. html
Set rg = Worksheets("BuyOnWeakness" ).Range(" B2")
Else
url = "http://online.wsj.com/mdc/ "public/page/ 2_3022-mflppg- moneyflow. html
Set rg = Worksheets("SellOnStrength" ).Range(" B2")
End If
[...]
Dim oHTTP As New XMLHTTP
oHTTP.Open "GET", url, False
oHTTP.send
If oHTTP.Status = "200" Then
htmlText = oHTTP.responseText
a = InStr(htmlText, "mdcTblName")
If a > 0 Then 'valid html file
'find the table head
a = InStr(a, htmlText, "<span>")
htmlText = Mid(htmlText, a)
a = InStr(htmlText, ",")
b = InStr(htmlText, "ET")
slice = Trim(Mid(htmlText, a + 1, b - a - 1))
a = InStr(slice, "-")
rg.Offset(-1, 0) = CDate(Left(slice, a - 1))
rg.Offset(-1, 1) = Trim(Mid(slice, a + 1))
n = 0
tickers = ""
a = InStr(htmlText, "symbol=")
[...]
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> You probably need the HTML Object library as a reference.
>
> I don't know what you're after specifically, but this basic form of the
> function retrieves data for me:
>
> =RCHGetTableCell("
> http://online.wsj.com/mdc/ ",1,">Basicpublic/page/ 2_3022-mfsctrsca n-moneyflow. html
> Materials")
>
> On Sat, Dec 31, 2011 at 12:37 AM, upsquare78 <dwvancouver@...> wrote:
>
> > when I'm running modUtilities and some other mods I get a compile error:
> > user-defined type not defined at Dim oHTML As New HTMLDocument...
> >
> > As well how would I get data from
> > http://online.wsj.com/mdc/ public/page/ 2_3022-mfsctrsca n-moneyflow. html?
> > something I got no-longer works.
> >
> > [vista, excel 2007]
> >
>
Need to Reply?
Click one of the "Reply" links to respond to a specific message in the Daily Digest.
MARKETPLACE
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Individual | Switch format to Traditional
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe
Tidak ada komentar:
Posting Komentar