9 New Messages
Digest #2963
Messages
Tue Feb 11, 2014 12:17 pm (PST) . Posted by:
"ridgebacksexcel" ridgebacksexcel
I have been looking up the Historical Minimum and Maximum Price to Book values of some stocks in my spreadsheet for a while now.
They have stopped working and I am unable to figure out why.
Here is my formula for the Minimum value:
=RCHGetTableCell("http://ycharts.com/companies/"&$D5&"/price_to_book_value",1,"Minimum")
D5 is the ticker cell, In this case AAPL
What changed here and is there and easy fix to the formula?
I am trying to find the Table that shows the Minimum and Maximum values on the right side of the page under: AAPL Price to Book Value Range, Past 5 Years
Thanks.
They have stopped working and I am unable to figure out why.
Here is my formula for the Minimum value:
=RCHGetTableCell(
D5 is the ticker cell, In this case AAPL
What changed here and is there and easy fix to the formula?
I am trying to find the Table that shows the Minimum and Maximum values on the right side of the page under: AAPL Price to Book Value Range, Past 5 Years
Thanks.
Tue Feb 11, 2014 12:24 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Not sure what to tell you. Your formula works fine for me...
Are you doing a large number of data retrievals from their website?
On Tue, Feb 11, 2014 at 1:17 PM, ridgebacksexcel <tmallen2@bellsouth.net>wrote:
> I have been looking up the Historical Minimum and Maximum Price to Book
> values of some stocks in my spreadsheet for a while now.
>
> They have stopped working and I am unable to figure out why.
>
> Here is my formula for the Minimum value:
>
> =RCHGetTableCell("http://ycharts.com/companies/
> "&$D5&"/price_to_book_value",1,"Minimum")
>
> D5 is the ticker cell, In this case AAPL
>
> What changed here and is there and easy fix to the formula?
>
> I am trying to find the Table that shows the Minimum and Maximum values on
> the right side of the page under: AAPL Price to Book Value Range, Past 5
> Years
>
Are you doing a large number of data retrievals from their website?
On Tue, Feb 11, 2014 at 1:17 PM, ridgebacksexcel <tmallen2@bellsouth.
> I have been looking up the Historical Minimum and Maximum Price to Book
> values of some stocks in my spreadsheet for a while now.
>
> They have stopped working and I am unable to figure out why.
>
> Here is my formula for the Minimum value:
>
> =RCHGetTableCell(
> "&$D5&"
>
> D5 is the ticker cell, In this case AAPL
>
> What changed here and is there and easy fix to the formula?
>
> I am trying to find the Table that shows the Minimum and Maximum values on
> the right side of the page under: AAPL Price to Book Value Range, Past 5
> Years
>
Tue Feb 11, 2014 12:46 pm (PST) . Posted by:
"ridgebacksexcel" ridgebacksexcel
I was doing maybe 50 lookups.
I tried the formula in a blank spreadsheet to be sure and it still gives an error even with one lookup.
I even simplified it to this:
=RCHGetTableCell("http://ycharts.com/companies/AAPL/price_to_book_value",1,"Minimum")
Still no luck.
It may have started after I upgraded to the new SMF-Addin file you uploaded.
My other formulas seem to work in my spreadsheets. Weird.
Any other ideas?
--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Not sure what to tell you. Your formula works fine for me...
>
> Are you doing a large number of data retrievals from their website?
>
> On Tue, Feb 11, 2014 at 1:17 PM, ridgebacksexcel <tmallen2@...>wrote:
>
> > I have been looking up the Historical Minimum and Maximum Price to Book
> > values of some stocks in my spreadsheet for a while now.
> >
> > They have stopped working and I am unable to figure out why.
> >
> > Here is my formula for the Minimum value:
> >
> > =RCHGetTableCell("http://ycharts.com/companies/
> > "&$D5&"/price_to_book_value",1,"Minimum")
> >
> > D5 is the ticker cell, In this case AAPL
> >
> > What changed here and is there and easy fix to the formula?
> >
> > I am trying to find the Table that shows the Minimum and Maximum values on
> > the right side of the page under: AAPL Price to Book Value Range, Past 5
> > Years
> >
>
I tried the formula in a blank spreadsheet to be sure and it still gives an error even with one lookup.
I even simplified it to this:
=RCHGetTableCell(
Still no luck.
It may have started after I upgraded to the new SMF-Addin file you uploaded.
My other formulas seem to work in my spreadsheets. Weird.
Any other ideas?
--- In smf_addin@yahoogrou
>
> Not sure what to tell you. Your formula works fine for me...
>
> Are you doing a large number of data retrievals from their website?
>
> On Tue, Feb 11, 2014 at 1:17 PM, ridgebacksexcel <tmallen2@
>
> > I have been looking up the Historical Minimum and Maximum Price to Book
> > values of some stocks in my spreadsheet for a while now.
> >
> > They have stopped working and I am unable to figure out why.
> >
> > Here is my formula for the Minimum value:
> >
> > =RCHGetTableCell(
> > "&$D5&"
> >
> > D5 is the ticker cell, In this case AAPL
> >
> > What changed here and is there and easy fix to the formula?
> >
> > I am trying to find the Table that shows the Minimum and Maximum values on
> > the right side of the page under: AAPL Price to Book Value Range, Past 5
> > Years
> >
>
Tue Feb 11, 2014 12:52 pm (PST) . Posted by:
"ridgebacksexcel" ridgebacksexcel
I meant this formula:
=RCHGetTableCell("http://ycharts.com/companies/AAPL/price_to_book_value",1,"Minimum")
--- In smf_addin@yahoogroups.com, "ridgebacksexcel" <tmallen2@...> wrote:
>
> I was doing maybe 50 lookups.
>
> I tried the formula in a blank spreadsheet to be sure and it still gives an error even with one lookup.
>
> I even simplified it to this:
>
> =RCHGetTableCell("http://ycharts.com/companies/AAPL/price_to_book_value",1,"Minimum")
>
> Still no luck.
>
> It may have started after I upgraded to the new SMF-Addin file you uploaded.
>
> My other formulas seem to work in my spreadsheets. Weird.
>
> Any other ideas?
>
> --- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@> wrote:
> >
> > Not sure what to tell you. Your formula works fine for me...
> >
> > Are you doing a large number of data retrievals from their website?
> >
> > On Tue, Feb 11, 2014 at 1:17 PM, ridgebacksexcel <tmallen2@>wrote:
> >
> > > I have been looking up the Historical Minimum and Maximum Price to Book
> > > values of some stocks in my spreadsheet for a while now.
> > >
> > > They have stopped working and I am unable to figure out why.
> > >
> > > Here is my formula for the Minimum value:
> > >
> > > =RCHGetTableCell("http://ycharts.com/companies/
> > > "&$D5&"/price_to_book_value",1,"Minimum")
> > >
> > > D5 is the ticker cell, In this case AAPL
> > >
> > > What changed here and is there and easy fix to the formula?
> > >
> > > I am trying to find the Table that shows the Minimum and Maximum values on
> > > the right side of the page under: AAPL Price to Book Value Range, Past 5
> > > Years
> > >
> >
>
=RCHGetTableCell(
--- In smf_addin@yahoogrou
>
> I was doing maybe 50 lookups.
>
> I tried the formula in a blank spreadsheet to be sure and it still gives an error even with one lookup.
>
> I even simplified it to this:
>
> =RCHGetTableCell(
>
> Still no luck.
>
> It may have started after I upgraded to the new SMF-Addin file you uploaded.
>
> My other formulas seem to work in my spreadsheets. Weird.
>
> Any other ideas?
>
> --- In smf_addin@yahoogrou
> >
> > Not sure what to tell you. Your formula works fine for me...
> >
> > Are you doing a large number of data retrievals from their website?
> >
> > On Tue, Feb 11, 2014 at 1:17 PM, ridgebacksexcel <tmallen2@
> >
> > > I have been looking up the Historical Minimum and Maximum Price to Book
> > > values of some stocks in my spreadsheet for a while now.
> > >
> > > They have stopped working and I am unable to figure out why.
> > >
> > > Here is my formula for the Minimum value:
> > >
> > > =RCHGetTableCell(
> > > "&$D5&"
> > >
> > > D5 is the ticker cell, In this case AAPL
> > >
> > > What changed here and is there and easy fix to the formula?
> > >
> > > I am trying to find the Table that shows the Minimum and Maximum values on
> > > the right side of the page under: AAPL Price to Book Value Range, Past 5
> > > Years
> > >
> >
>
Tue Feb 11, 2014 12:54 pm (PST) . Posted by:
"ridgebacksexcel" ridgebacksexcel
Not sure why the post is showing a "/" in the middle of "Minimum".
--- In smf_addin@yahoogroups.com, "ridgebacksexcel" <tmallen2@...> wrote:
>
> I meant this formula:
>
> =RCHGetTableCell("http://ycharts.com/companies/AAPL/price_to_book_value",1,"Minimum")
>
> --- In smf_addin@yahoogroups.com, "ridgebacksexcel" <tmallen2@> wrote:
> >
> > I was doing maybe 50 lookups.
> >
> > I tried the formula in a blank spreadsheet to be sure and it still gives an error even with one lookup.
> >
> > I even simplified it to this:
> >
> > =RCHGetTableCell("http://ycharts.com/companies/AAPL/price_to_book_value",1,"Minimum")
> >
> > Still no luck.
> >
> > It may have started after I upgraded to the new SMF-Addin file you uploaded.
> >
> > My other formulas seem to work in my spreadsheets. Weird.
> >
> > Any other ideas?
> >
> > --- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@> wrote:
> > >
> > > Not sure what to tell you. Your formula works fine for me...
> > >
> > > Are you doing a large number of data retrievals from their website?
> > >
> > > On Tue, Feb 11, 2014 at 1:17 PM, ridgebacksexcel <tmallen2@>wrote:
> > >
> > > > I have been looking up the Historical Minimum and Maximum Price to Book
> > > > values of some stocks in my spreadsheet for a while now.
> > > >
> > > > They have stopped working and I am unable to figure out why.
> > > >
> > > > Here is my formula for the Minimum value:
> > > >
> > > > =RCHGetTableCell("http://ycharts.com/companies/
> > > > "&$D5&"/price_to_book_value",1,"Minimum")
> > > >
> > > > D5 is the ticker cell, In this case AAPL
> > > >
> > > > What changed here and is there and easy fix to the formula?
> > > >
> > > > I am trying to find the Table that shows the Minimum and Maximum values on
> > > > the right side of the page under: AAPL Price to Book Value Range, Past 5
> > > > Years
> > > >
> > >
> >
>
--- In smf_addin@yahoogrou
>
> I meant this formula:
>
> =RCHGetTableCell(
>
> --- In smf_addin@yahoogrou
> >
> > I was doing maybe 50 lookups.
> >
> > I tried the formula in a blank spreadsheet to be sure and it still gives an error even with one lookup.
> >
> > I even simplified it to this:
> >
> > =RCHGetTableCell(
> >
> > Still no luck.
> >
> > It may have started after I upgraded to the new SMF-Addin file you uploaded.
> >
> > My other formulas seem to work in my spreadsheets. Weird.
> >
> > Any other ideas?
> >
> > --- In smf_addin@yahoogrou
> > >
> > > Not sure what to tell you. Your formula works fine for me...
> > >
> > > Are you doing a large number of data retrievals from their website?
> > >
> > > On Tue, Feb 11, 2014 at 1:17 PM, ridgebacksexcel <tmallen2@
> > >
> > > > I have been looking up the Historical Minimum and Maximum Price to Book
> > > > values of some stocks in my spreadsheet for a while now.
> > > >
> > > > They have stopped working and I am unable to figure out why.
> > > >
> > > > Here is my formula for the Minimum value:
> > > >
> > > > =RCHGetTableCell(
> > > > "&$D5&"
> > > >
> > > > D5 is the ticker cell, In this case AAPL
> > > >
> > > > What changed here and is there and easy fix to the formula?
> > > >
> > > > I am trying to find the Table that shows the Minimum and Maximum values on
> > > > the right side of the page under: AAPL Price to Book Value Range, Past 5
> > > > Years
> > > >
> > >
> >
>
Tue Feb 11, 2014 1:00 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Just going to a blank spreadsheet wouldn't make a difference. It would
still extract the data from the same saved copy of the web page. You'd want
to exit and restart EXCEL to make sure you started from a clean slate. Or,
did you try running the smfForceRecalculation macro, to have the add-in get
fresh copies of the web pages? Maybe their web site was down or inoperative
for a short time?
If you use the EXCEL Web Query dialog (keyboard shortcut alt+d+d+w) to
visit the web page, do you see what you would expect to see? I've seen
instances in the past were a website puts up a warning page after a number
of accesses within a short time.
On Tue, Feb 11, 2014 at 1:45 PM, ridgebacksexcel <tmallen2@bellsouth.net>wrote:
> I was doing maybe 50 lookups.
>
> I tried the formula in a blank spreadsheet to be sure and it still gives
> an error even with one lookup.
>
> I even simplified it to this:
>
> =RCHGetTableCell("http://ycharts.com/companies/AAPL/price_to_book_value
> ",1,"Minimum")
>
> Still no luck.
>
> It may have started after I upgraded to the new SMF-Addin file you
> uploaded.
>
> My other formulas seem to work in my spreadsheets. Weird.
>
> Any other ideas?
>
still extract the data from the same saved copy of the web page. You'd want
to exit and restart EXCEL to make sure you started from a clean slate. Or,
did you try running the smfForceRecalculati
fresh copies of the web pages? Maybe their web site was down or inoperative
for a short time?
If you use the EXCEL Web Query dialog (keyboard shortcut alt+d+d+w) to
visit the web page, do you see what you would expect to see? I've seen
instances in the past were a website puts up a warning page after a number
of accesses within a short time.
On Tue, Feb 11, 2014 at 1:45 PM, ridgebacksexcel <tmallen2@bellsouth.
> I was doing maybe 50 lookups.
>
> I tried the formula in a blank spreadsheet to be sure and it still gives
> an error even with one lookup.
>
> I even simplified it to this:
>
> =RCHGetTableCell(
> ",1,"
>
> Still no luck.
>
> It may have started after I upgraded to the new SMF-Addin file you
> uploaded.
>
> My other formulas seem to work in my spreadsheets. Weird.
>
> Any other ideas?
>
Tue Feb 11, 2014 1:10 pm (PST) . Posted by:
"ridgebacksexcel" ridgebacksexcel
Ok now this is getting interesting.
I copied the URL from the formula and then pasted it into Internet Explorer. It goes to the web page just fine.
I then tried the alt+d+d+w shortcut (never knew about this) and it brought up the web query which I have seen before.
I pasted the same URL into that and I got this:
Ycharts is undergoing scheduled system maintenance. We will be back shortly.
Now why the difference?
Is this my problem?
How come the formula works for you but not me?
I copied the URL from the formula and then pasted it into Internet Explorer. It goes to the web page just fine.
I then tried the alt+d+d+w shortcut (never knew about this) and it brought up the web query which I have seen before.
I pasted the same URL into that and I got this:
Ycharts is undergoing scheduled system maintenance. We will be back shortly.
Now why the difference?
Is this my problem?
How come the formula works for you but not me?
Tue Feb 11, 2014 1:17 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Well, at least that explains why you are not getting data.
I would suspect two things are going on here:
1. For some reason, the IE object EXCEL is using is a different version of
IE than the one you're using as a browser. I'm not sure exactly how or why
this happens.
2. The IE object being used by EXCEL is using a cached copy of the web
page. You can try going to your Internet Options and make sure it is set to
ALWAYS get a new copy of web pages that are visited.
On Tue, Feb 11, 2014 at 2:10 PM, ridgebacksexcel <tmallen2@bellsouth.net>wrote:
> Ok now this is getting interesting.
>
> I copied the URL from the formula and then pasted it into Internet
> Explorer. It goes to the web page just fine.
>
> I then tried the alt+d+d+w shortcut (never knew about this) and it brought
> up the web query which I have seen before.
>
> I pasted the same URL into that and I got this:
>
> Ycharts is undergoing scheduled system maintenance. We will be back
> shortly.
>
> Now why the difference?
> Is this my problem?
> How come the formula works for you but not me?
>
I would suspect two things are going on here:
1. For some reason, the IE object EXCEL is using is a different version of
IE than the one you're using as a browser. I'm not sure exactly how or why
this happens.
2. The IE object being used by EXCEL is using a cached copy of the web
page. You can try going to your Internet Options and make sure it is set to
ALWAYS get a new copy of web pages that are visited.
On Tue, Feb 11, 2014 at 2:10 PM, ridgebacksexcel <tmallen2@bellsouth.
> Ok now this is getting interesting.
>
> I copied the URL from the formula and then pasted it into Internet
> Explorer. It goes to the web page just fine.
>
> I then tried the alt+d+d+w shortcut (never knew about this) and it brought
> up the web query which I have seen before.
>
> I pasted the same URL into that and I got this:
>
> Ycharts is undergoing scheduled system maintenance. We will be back
> shortly.
>
> Now why the difference?
> Is this my problem?
> How come the formula works for you but not me?
>
Tue Feb 11, 2014 1:57 pm (PST) . Posted by:
"ridgebacksexcel" ridgebacksexcel
I looked into your #2 suggestion. This has fixed the problem.
I upgraded my computer to Windows 8.1 about 2 months ago. That changed my Internet Explorer version. It was showing to handle the web pages automatically. I had the old computer set to refresh the web page every time.
When I changed the setting I did a web query to the page again. This time it pulled up the page but had a pop up box that said I had exceed the 10 page views allowed without signing in. I had signed in from Internet Explorer. Maybe this is a different portal.
I signed in from the web query page view and the web page loaded fine.
I then tried the formula again and it worked on the blank Excel sheet.
I opened my portfolio sheet and it all loaded up I am happy to report. This is a very important stat I follow so it was bugging me that it was not working. It is now. Thank you.
Its a pain dealing with these little fires from time to time but the effort is worth it. The complexity allows me some very unique insight into stocks I follow.
Thanks for your efforts in all of this. It truly saves me tons of work when it all functions well.
--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Well, at least that explains why you are not getting data.
>
> I would suspect two things are going on here:
>
> 1. For some reason, the IE object EXCEL is using is a different version of
> IE than the one you're using as a browser. I'm not sure exactly how or why
> this happens.
>
> 2. The IE object being used by EXCEL is using a cached copy of the web
> page. You can try going to your Internet Options and make sure it is set to
> ALWAYS get a new copy of web pages that are visited.
>
> On Tue, Feb 11, 2014 at 2:10 PM, ridgebacksexcel <tmallen2@...>wrote:
>
> > Ok now this is getting interesting.
> >
> > I copied the URL from the formula and then pasted it into Internet
> > Explorer. It goes to the web page just fine.
> >
> > I then tried the alt+d+d+w shortcut (never knew about this) and it brought
> > up the web query which I have seen before.
> >
> > I pasted the same URL into that and I got this:
> >
> > Ycharts is undergoing scheduled system maintenance. We will be back
> > shortly.
> >
> > Now why the difference?
> > Is this my problem?
> > How come the formula works for you but not me?
> >
>
I upgraded my computer to Windows 8.1 about 2 months ago. That changed my Internet Explorer version. It was showing to handle the web pages automatically. I had the old computer set to refresh the web page every time.
When I changed the setting I did a web query to the page again. This time it pulled up the page but had a pop up box that said I had exceed the 10 page views allowed without signing in. I had signed in from Internet Explorer. Maybe this is a different portal.
I signed in from the web query page view and the web page loaded fine.
I then tried the formula again and it worked on the blank Excel sheet.
I opened my portfolio sheet and it all loaded up I am happy to report. This is a very important stat I follow so it was bugging me that it was not working. It is now. Thank you.
Its a pain dealing with these little fires from time to time but the effort is worth it. The complexity allows me some very unique insight into stocks I follow.
Thanks for your efforts in all of this. It truly saves me tons of work when it all functions well.
--- In smf_addin@yahoogrou
>
> Well, at least that explains why you are not getting data.
>
> I would suspect two things are going on here:
>
> 1. For some reason, the IE object EXCEL is using is a different version of
> IE than the one you're using as a browser. I'm not sure exactly how or why
> this happens.
>
> 2. The IE object being used by EXCEL is using a cached copy of the web
> page. You can try going to your Internet Options and make sure it is set to
> ALWAYS get a new copy of web pages that are visited.
>
> On Tue, Feb 11, 2014 at 2:10 PM, ridgebacksexcel <tmallen2@
>
> > Ok now this is getting interesting.
> >
> > I copied the URL from the formula and then pasted it into Internet
> > Explorer. It goes to the web page just fine.
> >
> > I then tried the alt+d+d+w shortcut (never knew about this) and it brought
> > up the web query which I have seen before.
> >
> > I pasted the same URL into that and I got this:
> >
> > Ycharts is undergoing scheduled system maintenance. We will be back
> > shortly.
> >
> > Now why the difference?
> > Is this my problem?
> > How come the formula works for you but not me?
> >
>
Tidak ada komentar:
Posting Komentar