Selasa, 01 September 2015

[smf_addin] Digest Number 3500

7 Messages

Digest #3500

Messages

Mon Aug 31, 2015 8:11 am (PDT) . Posted by:

rogacox

Randy, I have had this same issue since upgrading to Windows 10. The zachs queries return a message of "error" and other sites like nasdaq and analyst rating network are returning nothing. The RCHYahooGetQuotes works fine for all these issues. I have tried the smfForce Recalculation to no avail. You mention setting the Internet Option to always get a fresh page. Not to be dumb but where are you saying to reset this option. With this version of Windows the browser Internet Explorer is replaced with Microsoft Edge. IS this the problem? Is there a workaround? Thanks for your help.
Roger

Mon Aug 31, 2015 8:36 am (PDT) . Posted by:

rogacox

I have discovered that IE11 does still exist under Windows 10 under Windows Accessories. I updated the Internet Options to refresh every time and still have the problem previously described. Could the VBA routine still be trying to execute under Edge even though I have both IE11 and Edge running?
Roger

Mon Aug 31, 2015 10:34 am (PDT) . Posted by:

rogacox

Randy, I have uploaded a copy of the spreadsheet named "smf test" to show you the problem. Thanks,
Roger

Mon Aug 31, 2015 9:20 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Try visiting the web pages under the EXCEL Web Query dialog (keyboard
shortcut alt+d+d+w). It could be that the websites are redirecting you to
some web page. Either an advertisement, or a confirmation page of some type
("I agree....") that you have to go through before you access data. Those
would all be cookie driven, which the add-in doesn't do since it only
retrieves the source code of the web page. The browser would need to do
cookie processing.

Your uploaded workbook seems to work fine here. I had it update several
tickers...

Note that IE11 might not be the IE object that EXCEL is using. The EXCEL
web query dialog can tell you if you go to this web page:

http://www.pinlady.net/PluginDetect/IE/

On Mon, Aug 31, 2015 at 8:36 AM, rogacox@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> I have discovered that IE11 does still exist under Windows 10 under
> Windows Accessories. I updated the Internet Options to refresh every time
> and still have the problem previously described. Could the VBA routine
> still be trying to execute under Edge even though I have both IE11 and Edge
> running?
>

Mon Aug 31, 2015 10:33 am (PDT) . Posted by:


Hello,

This email message is a notification to let you know that
a file has been uploaded to the Files area of the smf_addin
group.

File : /Uploads by forum members/smf test.xlsx
Uploaded by : rogacox <rogacox@yahoo.com>
Description : test file that shows zachs error report

You can access this file at the URL:
https://groups.yahoo.com/neo/groups/smf_addin/files/Uploads%20by%20forum%20members/smf%20test.xlsx

To learn more about file sharing for your group, please visit:
https://help.yahoo.com/kb/index?page=content&y=PROD_GRPS&locale=en_US&id=SLN15398

Regards,

rogacox <rogacox@yahoo.com>

Mon Aug 31, 2015 9:06 pm (PDT) . Posted by:

gotsaurabh

How can I get the split adjusted but not dividend adjusted closing price on a specific date for a stock?


The smfPricesByDates() function retrieves the "Adj. Close" price from the Yahoo finance Historical prices page, however Yahoo Finance not only adjusts that for splits, but also pending dividends.


I do know that if I just want the prior closing price or last trading price I can use RCHGetElementNumber() or the RCHGetYahooQuotes() function.

Mon Aug 31, 2015 9:28 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

The only way I know of would be to grab the unadjusted closing price and
adjust it yourself with the applicable splits. You could get the splits
from a web page like:

http://performance.morningstar.com/Performance/stock/split-history.action?t=MMM

On Mon, Aug 31, 2015 at 11:48 AM, gotsaurabh@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> How can I get the split adjusted but not dividend adjusted closing price
> on a specific date for a stock?
>
> The smfPricesByDates() function retrieves the "Adj. Close" price from the
> Yahoo finance Historical prices page, however Yahoo Finance not only
> adjusts that for splits, but also pending dividends.
>
> I do know that if I just want the prior closing price or last trading
> price I can use RCHGetElementNumber() or the RCHGetYahooQuotes()
> function.
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar