Sabtu, 01 Juli 2017

[smf_addin] Digest Number 4076

12 Messages

Digest #4076
3b
Re: RCHGetYahooHistory parsing issue? by "Kermit W. Prather" kermitpra
5
Re: Digest Number 4075 by "tony estep" tonyestep
6b
Re: SMF Formulas returning blanks by "Randy Harmelink" rharmelink

Messages

Fri Jun 30, 2017 8:32 pm (PDT) . Posted by:

nelsonmuntz1000

Hi Randy,
Hope you are well. Looks like you've been extremely busy. Your efforts do not go unnoticed.

Any way, for ETF dividend ex-date and pay date and amount, is there an easy way to extract this info from Nasdaq? I'm not quite sure how to get the table data.
Example: http://www.nasdaq.com/symbol/vgt/dividend-history http://www.nasdaq.com/symbol/vgt/dividend-history?symbol=VGT&selected=VGT
I know you have formulas for Morningstar http://performance.morningstar.com/Performance/stock/dividend-history.action?y=50&t=VGT http://performance.morningstar.com/Performance/stock/dividend-history.action?y=50&t=VGT but Nasdaq is more up to date.

Thanks again for the great work that you do.

Sat Jul 1, 2017 12:12 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Try something like:

=RCHGetTableCell("http://www.nasdaq.com/symbol/
"&$C3&"/dividend-history",D$2,">Ex/Eff","<tr")

...where $C3 has your ticker symbol, and D$2 has the column you want (i.e.
1 thru 6).

On Fri, Jun 30, 2017 at 8:32 PM, ccoupe300@
​...
wrote:

>
> Any way, for ETF dividend ex-date and pay date and amount, is there an
> easy way to extract this info from Nasdaq? I'm not quite sure how to get
> the table data.
> Example: http://www.nasdaq.com/symbol/vgt/dividend-history
> <http://www.nasdaq.com/symbol/vgt/dividend-history?symbol=VGT&selected=VGT>
> I know you have formulas for Morningstar http://performance.
> morningstar.com/Performance/stock/dividend-history.action?y=50&t=VGT but
> Nasdaq is more up to date.
>
>

Sat Jul 1, 2017 3:07 am (PDT) . Posted by:

JCHyjun

Thank you for update, Randy!
Chaos created by Yahoo led me to quotes at Google Finance. I found that their data are often incorrect (e.g 52 week low/high). So I'd stay with Yahoo & SMF.

Sat Jul 1, 2017 6:06 am (PDT) . Posted by:

n2963p

Good day Bill and all,
Please remove me from your e-mail distribution.
Thank you

-----Original Message-----
From: "william.r.pellerin@boeing.com [smf_addin]"
Sent: Apr 24, 2017 10:18 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Re: RCHGetYahooHistory parsing issue?


Ok, fixed it.

With the new version, I moved the smf directory. This broke the
array formula.
I had to reenter the array formula.
Thanks for verifying things on your side.
Bill

Sat Jul 1, 2017 3:57 pm (PDT) . Posted by:

"Kermit W. Prather" kermitpra

At the bottom of every email is an option to unsubscribe.
One click and you are removed.

I don't bill or anyone else has the authority to remove you.

You have to do it yourself.

Kermit

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Saturday, July 01, 2017 9:06 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Re: RCHGetYahooHistory parsing issue?


Good day Bill and all,
Please remove me from your e-mail distribution.
Thank you
-----Original Message-----
From: "william.r.pellerin@boeing.com [smf_addin] <mailto:william.r.pellerin@boeing.com%20[smf_addin]> "
Sent: Apr 24, 2017 10:18 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Re: RCHGetYahooHistory parsing issue?

Ok, fixed it.

With the new version, I moved the smf directory. This broke the array formula.

I had to reenter the array formula.

Thanks for verifying things on your side.

Bill

Sat Jul 1, 2017 6:25 am (PDT) . Posted by:

gwlunceford

I think I am going to reinstall Excel and see if that works. Just wanted to make sure I wasn't missing something. I will let you guys know if that fixes it. Thanks for your assistance.

Regards,
Gary

Sat Jul 1, 2017 6:39 am (PDT) . Posted by:

"tony estep" tonyestep

That might have to do with Microsoft OneDrive. Not related to the SMF addin.

Sent from Yahoo Mail on Android

On Fri, Jun 30, 2017 at 9:31 PM, smf_addin@yahoogroups.com<smf_addin@yahoogroups.com> wrote: <!--#yiv4222702174 #yiv4222702174ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv4222702174 #yiv4222702174ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv4222702174 #yiv4222702174ygrp-mkp #yiv4222702174hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv4222702174 #yiv4222702174ygrp-mkp #yiv4222702174ads {margin-bottom:10px;}#yiv4222702174 #yiv4222702174ygrp-mkp .yiv4222702174ad {padding:0 0;}#yiv4222702174 #yiv4222702174ygrp-mkp .yiv4222702174ad p {margin:0;}#yiv4222702174 #yiv4222702174ygrp-mkp .yiv4222702174ad a {color:#0000ff;text-decoration:none;}#yiv4222702174 #yiv4222702174ygrp-sponsor #yiv4222702174ygrp-lc {font-family:Arial;}#yiv4222702174 #yiv4222702174ygrp-sponsor #yiv4222702174ygrp-lc #yiv4222702174hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv4222702174 #yiv4222702174ygrp-sponsor #yiv4222702174ygrp-lc .yiv4222702174ad {margin-bottom:10px;padding:0 0;}-->
EXCEL Stock Market Functions Add-in EXCEL Stock Market Functions Add-in Group
2 Messages
Digest #4075 1a Connecting to d.docs.live.net error by gwlunceford 1b Re: Connecting to d.docs.live.net error by "Randy Harmelink" rharmelink


Messages

1a

Connecting to d.docs.live.net error

Fri Jun 30, 2017 10:57 am (PDT) . Posted by:

gwlunceford
Randy,


When I am using the latest RCH add in, I am getting a request to log into d.docs.live. net. I have not received this log in request in the past. Has something changed or am I missing something? This may be coincidence but I recently re installed Windows 10 on my PC and also Excel 365 so not sure if I broke something by doing this.


I greatly appreciate any assistance.


Thanks,
Gary
Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . Top ^
1b

Re: Connecting to d.docs.live.net error

Fri Jun 30, 2017 12:53 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink
I can't think of a reason for that to come up. Never heard of it before. If
I use it in my browser, it says it doesn't exist.

What are you doing when you get the request to log in?

I currently use EXCEL 365 under Windows 10...

On Fri, Jun 30, 2017 at 10:57 AM, gwlunceford@
​...
wrote:

> When I am using the latest RCH add in, I am getting a request to log into
> d.docs.live. net. I have not received this log in request in the past.
> Has something changed or am I missing something? This may be coincidence
> but I recently re installed Windows 10 on my PC and also Excel 365 so not
> sure if I broke something by doing this.
>
> I greatly appreciate any assistance.
>
>
>
Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . Top ^ For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF Visit Your Group
- New Members 11
• Privacy • Unsubscribe • Terms of Use

Sat Jul 1, 2017 10:15 am (PDT) . Posted by:

benhacker

I'm sure this is something silly, but I haven't been able to get SMF to pull data anymore.


The latest XLA / SMF files are pulled in, but all my formulas (I use RCHGetYahooHistory primarily) are broken.


I have done RCHGetElement("Version&quot;) and I see it working (shows version 2.1, 5 / 3 / 2017, Windows NT 32 bit, etc). I'm running on a Virtual Box Windows 7 machine running within a MAC. I have had this configuration for 4 years or so and all has been well. Sometime in the last month I have had an issue where my formulas just return nothing.


Example: "=RCHGetYahooHistory(B21,0,0,0,0,0,0,,"A",0)"


B21 is just a ticker reference.


Now all the cells are blank.


Any help?


Ben


PS - firewall disabled, XLA security for Excel is cleared...

Sat Jul 1, 2017 10:18 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Yahoo revamped their historical quotes last month. Significantly. You need
the new *beta* version of the add-in to get them. See:

2017-05-18 announcement:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/32112
smfGetYahooHistory() parameters:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/32114
2017-05-21 announcement:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/32237
2017-05-25 announcement:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/32343
2017-06-09 announcement:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/32537

On Sat, Jul 1, 2017 at 10:11 AM, benhacker@
​...
wrote:

> I'm sure this is something silly, but I haven't been able to get SMF to
> pull data anymore.
>
> The latest XLA / SMF files are pulled in, but all my formulas (I use
> RCHGetYahooHistory primarily) are broken.
>
> I have done RCHGetElement("Version&quot;) and I see it working (shows version
> 2.1, 5 / 3 / 2017, Windows NT 32 bit, etc). I'm running on a Virtual Box
> Windows 7 machine running within a MAC. I have had this configuration for
> 4 years or so and all has been well. Sometime in the last month I have had
> an issue where my formulas just return nothing.
>
> Example: "=RCHGetYahooHistory(B21,0,0,0,0,0,0,,"A",0)"
>
> B21 is just a ticker reference.
>
> Now all the cells are blank.
>
> Any help?
>
>
> Ben
>
>
> PS - firewall disabled, XLA security for Excel is cleared...
>
>

Sat Jul 1, 2017 10:38 am (PDT) . Posted by:

benhacker

Thank you Randy.
I use SMF only once each quarter, so I guess I missed that change. Thanks for the great support.


Been using this for >10 years.

Sat Jul 1, 2017 5:20 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

​If you haven't noticed it, Yahoo historical quotes are still a mess for
splits and dividends. This item by the AmiBroker/AmiQuote author talks
about the issues:

http://www.amibroker.com/kb/2017/06/30/wrong-close-price-in-yahoo-data/​

I think I can adjust the code for the add-in, but it doesn't mean a thing
if Yahoo makes another change to fix the current mess. So I'm hesitant to
make a change.
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Diposting oleh EXCEL FEED LEARNING di 20.02

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)