15 New Messages
Digest #2325
1a
smfGetOptionQuotes not returning Bid/Ask for 8/31 options from MSN by "cutthegrasssnow" cutthegrasssnow
1b
Re: smfGetOptionQuotes not returning Bid/Ask for 8/31 options from M by "Randy Harmelink" rharmelink
5a
Why hasn't Yahoo updated their stock closing prices for most stocks? by "investor952" investor952
5b
Randy..Re: Why hasn't Yahoo updated their stock closing prices for m by "investor952" investor952
5d
Re: Randy..Re: Why hasn't Yahoo updated their stock closing prices f by "Randy Harmelink" rharmelink
Messages
Sat Aug 25, 2012 8:58 am (PDT) . Posted by:
"cutthegrasssnow" cutthegrasssnow
I've been using smfGetOptionQuotes for many months to retrieve option bid/ask quotes from MSN with no problem. For some reason, it will not return quotes for the 8/31 series. It still retrieves monthly options quotes fine, so it seems to be something about the 8/31 series. Thoughts?
Sat Aug 25, 2012 9:13 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Sigh. Not sure what to do there. Most of the code was written before the
weeklies were available, so the code thinks you're trying to ask for a
quarterly quote on a month that's not a quarter-end, so it errors out. At
the time, I assumed any day of the month 30 or 31 would be quarterly
options...
On Sat, Aug 25, 2012 at 8:58 AM, cutthegrasssnow <dan@stitchwithus.com >wrote:
> I've been using smfGetOptionQuotes for many months to retrieve option
> bid/ask quotes from MSN with no problem. For some reason, it will not
> return quotes for the 8/31 series. It still retrieves monthly options
> quotes fine, so it seems to be something about the 8/31 series. Thoughts?
>
weeklies were available, so the code thinks you're trying to ask for a
quarterly quote on a month that's not a quarter-end, so it errors out. At
the time, I assumed any day of the month 30 or 31 would be quarterly
options...
On Sat, Aug 25, 2012 at 8:58 AM, cutthegrasssnow <dan@stitchwithus.
> I've been using smfGetOptionQuotes for many months to retrieve option
> bid/ask quotes from MSN with no problem. For some reason, it will not
> return quotes for the 8/31 series. It still retrieves monthly options
> quotes fine, so it seems to be something about the 8/31 series. Thoughts?
>
Sat Aug 25, 2012 9:05 am (PDT) . Posted by:
"wongkayau" wongkayau
Thank you so much for your quick reply, particularly in weekend.
(1) i have checked the link/forum and can only find the following macro:
Public Sub smfForceRecalculation()
iMorningStar = 0
iInit = 0
For i1 = 1 To kPages
aData(i1, 1) = "" ' Reset stored ticker array
Next i1
If Val(Application.Version) < 10 Then
Application.CalculateFull
Else
Application.CalculateFullRebuild
End If
End Sub
This macro recalls another macros (i.e. CalculateFull and CalculateFullRebuild) which are hidden.
(2) smfUpdateDownloadTable is for table only, and non-table
extraction requires smfGetTagContent.
(3) The dummy works well for most websites except bloomberg.com (poor me).
It seems (1) is the likely solution. Could you pls send me the macro or refer me to the related forum page?
Thanks a lot! ;)
Cheers,
L
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Go to the LINKS area of the Yahoo group and read the info on the macro.
>
> Basically, the add-in stores the web pages internally, and then the
> functions extract the data from those stored web pages, so clearing other
> temporary files or cache areas won't touch those.
>
> So, the two functions are actually (1) purge all saved web pages, and (2)
> recalculate (which causes all needed web pages to be retrieved and saved
> again). To selectively purge a few web pages and then selectively update
> the related functions would be non-trivial.
>
> Would it be possible to use the smfUpdateDownloadTable to do your updating?
> It saves values instead of using recalculating formulas. It updates from
> the top of the table to the first blank ticker symbol, so you could put
> those you want to update at the top, followed by a blank line.
>
> There was an enhancement I wanted to make too -- someone posted a routine
> that I was going to add, that would ONLY updated highlighted lines. So you
> could pick your rows, and then run the macro to only update those rows. The
> discussion was here:
>
> http://finance.groups.yahoo.com/group/smf_addin/message/15341
>
> Another option you could look at is to trick the add-in into thinking
> you're getting a new web page for those you want to update -- I've done
> that before, when I want to recalculate selected items.
>
> For example, suppose I have this function:
>
> =RCHGetTableCell("http://finance.yahoo.com/q/ks?s=MMM ",1,"Market Cap
> (intraday)")
>
> If I create a new URL with a dummy variable, it will treat that as a new
> web page:
>
> =RCHGetTableCell("http://finance.yahoo.com/q/ks?s=MMM&dummy=1 ",1,"Market
> Cap (intraday)")
>
> Now if the ticker symbol were in column B and a dummy value were in column
> C:
>
> =RCHGetTableCell("http://finance.yahoo.com/q/ks?s= "&B6&"&dummy="&C6,1,"Market
> Cap (intraday)")
>
> ...then all I need to do is change the value in column C to force an
> update. Note that the value you change it to has to be one you haven't
> already used, otherwise it would just go back and extract data from the
> previously saved web page.
>
> On Fri, Aug 24, 2012 at 10:03 PM, wongkayau <wongkayau@...> wrote:
>
> >
> > Just a quick question.
> >
> > "Smfforecrecalculation" basically has 2 functions: (1) clear cache and (2)
> > update data from websites. Could you pls tell me the macro for (1)?
> >
> > I have built a spreadsheet to download data from Bloomberg.com. I
> > download quite a no. of stocks (about 250). To speed up the downloading, I
> > have drafted a macro to update 5 stocks each time. However, the data
> > couldn't be refreshed, even though I manually clear everything (temp
> > internet files, cookies, history, etc) in the IE9. "Smfforecrecalculation"
> > may help, but it forces me to download all 250 stocks at the same time
> > which holds up my computer by 15-20mins.
> >
> > I tried google and find the followings scripts but they are no different
> > to manual clearance of internet files.
> > Shell "RunDll32.exe InetCpl.cpl,ClearMyTracksByProcess 8 "
> > Shell "RunDll32.exe InetCpl.cpl,ClearMyTracksByProcess 255"
> > Shell "RunDll32.exe InetCpl.cpl,ClearMyTracksByProcess 4351"
> >
>
(1) i have checked the link/forum and can only find the following macro:
Public Sub smfForceRecalculati
iMorningStar = 0
iInit = 0
For i1 = 1 To kPages
aData(i1, 1) = "" ' Reset stored ticker array
Next i1
If Val(Application.
Application.
Else
Application.
End If
End Sub
This macro recalls another macros (i.e. CalculateFull and CalculateFullRebuil
(2) smfUpdateDownloadTa
extraction requires smfGetTagContent.
(3) The dummy works well for most websites except bloomberg.com (poor me).
It seems (1) is the likely solution. Could you pls send me the macro or refer me to the related forum page?
Thanks a lot! ;)
Cheers,
L
--- In smf_addin@yahoogrou
>
> Go to the LINKS area of the Yahoo group and read the info on the macro.
>
> Basically, the add-in stores the web pages internally, and then the
> functions extract the data from those stored web pages, so clearing other
> temporary files or cache areas won't touch those.
>
> So, the two functions are actually (1) purge all saved web pages, and (2)
> recalculate (which causes all needed web pages to be retrieved and saved
> again). To selectively purge a few web pages and then selectively update
> the related functions would be non-trivial.
>
> Would it be possible to use the smfUpdateDownloadTa
> It saves values instead of using recalculating formulas. It updates from
> the top of the table to the first blank ticker symbol, so you could put
> those you want to update at the top, followed by a blank line.
>
> There was an enhancement I wanted to make too -- someone posted a routine
> that I was going to add, that would ONLY updated highlighted lines. So you
> could pick your rows, and then run the macro to only update those rows. The
> discussion was here:
>
> http://finance.
>
> Another option you could look at is to trick the add-in into thinking
> you're getting a new web page for those you want to update -- I've done
> that before, when I want to recalculate selected items.
>
> For example, suppose I have this function:
>
> =RCHGetTableCell(
> (intraday)")
>
> If I create a new URL with a dummy variable, it will treat that as a new
> web page:
>
> =RCHGetTableCell(
> Cap (intraday)")
>
> Now if the ticker symbol were in column B and a dummy value were in column
> C:
>
> =RCHGetTableCell(
> Cap (intraday)")
>
> ...then all I need to do is change the value in column C to force an
> update. Note that the value you change it to has to be one you haven't
> already used, otherwise it would just go back and extract data from the
> previously saved web page.
>
> On Fri, Aug 24, 2012 at 10:03 PM, wongkayau <wongkayau@.
>
> >
> > Just a quick question.
> >
> > "Smfforecrecalculat
> > update data from websites. Could you pls tell me the macro for (1)?
> >
> > I have built a spreadsheet to download data from Bloomberg.com. I
> > download quite a no. of stocks (about 250). To speed up the downloading, I
> > have drafted a macro to update 5 stocks each time. However, the data
> > couldn't be refreshed, even though I manually clear everything (temp
> > internet files, cookies, history, etc) in the IE9. "Smfforecrecalculat
> > may help, but it forces me to download all 250 stocks at the same time
> > which holds up my computer by 15-20mins.
> >
> > I tried google and find the followings scripts but they are no different
> > to manual clearance of internet files.
> > Shell "RunDll32.exe InetCpl.cpl,
> > Shell "RunDll32.exe InetCpl.cpl,
> > Shell "RunDll32.exe InetCpl.cpl,
> >
>
Sat Aug 25, 2012 9:22 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
CalculateFull and CalculateFullRebuild are not macros -- they are EXCEL
application-level methods that force all workbooks to recalculate.
smfUpdateDownloadTable is not for RCHGetTableCell() only. You can pretty
much use any single-cell add-in formula you normally can, with a very few
exceptions.
You can still use the dummy option at Bloomberg -- instead of something
like:
http://www.bloomberg.com/quote/MMM:US
...you would use:
http://www.bloomberg.com/quote/MMM:US?dummy=1
http://www.bloomberg.com/quote/MMM:US?dummy=2
On Sat, Aug 25, 2012 at 9:05 AM, wongkayau <wongkayau@yahoo.com > wrote:
> Thank you so much for your quick reply, particularly in weekend.
>
> (1) i have checked the link/forum and can only find the following macro:
>
> Public Sub smfForceRecalculation()
> iMorningStar = 0
> iInit = 0
> For i1 = 1 To kPages
> aData(i1, 1) = "" ' Reset stored ticker array
> Next i1
> If Val(Application.Version) < 10 Then
> Application.CalculateFull
> Else
> Application.CalculateFullRebuild
> End If
> End Sub
>
> This macro recalls another macros (i.e. CalculateFull and
> CalculateFullRebuild) which are hidden.
>
> (2) smfUpdateDownloadTable is for table only, and non-table
> extraction requires smfGetTagContent.
>
> (3) The dummy works well for most websites except bloomberg.com (poor me).
>
> It seems (1) is the likely solution. Could you pls send me the macro or
> refer me to the related forum page?
>
application-
smfUpdateDownloadTa
much use any single-cell add-in formula you normally can, with a very few
exceptions.
You can still use the dummy option at Bloomberg -- instead of something
like:
http://www.bloomber
...you would use:
http://www.bloomber
http://www.bloomber
On Sat, Aug 25, 2012 at 9:05 AM, wongkayau <wongkayau@yahoo.
> Thank you so much for your quick reply, particularly in weekend.
>
> (1) i have checked the link/forum and can only find the following macro:
>
> Public Sub smfForceRecalculati
> iMorningStar = 0
> iInit = 0
> For i1 = 1 To kPages
> aData(i1, 1) = "" ' Reset stored ticker array
> Next i1
> If Val(Application.
> Application.
> Else
> Application.
> End If
> End Sub
>
> This macro recalls another macros (i.e. CalculateFull and
> CalculateFullRebuil
>
> (2) smfUpdateDownloadTa
> extraction requires smfGetTagContent.
>
> (3) The dummy works well for most websites except bloomberg.com (poor me).
>
> It seems (1) is the likely solution. Could you pls send me the macro or
> refer me to the related forum page?
>
Sat Aug 25, 2012 9:33 am (PDT) . Posted by:
"wongkayau" wongkayau
they work! you are so great, and have saved my life. thx
wish you have a great weekend.
cheers.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> CalculateFull and CalculateFullRebuild are not macros -- they are EXCEL
> application-level methods that force all workbooks to recalculate.
>
> smfUpdateDownloadTable is not for RCHGetTableCell() only. You can pretty
> much use any single-cell add-in formula you normally can, with a very few
> exceptions.
>
> You can still use the dummy option at Bloomberg -- instead of something
> like:
>
> http://www.bloomberg.com/quote/MMM:US
>
> ...you would use:
>
> http://www.bloomberg.com/quote/MMM:US?dummy=1
> http://www.bloomberg.com/quote/MMM:US?dummy=2
>
> On Sat, Aug 25, 2012 at 9:05 AM, wongkayau <wongkayau@...> wrote:
>
> > Thank you so much for your quick reply, particularly in weekend.
> >
> > (1) i have checked the link/forum and can only find the following macro:
> >
> > Public Sub smfForceRecalculation()
> > iMorningStar = 0
> > iInit = 0
> > For i1 = 1 To kPages
> > aData(i1, 1) = "" ' Reset stored ticker array
> > Next i1
> > If Val(Application.Version) < 10 Then
> > Application.CalculateFull
> > Else
> > Application.CalculateFullRebuild
> > End If
> > End Sub
> >
> > This macro recalls another macros (i.e. CalculateFull and
> > CalculateFullRebuild) which are hidden.
> >
> > (2) smfUpdateDownloadTable is for table only, and non-table
> > extraction requires smfGetTagContent.
> >
> > (3) The dummy works well for most websites except bloomberg.com (poor me).
> >
> > It seems (1) is the likely solution. Could you pls send me the macro or
> > refer me to the related forum page?
> >
>
wish you have a great weekend.
cheers.
--- In smf_addin@yahoogrou
>
> CalculateFull and CalculateFullRebuil
> application-
>
> smfUpdateDownloadTa
> much use any single-cell add-in formula you normally can, with a very few
> exceptions.
>
> You can still use the dummy option at Bloomberg -- instead of something
> like:
>
> http://www.bloomber
>
> ...you would use:
>
> http://www.bloomber
> http://www.bloomber
>
> On Sat, Aug 25, 2012 at 9:05 AM, wongkayau <wongkayau@.
>
> > Thank you so much for your quick reply, particularly in weekend.
> >
> > (1) i have checked the link/forum and can only find the following macro:
> >
> > Public Sub smfForceRecalculati
> > iMorningStar = 0
> > iInit = 0
> > For i1 = 1 To kPages
> > aData(i1, 1) = "" ' Reset stored ticker array
> > Next i1
> > If Val(Application.
> > Application.
> > Else
> > Application.
> > End If
> > End Sub
> >
> > This macro recalls another macros (i.e. CalculateFull and
> > CalculateFullRebuil
> >
> > (2) smfUpdateDownloadTa
> > extraction requires smfGetTagContent.
> >
> > (3) The dummy works well for most websites except bloomberg.com (poor me).
> >
> > It seems (1) is the likely solution. Could you pls send me the macro or
> > refer me to the related forum page?
> >
>
Sat Aug 25, 2012 9:32 am (PDT) . Posted by:
"cs.holdings" cs.holdings
Is there anything I can do to get the MSN codes to require?
For example, returns "error"
=RCHGetElementNumber("XOM",1)
For example, returns "error"
=RCHGetElementNumbe
Sat Aug 25, 2012 9:38 am (PDT) . Posted by:
"Randy H" rharmelink
I suspect you just need the updated element definitions for MSN, since
they have changed their web page structure since the last official
release of the add-in -- see:
http://finance.groups.yahoo.com/group/smf_addin/message/18529
Best practice:
1. Exit EXCEL
2. Download the new version of the element definition file
3. Replace the older version of this file in your add-in's file
folder with the newer downloaded version
4. Restart EXCEL
On Sat, Aug 25, 2012 at 9:30 AM, cs.holdings <c.s.holdings@sbcglobal.net
<mailto:c.s.holdings@sbcglobal.net > > wrote:
Is there anything I can do to get the MSN codes to require?
For example, returns "error"
=RCHGetElementNumber("XOM",1)
they have changed their web page structure since the last official
release of the add-in -- see:
http://finance.
Best practice:
1. Exit EXCEL
2. Download the new version of the element definition file
3. Replace the older version of this file in your add-in's file
folder with the newer downloaded version
4. Restart EXCEL
On Sat, Aug 25, 2012 at 9:30 AM, cs.holdings <c.s.holdings@
<mailto:c.s.holdings@
Is there anything I can do to get the MSN codes to require?
For example, returns "error"
=RCHGetElementNumbe
Sat Aug 25, 2012 9:43 am (PDT) . Posted by:
"cs.holdings" cs.holdings
Randy,
I was just wondering if you have ever expermented with the upper limit of RCHGetE_nbr function. I was thinking of building a 20,000 x 500 array. would the function support it? Would it soupport a 20K x 1K? Where does it crash?
I was just wondering if you have ever expermented with the upper limit of RCHGetE_nbr function. I was thinking of building a 20,000 x 500 array. would the function support it? Would it soupport a 20K x 1K? Where does it crash?
Sat Aug 25, 2012 12:50 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
The inherent limit would be that the add-in has a holding area for only
1000 web pages. Because it does save the web page into a holding area
before it extracts data from it.
In any case, I wouldn't want people to be using the add-in to grab such an
enormous amount of data. It just isn't fair to the (free) providers of the
data.
On Sat, Aug 25, 2012 at 9:43 AM, cs.holdings <c.s.holdings@sbcglobal.net >wrote:
>
> I was just wondering if you have ever expermented with the upper limit of
> RCHGetE_nbr function. I was thinking of building a 20,000 x 500 array.
> would the function support it? Would it soupport a 20K x 1K? Where does
> it crash?
>
1000 web pages. Because it does save the web page into a holding area
before it extracts data from it.
In any case, I wouldn't want people to be using the add-in to grab such an
enormous amount of data. It just isn't fair to the (free) providers of the
data.
On Sat, Aug 25, 2012 at 9:43 AM, cs.holdings <c.s.holdings@
>
> I was just wondering if you have ever expermented with the upper limit of
> RCHGetE_nbr function. I was thinking of building a 20,000 x 500 array.
> would the function support it? Would it soupport a 20K x 1K? Where does
> it crash?
>
Sat Aug 25, 2012 11:29 am (PDT) . Posted by:
"investor952" investor952
I am seeing most stocks having a change of 0% at Yahoo.
Here is an example..this is a copy/paste of part of the
stocks I watch that appear on MyYahoo :
Symbol Price Change
LNT 44.63 0.00 0.00%
XEL 27.93 0.00 0.00%
MO 34.08 0.00 0.00%
CMS 22.86 0.00 0.00%
SO 45.88 0.00 0.00%
TAL 33.99 0.00 0.00%
EXLP 21.78 -0.05 -0.23%
HRB 16.35 0.00 0.00%
LXP 9.27 0.00 0.00%
Also, if you look up these and most other stock tickers
at Yahoo Finance..you get a change of 0...which means
they have not updated with yesterday's (Friday's) closing
prices...and today is Saturday.
Here is an example..this is a copy/paste of part of the
stocks I watch that appear on MyYahoo :
Symbol Price Change
LNT 44.63 0.00 0.00%
XEL 27.93 0.00 0.00%
MO 34.08 0.00 0.00%
CMS 22.86 0.00 0.00%
SO 45.88 0.00 0.00%
TAL 33.99 0.00 0.00%
EXLP 21.78 -0.05 -0.23%
HRB 16.35 0.00 0.00%
LXP 9.27 0.00 0.00%
Also, if you look up these and most other stock tickers
at Yahoo Finance..you get a change of 0...which means
they have not updated with yesterday's (Friday's) closing
prices...and today is Saturday.
Sat Aug 25, 2012 12:16 pm (PDT) . Posted by:
"investor952" investor952
Randy..the RCHGetYahooQuotes(symbol, item) function is returning
the same price for most stocks when item equals either 'l1' or 'p'
where 'l1' is last close and 'p' is previous price.
--- In smf_addin@yahoogroups.com , "investor952" <investor952@...> wrote:
>
> I am seeing most stocks having a change of 0% at Yahoo.
>
> Here is an example..this is a copy/paste of part of the
> stocks I watch that appear on MyYahoo :
>
> Symbol Price Change
> LNT 44.63 0.00 0.00%
> XEL 27.93 0.00 0.00%
> MO 34.08 0.00 0.00%
> CMS 22.86 0.00 0.00%
> SO 45.88 0.00 0.00%
> TAL 33.99 0.00 0.00%
> EXLP 21.78 -0.05 -0.23%
> HRB 16.35 0.00 0.00%
> LXP 9.27 0.00 0.00%
>
>
> Also, if you look up these and most other stock tickers
> at Yahoo Finance..you get a change of 0...which means
> they have not updated with yesterday's (Friday's) closing
> prices...and today is Saturday.
>
the same price for most stocks when item equals either 'l1' or 'p'
where 'l1' is last close and 'p' is previous price.
--- In smf_addin@yahoogrou
>
> I am seeing most stocks having a change of 0% at Yahoo.
>
> Here is an example..this is a copy/paste of part of the
> stocks I watch that appear on MyYahoo :
>
> Symbol Price Change
> LNT 44.63 0.00 0.00%
> XEL 27.93 0.00 0.00%
> MO 34.08 0.00 0.00%
> CMS 22.86 0.00 0.00%
> SO 45.88 0.00 0.00%
> TAL 33.99 0.00 0.00%
> EXLP 21.78 -0.05 -0.23%
> HRB 16.35 0.00 0.00%
> LXP 9.27 0.00 0.00%
>
>
> Also, if you look up these and most other stock tickers
> at Yahoo Finance..you get a change of 0...which means
> they have not updated with yesterday's (Friday's) closing
> prices...and today is Saturday.
>
Sat Aug 25, 2012 12:39 pm (PDT) . Posted by:
"D DAR" randyr_cds
I'm not sure how much you would expect the price to change today, since the
market is closed.
On Sat, Aug 25, 2012 at 2:29 PM, investor952 <investor952@yahoo.com > wrote:
> **
>
>
> I am seeing most stocks having a change of 0% at Yahoo.
>
> Here is an example..this is a copy/paste of part of the
> stocks I watch that appear on MyYahoo :
>
> Symbol Price Change
> LNT 44.63 0.00 0.00%
> XEL 27.93 0.00 0.00%
> MO 34.08 0.00 0.00%
> CMS 22.86 0.00 0.00%
> SO 45.88 0.00 0.00%
> TAL 33.99 0.00 0.00%
> EXLP 21.78 -0.05 -0.23%
> HRB 16.35 0.00 0.00%
> LXP 9.27 0.00 0.00%
>
> Also, if you look up these and most other stock tickers
> at Yahoo Finance..you get a change of 0...which means
> they have not updated with yesterday's (Friday's) closing
> prices...and today is Saturday.
>
>
>
market is closed.
On Sat, Aug 25, 2012 at 2:29 PM, investor952 <investor952@
> **
>
>
> I am seeing most stocks having a change of 0% at Yahoo.
>
> Here is an example..this is a copy/paste of part of the
> stocks I watch that appear on MyYahoo :
>
> Symbol Price Change
> LNT 44.63 0.00 0.00%
> XEL 27.93 0.00 0.00%
> MO 34.08 0.00 0.00%
> CMS 22.86 0.00 0.00%
> SO 45.88 0.00 0.00%
> TAL 33.99 0.00 0.00%
> EXLP 21.78 -0.05 -0.23%
> HRB 16.35 0.00 0.00%
> LXP 9.27 0.00 0.00%
>
> Also, if you look up these and most other stock tickers
> at Yahoo Finance..you get a change of 0...which means
> they have not updated with yesterday's (Friday's) closing
> prices...and today is Saturday.
>
>
>
Sat Aug 25, 2012 12:52 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
It looks like they did the reset early for the weekend. Usually you don't
see the $0 change a 0% change until 2 or 3 am in the morning before the
market opens.
On Sat, Aug 25, 2012 at 12:16 PM, investor952 <investor952@yahoo.com > wrote:
> Randy..the RCHGetYahooQuotes(symbol, item) function is returning
> the same price for most stocks when item equals either 'l1' or 'p'
> where 'l1' is last close and 'p' is previous price.
>
> --- In smf_addin@yahoogroups.com , "investor952" <investor952@...> wrote:
> >
> > I am seeing most stocks having a change of 0% at Yahoo.
> >
> > Here is an example..this is a copy/paste of part of the
> > stocks I watch that appear on MyYahoo :
> >
> > Symbol Price Change
> > LNT 44.63 0.00 0.00%
> > XEL 27.93 0.00 0.00%
> > MO 34.08 0.00 0.00%
> > CMS 22.86 0.00 0.00%
> > SO 45.88 0.00 0.00%
> > TAL 33.99 0.00 0.00%
> > EXLP 21.78 -0.05 -0.23%
> > HRB 16.35 0.00 0.00%
> > LXP 9.27 0.00 0.00%
> >
> >
> > Also, if you look up these and most other stock tickers
> > at Yahoo Finance..you get a change of 0...which means
> > they have not updated with yesterday's (Friday's) closing
> > prices...and today is Saturday.
>
see the $0 change a 0% change until 2 or 3 am in the morning before the
market opens.
On Sat, Aug 25, 2012 at 12:16 PM, investor952 <investor952@
> Randy..the RCHGetYahooQuotes(
> the same price for most stocks when item equals either 'l1' or 'p'
> where 'l1' is last close and 'p' is previous price.
>
> --- In smf_addin@yahoogrou
> >
> > I am seeing most stocks having a change of 0% at Yahoo.
> >
> > Here is an example..this is a copy/paste of part of the
> > stocks I watch that appear on MyYahoo :
> >
> > Symbol Price Change
> > LNT 44.63 0.00 0.00%
> > XEL 27.93 0.00 0.00%
> > MO 34.08 0.00 0.00%
> > CMS 22.86 0.00 0.00%
> > SO 45.88 0.00 0.00%
> > TAL 33.99 0.00 0.00%
> > EXLP 21.78 -0.05 -0.23%
> > HRB 16.35 0.00 0.00%
> > LXP 9.27 0.00 0.00%
> >
> >
> > Also, if you look up these and most other stock tickers
> > at Yahoo Finance..you get a change of 0...which means
> > they have not updated with yesterday's (Friday's) closing
> > prices...and today is Saturday.
>
Sat Aug 25, 2012 3:04 pm (PDT) . Posted by:
"g129840" g129840
Over the last few weeks, I am suddenly getting inconsistent "Error" results for various "Get Element" formulas. What's especially strange is that some elements work for some tickers, but not for others.
Examples:
AMZN
=RCHGetElementNumber("AMZN",9366) returns a value
=RCHGetElementNumber("AMZN",5887) returns "Error"
but both are AdvFn references
yet for AAPL:
=RCHGetElementNumber("AAPL",9366) returns "Error"
=RCHGetElementNumber("AAPL",5887) returns a value
Similar inconsistencies exist for Reuter's elements and Yahoo elements.
I am using Excel 2010 with Windows 7, and everything worked fine as of about a month ago. I found the IE security settings fix suggestion for AdvFn references in the links page but that did not help. I also reinstalled the addin and ran the ReCalc macro, and nothing helped.
Is anyone having similar issues or better yet, have suggestions for solutions?
Thanks.
Examples:
AMZN
=RCHGetElementNumbe
=RCHGetElementNumbe
but both are AdvFn references
yet for AAPL:
=RCHGetElementNumbe
=RCHGetElementNumbe
Similar inconsistencies exist for Reuter's elements and Yahoo elements.
I am using Excel 2010 with Windows 7, and everything worked fine as of about a month ago. I found the IE security settings fix suggestion for AdvFn references in the links page but that did not help. I also reinstalled the addin and ran the ReCalc macro, and nothing helped.
Is anyone having similar issues or better yet, have suggestions for solutions?
Thanks.
Sat Aug 25, 2012 3:13 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
I'm not sure what to tell you -- I just tried the four formulas you have
below, and all four worked fine for me.
Since the two elements come from different web pages, it could be that you
have some connection problem, where pages aren't being returned correctly.
Do you have an issue like that in your browser, when using IE?
You said you tried the smfForceRecalculation macro -- where the results
consistent with the first data retrieval attempt, or did some that had
returned "Error" now return values, and vice versa?
On Sat, Aug 25, 2012 at 3:02 PM, g129840 <krlinde@hotmail.com > wrote:
> Over the last few weeks, I am suddenly getting inconsistent "Error"
> results for various "Get Element" formulas. What's especially strange is
> that some elements work for some tickers, but not for others.
>
> Examples:
>
> AMZN
> =RCHGetElementNumber("AMZN",9366) returns a value
> =RCHGetElementNumber("AMZN",5887) returns "Error"
> but both are AdvFn references
>
> yet for AAPL:
>
> =RCHGetElementNumber("AAPL",9366) returns "Error"
> =RCHGetElementNumber("AAPL",5887) returns a value
>
> Similar inconsistencies exist for Reuter's elements and Yahoo elements.
>
> I am using Excel 2010 with Windows 7, and everything worked fine as of
> about a month ago. I found the IE security settings fix suggestion for
> AdvFn references in the links page but that did not help. I also
> reinstalled the addin and ran the ReCalc macro, and nothing helped.
>
> Is anyone having similar issues or better yet, have suggestions for
> solutions?
>
below, and all four worked fine for me.
Since the two elements come from different web pages, it could be that you
have some connection problem, where pages aren't being returned correctly.
Do you have an issue like that in your browser, when using IE?
You said you tried the smfForceRecalculati
consistent with the first data retrieval attempt, or did some that had
returned "Error" now return values, and vice versa?
On Sat, Aug 25, 2012 at 3:02 PM, g129840 <krlinde@hotmail.
> Over the last few weeks, I am suddenly getting inconsistent "Error"
> results for various "Get Element" formulas. What's especially strange is
> that some elements work for some tickers, but not for others.
>
> Examples:
>
> AMZN
> =RCHGetElementNumbe
> =RCHGetElementNumbe
> but both are AdvFn references
>
> yet for AAPL:
>
> =RCHGetElementNumbe
> =RCHGetElementNumbe
>
> Similar inconsistencies exist for Reuter's elements and Yahoo elements.
>
> I am using Excel 2010 with Windows 7, and everything worked fine as of
> about a month ago. I found the IE security settings fix suggestion for
> AdvFn references in the links page but that did not help. I also
> reinstalled the addin and ran the ReCalc macro, and nothing helped.
>
> Is anyone having similar issues or better yet, have suggestions for
> solutions?
>
Tidak ada komentar:
Posting Komentar