7 Messages
Digest #4523
Messages
Sat Apr 20, 2019 9:16 am (PDT) . Posted by:
sjagers
Hi Randy,
Sorry to bug you, but I have a question about Yahoo Finance compatibility with Windows Vista and the Internet Explorer 9 web query browser engine in Excel (2007).
Last Monday, 4/15/19, all of your functions that retrieve price history from Yahoo Finance quit working on my Windows Vista PC. They worked fine on Friday, 4/12/19, but they haven't worked since then.
I had the same problem with Zacks.com functions last year and Barchart.com functions about two months ago. They haven't worked since their problem started, either.
I think it's an Internet Explorer 9 issue because I can't even open those websites (Zacks, Bartchart, and now Yahoo Finance) with the IE browser on my Windows Vista PC. Firefox works fine, but not IE9. And unfortunately, I think IE9 is the last version that works on Vista.
My two questions are: Can you tell, by looking at Yahoo Finance website, if it's no longer compatible with Internet Explorer 9? If Yahoo Finance is still compatible with IE9, then something went wrong on my Vista PC.
If Yahoo Finance is no longer compatible with IE9, do you know if there is any way to force the Excel web query browser engine to use Firefox instead of the built-in Internet Explorer version?
Thanks for your help. I really appreciate it.
Sorry to bug you, but I have a question about Yahoo Finance compatibility with Windows Vista and the Internet Explorer 9 web query browser engine in Excel (2007).
Last Monday, 4/15/19, all of your functions that retrieve price history from Yahoo Finance quit working on my Windows Vista PC. They worked fine on Friday, 4/12/19, but they haven't worked since then.
I had the same problem with Zacks.com functions last year and Barchart.com functions about two months ago. They haven't worked since their problem started, either.
I think it's an Internet Explorer 9 issue because I can't even open those websites (Zacks, Bartchart, and now Yahoo Finance) with the IE browser on my Windows Vista PC. Firefox works fine, but not IE9. And unfortunately, I think IE9 is the last version that works on Vista.
My two questions are: Can you tell, by looking at Yahoo Finance website, if it's no longer compatible with Internet Explorer 9? If Yahoo Finance is still compatible with IE9, then something went wrong on my Vista PC.
If Yahoo Finance is no longer compatible with IE9, do you know if there is any way to force the Excel web query browser engine to use Firefox instead of the built-in Internet Explorer version?
Thanks for your help. I really appreciate it.
Sat Apr 20, 2019 10:25 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Sorry, but not much can be done without you upgrading. The operating system
is by Microsoft. EXCEL is by Microsoft. IE is by Microsoft. They are no
longer supporting the versions of those products, and web sites are no
longer operating with those versions either.
And, no, there is no easy way to use a different browser to grab source
code of web pages.
I usually only upgrade my operating system and EXCEL when I get a new
computer, so often run on the cusp of that software becoming problematic.
My last upgrade, exactly two years ago, got me from Vista to Windows 10 and
EXCEL 2010 to EXCEL 365. I was starting to have website problems before I
got the new computer.
As far as testing compatibility, there's really nothing I can do on my end,
but you should be able to try the "From Web (Legacy)" option on your
computer (usually keyboard shortcut alt+d+d+w). That would use the
Microsoft's IE object that is used by EXCEL and the add-in. Just try to
navigate to one of the web pages you're wondering about.
On Sat, Apr 20, 2019 at 9:16 AM sjagers@... wrote:
>
> Sorry to bug you, but I have a question about Yahoo Finance compatibility
> with Windows Vista and the Internet Explorer 9 web query browser engine in
> Excel (2007).
>
> Last Monday, 4/15/19, all of your functions that retrieve price history
> from Yahoo Finance quit working on my Windows Vista PC. They worked fine
> on Friday, 4/12/19, but they haven't worked since then.
>
> I had the same problem with Zacks.com functions last year and Barchart.com
> functions about two months ago. They haven't worked since their problem
> started, either.
>
> I think it's an Internet Explorer 9 issue because I can't even open those
> websites (Zacks, Bartchart, and now Yahoo Finance) with the IE browser on
> my Windows Vista PC. Firefox works fine, but not IE9. And unfortunately,
> I think IE9 is the last version that works on Vista.
>
> My two questions are: Can you tell, by looking at Yahoo Finance website,
> if it's no longer compatible with Internet Explorer 9? If Yahoo Finance is
> still compatible with IE9, then something went wrong on my Vista PC.
>
> If Yahoo Finance is no longer compatible with IE9, do you know if there is
> any way to force the Excel web query browser engine to use Firefox instead
> of the built-in Internet Explorer version?
>
> Thanks for your help. I really appreciate it.
>
>
>
is by Microsoft. EXCEL is by Microsoft. IE is by Microsoft. They are no
longer supporting the versions of those products, and web sites are no
longer operating with those versions either.
And, no, there is no easy way to use a different browser to grab source
code of web pages.
I usually only upgrade my operating system and EXCEL when I get a new
computer, so often run on the cusp of that software becoming problematic.
My last upgrade, exactly two years ago, got me from Vista to Windows 10 and
EXCEL 2010 to EXCEL 365. I was starting to have website problems before I
got the new computer.
As far as testing compatibility, there's really nothing I can do on my end,
but you should be able to try the "From Web (Legacy)" option on your
computer (usually keyboard shortcut alt+d+d+w). That would use the
Microsoft'
navigate to one of the web pages you're wondering about.
On Sat, Apr 20, 2019 at 9:16 AM sjagers@... wrote:
>
> Sorry to bug you, but I have a question about Yahoo Finance compatibility
> with Windows Vista and the Internet Explorer 9 web query browser engine in
> Excel (2007).
>
> Last Monday, 4/15/19, all of your functions that retrieve price history
> from Yahoo Finance quit working on my Windows Vista PC. They worked fine
> on Friday, 4/12/19, but they haven't worked since then.
>
> I had the same problem with Zacks.com functions last year and Barchart.com
> functions about two months ago. They haven't worked since their problem
> started, either.
>
> I think it's an Internet Explorer 9 issue because I can't even open those
> websites (Zacks, Bartchart, and now Yahoo Finance) with the IE browser on
> my Windows Vista PC. Firefox works fine, but not IE9. And unfortunately,
> I think IE9 is the last version that works on Vista.
>
> My two questions are: Can you tell, by looking at Yahoo Finance website,
> if it's no longer compatible with Internet Explorer 9? If Yahoo Finance is
> still compatible with IE9, then something went wrong on my Vista PC.
>
> If Yahoo Finance is no longer compatible with IE9, do you know if there is
> any way to force the Excel web query browser engine to use Firefox instead
> of the built-in Internet Explorer version?
>
> Thanks for your help. I really appreciate it.
>
>
>
Sat Apr 20, 2019 12:49 pm (PDT) . Posted by:
sjagers
Thank you for the quick reply. I appreciate it.
You confirmed my fear. I guess it's time to move to Windows 10; I've been putting it off for too long. Have a great weekend.
You confirmed my fear. I guess it's time to move to Windows 10; I've been putting it off for too long. Have a great weekend.
Sat Apr 20, 2019 10:07 am (PDT) . Posted by:
lhassrick
The more of us in this group who vote this issue up, the more likely it can be fixed.
I suspect they made a simple change to view or permission grant that allows them to see the dividend per share data and the public, us.
I suspect they made a simple change to view or permission grant that allows them to see the dividend per share data and the public, us.
Sat Apr 20, 2019 1:18 pm (PDT) . Posted by:
"Dennis" dennis@zis.com
Are you providing stock quotes. Again?
Sent from my iPhone
> On Apr 19, 2019, at 11:55 PM, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
>
> Not subtracted. It's a proportional reduction throughout all of history.
>
> For example, if a stock pays out a $1 dividend and was $100 on the close before the ex-dividend date, all open, high, low, and close prices prior to the ex-dividend date should be reduced by 1%.
>
> Using adjusted prices means you don't NEED to add dividends back in. The problem with adding dividends back in is that your prices are only good from the point forward that you added all the dividends in. But if the prices are adjusted historically for dividends, ALL prices are correct in relation to each other. You don't need to worry if the drop from $100 to $90 is a 10% reduction in stock market prices or a payout of dividends.
>
> It's fine to get an end-of-period stock price, but you can't compare it to any other end-of-period stock price unless you adjust for premiums. Adjusted prices allow that comparison to be made directly. Besides, if you use unadjusted prices, no splits should be applied either. In many cases, a 10% stock dividend is called an 11-for-10 stock split.
>
>> On Fri, Apr 19, 2019 at 9:46 PM tmuller2@... wrote:
>>
>> Are dividend adjusted quotes just subtracting the DPS payments from the historical prices which lowers the basis so that when you calculate the price percentage change it captures the the return from dividends?
>>
>> I have always just added them back in, it can be a pain. I usually prefer to have the actual trade prices to I can calculate historical ratios. I had been having to pull from Yahoo to get the end of period stock price, which involves messing with dates. Gratefully Guru has it predefined,
>>
>
>
Sent from my iPhone
> On Apr 19, 2019, at 11:55 PM, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
>
> Not subtracted. It's a proportional reduction throughout all of history.
>
> For example, if a stock pays out a $1 dividend and was $100 on the close before the ex-dividend date, all open, high, low, and close prices prior to the ex-dividend date should be reduced by 1%.
>
> Using adjusted prices means you don't NEED to add dividends back in. The problem with adding dividends back in is that your prices are only good from the point forward that you added all the dividends in. But if the prices are adjusted historically for dividends, ALL prices are correct in relation to each other. You don't need to worry if the drop from $100 to $90 is a 10% reduction in stock market prices or a payout of dividends.
>
> It's fine to get an end-of-period stock price, but you can't compare it to any other end-of-period stock price unless you adjust for premiums. Adjusted prices allow that comparison to be made directly. Besides, if you use unadjusted prices, no splits should be applied either. In many cases, a 10% stock dividend is called an 11-for-10 stock split.
>
>> On Fri, Apr 19, 2019 at 9:46 PM tmuller2@... wrote:
>>
>> Are dividend adjusted quotes just subtracting the DPS payments from the historical prices which lowers the basis so that when you calculate the price percentage change it captures the the return from dividends?
>>
>> I have always just added them back in, it can be a pain. I usually prefer to have the actual trade prices to I can calculate historical ratios. I had been having to pull from Yahoo to get the end of period stock price, which involves messing with dates. Gratefully Guru has it predefined,
>>
>
>
Sat Apr 20, 2019 1:18 pm (PDT) . Posted by:
"Dennis" dennis@zis.com
Including. Funds?
Sent from my iPhone
> On Apr 19, 2019, at 11:55 PM, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
>
> Not subtracted. It's a proportional reduction throughout all of history.
>
> For example, if a stock pays out a $1 dividend and was $100 on the close before the ex-dividend date, all open, high, low, and close prices prior to the ex-dividend date should be reduced by 1%.
>
> Using adjusted prices means you don't NEED to add dividends back in. The problem with adding dividends back in is that your prices are only good from the point forward that you added all the dividends in. But if the prices are adjusted historically for dividends, ALL prices are correct in relation to each other. You don't need to worry if the drop from $100 to $90 is a 10% reduction in stock market prices or a payout of dividends.
>
> It's fine to get an end-of-period stock price, but you can't compare it to any other end-of-period stock price unless you adjust for premiums. Adjusted prices allow that comparison to be made directly. Besides, if you use unadjusted prices, no splits should be applied either. In many cases, a 10% stock dividend is called an 11-for-10 stock split.
>
>> On Fri, Apr 19, 2019 at 9:46 PM tmuller2@... wrote:
>>
>> Are dividend adjusted quotes just subtracting the DPS payments from the historical prices which lowers the basis so that when you calculate the price percentage change it captures the the return from dividends?
>>
>> I have always just added them back in, it can be a pain. I usually prefer to have the actual trade prices to I can calculate historical ratios. I had been having to pull from Yahoo to get the end of period stock price, which involves messing with dates. Gratefully Guru has it predefined,
>>
>
>
Sent from my iPhone
> On Apr 19, 2019, at 11:55 PM, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
>
> Not subtracted. It's a proportional reduction throughout all of history.
>
> For example, if a stock pays out a $1 dividend and was $100 on the close before the ex-dividend date, all open, high, low, and close prices prior to the ex-dividend date should be reduced by 1%.
>
> Using adjusted prices means you don't NEED to add dividends back in. The problem with adding dividends back in is that your prices are only good from the point forward that you added all the dividends in. But if the prices are adjusted historically for dividends, ALL prices are correct in relation to each other. You don't need to worry if the drop from $100 to $90 is a 10% reduction in stock market prices or a payout of dividends.
>
> It's fine to get an end-of-period stock price, but you can't compare it to any other end-of-period stock price unless you adjust for premiums. Adjusted prices allow that comparison to be made directly. Besides, if you use unadjusted prices, no splits should be applied either. In many cases, a 10% stock dividend is called an 11-for-10 stock split.
>
>> On Fri, Apr 19, 2019 at 9:46 PM tmuller2@... wrote:
>>
>> Are dividend adjusted quotes just subtracting the DPS payments from the historical prices which lowers the basis so that when you calculate the price percentage change it captures the the return from dividends?
>>
>> I have always just added them back in, it can be a pain. I usually prefer to have the actual trade prices to I can calculate historical ratios. I had been having to pull from Yahoo to get the end of period stock price, which involves messing with dates. Gratefully Guru has it predefined,
>>
>
>
Sat Apr 20, 2019 2:54 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Historical quotes with smfGetYahooHistory() and current quotes with
smfGetYahooPortfolioView(). They've been available for a long time.
On Sat, Apr 20, 2019 at 1:18 PM Dennis dennis@.... wrote:
>
> Are you providing stock quotes. Again?
>
>
On Sat, Apr 20, 2019 at 1:18 PM Dennis dennis@... wrote:
>
> Including. Funds?
>
>
>
smfGetYahooPortfoli
On Sat, Apr 20, 2019 at 1:18 PM Dennis dennis@.... wrote:
>
> Are you providing stock quotes. Again?
>
>
On Sat, Apr 20, 2019 at 1:18 PM Dennis dennis@... wrote:
>
> Including. Funds?
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar