Senin, 10 Juli 2017

[smf_addin] Digest Number 4087

11 Messages

Digest #4087

Messages

Sun Jul 9, 2017 8:22 pm (PDT) . Posted by:

holmberg_tommy

Hi Randy,


Could you help me with bringing the EUR/SGD exchange rate from "http://www.reuters.com/finance/currencies/quote?srcAmt=1.00&srcCurr=EUR&destAmt=&destCurr=SGD" . Hopefully you can help.


Thanks,


Tommy





Sun Jul 9, 2017 11:40 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Why not just get it from Yahoo current quotes, with:

=RCHGetYahooQuotes("EURSGD=X","l1")

On Sun, Jul 9, 2017 at 8:22 PM, holmberg_tommy@
​...
wrote:

> Could you help me with bringing the EUR/SGD exchange rate from "
> http://www.reuters.com/finance/currencies/quote?srcAmt=1.00&srcCurr=EUR&
> destAmt=&destCurr=SGD" . Hopefully you can help.
>
>
>

Mon Jul 10, 2017 9:53 am (PDT) . Posted by:

holmberg_tommy

Hi Randy,

Thanks a lot. Works great.

Mon Jul 10, 2017 8:34 am (PDT) . Posted by:

"Mike" mikewa_68

Thanks Randy,.
=RCHGetElementNumber("Version") returns the below.. 

| Stock Market Functions add-in, Version 2.1.2017.05.03 (C:\SMF Add-in; Windows (32-bit) NT 6.01; 15.0; ; Local; 1) |

When I put in - 
    =smfPricesByDates("IBM", DATE(2007,1,1))
or 
   =smfPricesByDates("IBM", "1/1/2007")
I get #N/A on both cells.. 
Am running Office 2013, if that makes a difference.. 
As stated, all other APIs appear to work without an issue. Only the date related ones seem to fault out on me.. 
Thanks!

On Saturday, July 8, 2017 6:14 PM, "Randy Harmelink rharmelink@gmail.com [smf_addin]" <smf_addin@yahoogroups.com> wrote:


  These two examples from the documentation currently work for me:
=smfPricesByDates("IBM", DATE(2007,1,1))
=smfPricesByDates("IBM", "1/1/2007";)

First, check the version of the add-in you're running:
=RCHGetElementNumber("Version&quot;)

-- #NAME? would mean the function is not available. -- #NA being returned would mean the date isn't valid.-- "Error" can be any variety of things, as could the blanks.
On Sat, Jul 8, 2017 at 12:51 PM, Mike mikewa_68@​... wrote:

I feel like the odd man out here, so I suspect I'm missing something simple.. 

I've pulled in the latest Beta version of the XLA, and all the APIs work well for me except for the ones that pull info by date.The samples don't work, much less any simple ones I try.. 

When I open the RCHGetYahooHistory or smfPricesByDates samples off the site, open and update them, I get either empty cells, #NAME?, #NA or Error

All the other APIs work without an issue.. 

I have the Add-In located at C:\SMF Add-In
I've got the Add-In installed properly, as other APIs (RCHGetYahooQuotes,  RCHGetElementNumber) work without issue.. 

In the samples, where both RCHGetYahooQuotes and smfPricesByDates exist, RCHGetYahooQuotes works great, but smfPricesByDates fails.. 
Any insight?

#yiv8896977856 #yiv8896977856 -- #yiv8896977856ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv8896977856 #yiv8896977856ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv8896977856 #yiv8896977856ygrp-mkp #yiv8896977856hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv8896977856 #yiv8896977856ygrp-mkp #yiv8896977856ads {margin-bottom:10px;}#yiv8896977856 #yiv8896977856ygrp-mkp .yiv8896977856ad {padding:0 0;}#yiv8896977856 #yiv8896977856ygrp-mkp .yiv8896977856ad p {margin:0;}#yiv8896977856 #yiv8896977856ygrp-mkp .yiv8896977856ad a {color:#0000ff;text-decoration:none;}#yiv8896977856 #yiv8896977856ygrp-sponsor #yiv8896977856ygrp-lc {font-family:Arial;}#yiv8896977856 #yiv8896977856ygrp-sponsor #yiv8896977856ygrp-lc #yiv8896977856hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv8896977856 #yiv8896977856ygrp-sponsor #yiv8896977856ygrp-lc .yiv8896977856ad {margin-bottom:10px;padding:0 0;}#yiv8896977856 #yiv8896977856actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv8896977856 #yiv8896977856activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv8896977856 #yiv8896977856activity span {font-weight:700;}#yiv8896977856 #yiv8896977856activity span:first-child {text-transform:uppercase;}#yiv8896977856 #yiv8896977856activity span a {color:#5085b6;text-decoration:none;}#yiv8896977856 #yiv8896977856activity span span {color:#ff7900;}#yiv8896977856 #yiv8896977856activity span .yiv8896977856underline {text-decoration:underline;}#yiv8896977856 .yiv8896977856attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv8896977856 .yiv8896977856attach div a {text-decoration:none;}#yiv8896977856 .yiv8896977856attach img {border:none;padding-right:5px;}#yiv8896977856 .yiv8896977856attach label {display:block;margin-bottom:5px;}#yiv8896977856 .yiv8896977856attach label a {text-decoration:none;}#yiv8896977856 blockquote {margin:0 0 0 4px;}#yiv8896977856 .yiv8896977856bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv8896977856 .yiv8896977856bold a {text-decoration:none;}#yiv8896977856 dd.yiv8896977856last p a {font-family:Verdana;font-weight:700;}#yiv8896977856 dd.yiv8896977856last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv8896977856 dd.yiv8896977856last p span.yiv8896977856yshortcuts {margin-right:0;}#yiv8896977856 div.yiv8896977856attach-table div div a {text-decoration:none;}#yiv8896977856 div.yiv8896977856attach-table {width:400px;}#yiv8896977856 div.yiv8896977856file-title a, #yiv8896977856 div.yiv8896977856file-title a:active, #yiv8896977856 div.yiv8896977856file-title a:hover, #yiv8896977856 div.yiv8896977856file-title a:visited {text-decoration:none;}#yiv8896977856 div.yiv8896977856photo-title a, #yiv8896977856 div.yiv8896977856photo-title a:active, #yiv8896977856 div.yiv8896977856photo-title a:hover, #yiv8896977856 div.yiv8896977856photo-title a:visited {text-decoration:none;}#yiv8896977856 div#yiv8896977856ygrp-mlmsg #yiv8896977856ygrp-msg p a span.yiv8896977856yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv8896977856 .yiv8896977856green {color:#628c2a;}#yiv8896977856 .yiv8896977856MsoNormal {margin:0 0 0 0;}#yiv8896977856 o {font-size:0;}#yiv8896977856 #yiv8896977856photos div {float:left;width:72px;}#yiv8896977856 #yiv8896977856photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv8896977856 #yiv8896977856photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv8896977856 #yiv8896977856reco-category {font-size:77%;}#yiv8896977856 #yiv8896977856reco-desc {font-size:77%;}#yiv8896977856 .yiv8896977856replbq {margin:4px;}#yiv8896977856 #yiv8896977856ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv8896977856 #yiv8896977856ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv8896977856 #yiv8896977856ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv8896977856 #yiv8896977856ygrp-mlmsg select, #yiv8896977856 input, #yiv8896977856 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv8896977856 #yiv8896977856ygrp-mlmsg pre, #yiv8896977856 code {font:115% monospace;}#yiv8896977856 #yiv8896977856ygrp-mlmsg * {line-height:1.22em;}#yiv8896977856 #yiv8896977856ygrp-mlmsg #yiv8896977856logo {padding-bottom:10px;}#yiv8896977856 #yiv8896977856ygrp-msg p a {font-family:Verdana;}#yiv8896977856 #yiv8896977856ygrp-msg p#yiv8896977856attach-count span {color:#1E66AE;font-weight:700;}#yiv8896977856 #yiv8896977856ygrp-reco #yiv8896977856reco-head {color:#ff7900;font-weight:700;}#yiv8896977856 #yiv8896977856ygrp-reco {margin-bottom:20px;padding:0px;}#yiv8896977856 #yiv8896977856ygrp-sponsor #yiv8896977856ov li a {font-size:130%;text-decoration:none;}#yiv8896977856 #yiv8896977856ygrp-sponsor #yiv8896977856ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv8896977856 #yiv8896977856ygrp-sponsor #yiv8896977856ov ul {margin:0;padding:0 0 0 8px;}#yiv8896977856 #yiv8896977856ygrp-text {font-family:Georgia;}#yiv8896977856 #yiv8896977856ygrp-text p {margin:0 0 1em 0;}#yiv8896977856 #yiv8896977856ygrp-text tt {font-size:120%;}#yiv8896977856 #yiv8896977856ygrp-vital ul li:last-child {border-right:none !important;}#yiv8896977856

Mon Jul 10, 2017 10:37 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

You're not using the latest beta version. You're using the 2017.05.03
version, which was the last official release. Yahoo historical quotes (and
smfPricesByDates) stopped working for that in late May, when Yahoo revamped
their historical quotes. 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

Yahoo historical quotes is till in a state of flux.

On Mon, Jul 10, 2017 at 8:30 AM, Mike mikewa_68@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> =RCHGetElementNumber("Version&quot;) returns the below..
>
> Stock Market Functions add-in, Version 2.1.2017.05.03 (C:\SMF Add-in;
> Windows (32-bit) NT 6.01; 15.0; ; Local; 1)
>
> When I put in -
>
> =smfPricesByDates("IBM", DATE(2007,1,1))
> or
> =smfPricesByDates("IBM", "1/1/2007";)
>
> I get #N/A on both cells..
>
> Am running Office 2013, if that makes a difference..
>
> As stated, all other APIs appear to work without an issue. Only the date
> related ones seem to fault out on me..
>
>
>

Mon Jul 10, 2017 10:56 am (PDT) . Posted by:

gareneau

"Yahoo historical quotes is till in a state of flux." Randy, to cut to the chase, is this because Yahoo/Verizon is still changing how they deliver price data, etc. which they will eventually be done with, or is there something more unsolvable going on?


It seems progress is being made but already you've been at this for months. Do you hold out hope you can relax one day soon as all your great work is done and complete?

Mon Jul 10, 2017 11:09 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

The "state of flux" is primarily two things:

1. How they are adjusting data for dividends. They keep changing what
they're doing, trying to improve things. Some things they do improve, but
others they make worse. Right now, I do more or less trust daily closing
quotes. But not periods such as weekly or monthly, and not O/H/L (see the
7/1 status post).

2. There still seem to be dates loaded with "null" data. A lot of ETFs were
rampant with them. But even some new dates this month have shown up from
time to time.

The question at this point -- do I change my O/H/L adjustments based on
what they are currently doing, then release it as an "official release",
and fix things (if needed) later? I'm not expecting any more changes from
them in the short term...but I could be wrong.

On Mon, Jul 10, 2017 at 10:56 AM, gareneau@
​...
wrote:

>
> "Yahoo historical quotes is till in a state of flux." Randy, to cut to the
> chase, is this because Yahoo/Verizon is still changing how they deliver
> price data, etc. *which they will eventually be done with*, or is there
> something more unsolvable going on?
>
> It seems progress is being made but already you've been at this for
> months. Do you hold out hope you can relax one day soon as all your great
> work is done and complete?
>

Mon Jul 10, 2017 2:02 pm (PDT) . Posted by:

seongkook_berry

I'm probably doing something wrong but I keep getting "undefined&quot; when suing RCHGetElementNumber. Specifically, I was trying =RCHGetElementNumber("BWP";,621). I also tired doing some of the examples and I still get "undefined&quot;. I'm using Version 2.1.2017.06.09 so I don't think that's the problem.




Mon Jul 10, 2017 3:36 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

That means you don't have the element definition files (i.e.
smf-elements-*.txt) in the same folder as the XLA file. All of the element
definitions are in external files, so you get "Undefined&quot; if the
definitions can't be loaded.

Did you download the XLA file without downloading and unzipping the ZIP
file? The beta XLA only replaces the XLA file that is in the ZIP file. You
still want all of the other files.

On Mon, Jul 10, 2017 at 2:02 PM, seongkook_berry@
​...
wrote:

> I'm probably doing something wrong but I keep getting "undefined&quot; when
> suing RCHGetElementNumber. Specifically, I was trying =
> RCHGetElementNumber("BWP",621). I also tired doing some of the examples
> and I still get "undefined&quot;. I'm using Version 2.1.2017.06.09 so I don't
> think that's the problem.
>

Mon Jul 10, 2017 2:17 pm (PDT) . Posted by:

lapub1

Hi Randy,

I updated the security settings in IE and the data that wasn't coming through before comes through now.


Thanks!


Elliot.

Mon Jul 10, 2017 3:50 pm (PDT) . Posted by:

e_bartsch

Randy:


Thanks for this tip. Changing a few columns to Array formulas seems to have solved the problem. I must now be under the Yahoo threshold sniffer relating to number of requests by IP address. Glad to have the spreadsheet working again.

For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Diposting oleh EXCEL FEED LEARNING di 19.01

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)