8 New Messages
Digest #2326
| 1a Re: Why hasn't Yahoo updated their stock closing prices for most sto by "investor952" investor952 |
Messages
Sat Aug 25, 2012 7:07 pm (PDT) . Posted by:
"investor952" investor952
No..I am saying that they are showing the % change for FRIDAY, for most stocks, as 0%. This was there last night as well. By doing this, my spreadsheet cannot calculate the % change for Friday in my portfolios since they list the change as 0 for most stocks. Something is whacky.
--- In smf_addin@yahoogrou
>
> 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@
>
> > **
> >
> >
> > 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 7:50 pm (PDT) . Posted by:
"MoeB" spikemgm
Hi Randy,
Can the add-in get morningstar quotes?
I'm trying to get the nav for vxx on this page:
http://etfs.morningstar.com/quote?t=vxx
Yahoo has most nav's for etf's. but not for ETN's, which is what vxx is,
also yahoo prints a day late for nav values, morningstar does not.
=RCHGetYahooQuotes("^spy-nv","l1")
http://etfs.morningstar.com/quote?t=spy
Thanks
Steve
Can the add-in get morningstar quotes?
I'm trying to get the nav for vxx on this page:
http://etfs.
Yahoo has most nav's for etf's. but not for ETN's, which is what vxx is,
also yahoo prints a day late for nav values, morningstar does not.
=RCHGetYahooQuotes(
http://etfs.
Thanks
Steve
Sat Aug 25, 2012 8:05 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
That's a dynamically generated page, so the extraction isn't simple. But
the NAV is in the JavaScript code of the page -- try something like:
=smfConvertData(smfStrExtr(RCHGetWebData("
http://etfs.morningstar.com/quote?t=vxx ","NAV:",3000,1000),"NAV:""",""""))
On Sat, Aug 25, 2012 at 7:50 PM, MoeB <smoebius@gmail.com > wrote:
>
> Can the add-in get morningstar quotes?
>
> I'm trying to get the nav for vxx on this page:
> http://etfs.morningstar.com/quote?t=vxx
>
> Yahoo has most nav's for etf's. but not for ETN's, which is what vxx is,
>
> also yahoo prints a day late for nav values, morningstar does not.
> =RCHGetYahooQuotes("^spy-nv","l1")
> http://etfs.morningstar.com/quote?t=spy
>
the NAV is in the JavaScript code of the page -- try something like:
=smfConvertData(
http://etfs.
On Sat, Aug 25, 2012 at 7:50 PM, MoeB <smoebius@gmail.
>
> Can the add-in get morningstar quotes?
>
> I'm trying to get the nav for vxx on this page:
> http://etfs.
>
> Yahoo has most nav's for etf's. but not for ETN's, which is what vxx is,
>
> also yahoo prints a day late for nav values, morningstar does not.
> =RCHGetYahooQuotes(
> http://etfs.
>
Sun Aug 26, 2012 3:11 am (PDT) . Posted by:
"wongkayau" wongkayau
Hi Randy,
Just a quick follow up. Where is the holding area for web pages?
Thanks a lot
Cheers, L
--- In smf_addin@yahoogroups.com , "wongkayau" <wongkayau@...> wrote:
>
> 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?
> > >
> >
>
Just a quick follow up. Where is the holding area for web pages?
Thanks a lot
Cheers, L
--- In smf_addin@yahoogrou
>
> they work! you are so great, and have saved my life. thx
> 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@> 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 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?
> > >
> >
>
Sun Aug 26, 2012 3:26 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
It's the aData() array in the VBA project.
You can inspect the values in EXCEL with:
=smfGetAData(1,1)
=smfGetAData(1,2)
The former item is the URL of the first saved web page, and the latter is
the content of the first saved web page. The first subscript in each varies
from 1 to 1000, for the possible 1000 web pages that can be stored.
On Sun, Aug 26, 2012 at 3:11 AM, wongkayau <wongkayau@yahoo.com > wrote:
>
> Just a quick follow up. Where is the holding area for web pages?
>
You can inspect the values in EXCEL with:
=smfGetAData(
=smfGetAData(
The former item is the URL of the first saved web page, and the latter is
the content of the first saved web page. The first subscript in each varies
from 1 to 1000, for the possible 1000 web pages that can be stored.
On Sun, Aug 26, 2012 at 3:11 AM, wongkayau <wongkayau@yahoo.
>
> Just a quick follow up. Where is the holding area for web pages?
>
Sun Aug 26, 2012 3:33 am (PDT) . Posted by:
"wongkayau" wongkayau
Thanks! Could I erase them manually or by macro? Thanks
Cheers
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> It's the aData() array in the VBA project.
>
> You can inspect the values in EXCEL with:
>
> =smfGetAData(1,1)
> =smfGetAData(1,2)
>
> The former item is the URL of the first saved web page, and the latter is
> the content of the first saved web page. The first subscript in each varies
> from 1 to 1000, for the possible 1000 web pages that can be stored.
>
> On Sun, Aug 26, 2012 at 3:11 AM, wongkayau <wongkayau@...> wrote:
>
> >
> > Just a quick follow up. Where is the holding area for web pages?
> >
>
Cheers
--- In smf_addin@yahoogrou
>
> It's the aData() array in the VBA project.
>
> You can inspect the values in EXCEL with:
>
> =smfGetAData(
> =smfGetAData(
>
> The former item is the URL of the first saved web page, and the latter is
> the content of the first saved web page. The first subscript in each varies
> from 1 to 1000, for the possible 1000 web pages that can be stored.
>
> On Sun, Aug 26, 2012 at 3:11 AM, wongkayau <wongkayau@.
>
> >
> > Just a quick follow up. Where is the holding area for web pages?
> >
>
Sun Aug 26, 2012 3:53 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
You certainly could. The smfForceRecalculation just blanks out *all* of the
URLs to reset the array.
But you can't just erase items 1, 6, 10, and 15. You'd then have to move
later values up to fill items 1, 6, 10, and 15.
What happens is when the add-in needs a web page to extract data from, it
starts searching this array, starting from item 1. If it finds the
requested URL, it uses the saved web page for extraction of data. If it
runs into a blank URL, it then retrieves the web page from the Internet and
saves both the URL and the web page in that slot.
So, if a web page you don't want to retrieve again is in slot 25 and you
just erase slot 15, the add-in will re-retrieve that web page and store it
in slot 15, before it ever finds it in slot 25.
However, I think you would have to add the macro or function to the add-in
itself. I'm not sure a macro in your workbook could manually modify (or
even access) an array in the VBA project of the add-in. But I've never
tried it.
On Sun, Aug 26, 2012 at 3:33 AM, wongkayau <wongkayau@yahoo.com > wrote:
> Thanks! Could I erase them manually or by macro? Thanks
> Cheers
>
URLs to reset the array.
But you can't just erase items 1, 6, 10, and 15. You'd then have to move
later values up to fill items 1, 6, 10, and 15.
What happens is when the add-in needs a web page to extract data from, it
starts searching this array, starting from item 1. If it finds the
requested URL, it uses the saved web page for extraction of data. If it
runs into a blank URL, it then retrieves the web page from the Internet and
saves both the URL and the web page in that slot.
So, if a web page you don't want to retrieve again is in slot 25 and you
just erase slot 15, the add-in will re-retrieve that web page and store it
in slot 15, before it ever finds it in slot 25.
However, I think you would have to add the macro or function to the add-in
itself. I'm not sure a macro in your workbook could manually modify (or
even access) an array in the VBA project of the add-in. But I've never
tried it.
On Sun, Aug 26, 2012 at 3:33 AM, wongkayau <wongkayau@yahoo.
> Thanks! Could I erase them manually or by macro? Thanks
> Cheers
>
Sun Aug 26, 2012 4:04 am (PDT) . Posted by:
"wongkayau" wongkayau
thanks! how may i erase them manually?
thanks
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> You certainly could. The smfForceRecalculation just blanks out *all* of the
> URLs to reset the array.
>
> But you can't just erase items 1, 6, 10, and 15. You'd then have to move
> later values up to fill items 1, 6, 10, and 15.
>
> What happens is when the add-in needs a web page to extract data from, it
> starts searching this array, starting from item 1. If it finds the
> requested URL, it uses the saved web page for extraction of data. If it
> runs into a blank URL, it then retrieves the web page from the Internet and
> saves both the URL and the web page in that slot.
>
> So, if a web page you don't want to retrieve again is in slot 25 and you
> just erase slot 15, the add-in will re-retrieve that web page and store it
> in slot 15, before it ever finds it in slot 25.
>
> However, I think you would have to add the macro or function to the add-in
> itself. I'm not sure a macro in your workbook could manually modify (or
> even access) an array in the VBA project of the add-in. But I've never
> tried it.
>
> On Sun, Aug 26, 2012 at 3:33 AM, wongkayau <wongkayau@...> wrote:
>
> > Thanks! Could I erase them manually or by macro? Thanks
> > Cheers
> >
>
thanks
--- In smf_addin@yahoogrou
>
> You certainly could. The smfForceRecalculati
> URLs to reset the array.
>
> But you can't just erase items 1, 6, 10, and 15. You'd then have to move
> later values up to fill items 1, 6, 10, and 15.
>
> What happens is when the add-in needs a web page to extract data from, it
> starts searching this array, starting from item 1. If it finds the
> requested URL, it uses the saved web page for extraction of data. If it
> runs into a blank URL, it then retrieves the web page from the Internet and
> saves both the URL and the web page in that slot.
>
> So, if a web page you don't want to retrieve again is in slot 25 and you
> just erase slot 15, the add-in will re-retrieve that web page and store it
> in slot 15, before it ever finds it in slot 25.
>
> However, I think you would have to add the macro or function to the add-in
> itself. I'm not sure a macro in your workbook could manually modify (or
> even access) an array in the VBA project of the add-in. But I've never
> tried it.
>
> On Sun, Aug 26, 2012 at 3:33 AM, wongkayau <wongkayau@.
>
> > Thanks! Could I erase them manually or by macro? Thanks
> > Cheers
> >
>
Tidak ada komentar:
Posting Komentar