Rabu, 09 Agustus 2017

[smf_addin] Digest Number 4116

6 Messages

Digest #4116

Messages

Wed Aug 9, 2017 7:24 am (PDT) . Posted by:

hcathree

I just updated the add-in to the latest version but am having trouble with #NAME? error. When I browse the link it appears that Excel is referencing the add-in "C:\Users...." instead of "C:\SMF Add-In..." Can fix link but it doesn't stay saved. What am I doing wrong? Thanks

Wed Aug 9, 2017 8:40 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Those references are within the saved workbook. You can check to see where
the add-in location is indicated by the add-in manager, with:

=RCHGetElementNumber("Version")

On Wed, Aug 9, 2017 at 7:24 AM, hamptona@
​...
wrote:

> I just updated the add-in to the latest version but am having trouble with
> #NAME? error. When I browse the link it appears that Excel is referencing
> the add-in "C:\Users...." instead of "C:\SMF Add-In..." Can fix link but it
> doesn't stay saved. What am I doing wrong? Thanks
>

Wed Aug 9, 2017 8:36 am (PDT) . Posted by:

"Gary" higrm

Maybe this is completely off base, but if the local setting is for decimals to be thousands separators, Excel could treat the Yahoo values as text and not recognize them as numbers. My only other guess is that user's default cell format is "text" and not "general".

--------------------------------------------
On Tue, 8/8/17, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:

Subject: Re: [smf_addin] Re: NEWBIE: #Value error in Excel simple functions
To: smf_addin@yahoogroups.com
Date: Tuesday, August 8, 2017, 6:20 PM

When I look at that worksheet, the
values being returned by VLOOKUP() *are* numeric values. If
I apply a numeric format to them, the format gets applied.
That wouldn't happen if EXCEL had them as a string
value. Also, ISTEXT() is giving me FALSE
I have no experience with EXCEL
2016. I use Office365.
I just don't understand how
EXCEL is acting so differently for you...
On Tue, Aug 8, 2017 at 4:14
AM, dvisser01@​... wrote:

Wed Aug 9, 2017 1:50 pm (PDT) . Posted by:

rus101

Hi Randy,

So I'm pretty sure that Yahoo just made another change last night (Aug 8) that added back Unadjusted as well as Adjusted historical closing prices. So now when we use current version of smfgetpricebydates, it pulls up UNADJUSTED ones, so we get price returns only and not total returns.

Not sure what that means for the add-in, if you can just revert back to prior version to make it work like it did before with C and A data fields.

Thanks for all your work man!

Denis

Wed Aug 9, 2017 2:13 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

I just tried COP, which went ex-dividend last month. Looks fine to me:

Date Open High Low Close Volume Unadj Div Adj Split Adj Dividend Split
2017-08-09 $45.7900 $46.0000 $45.3700 $45.6500 7449235 $45.6500 1.000000
1.000000
2017-08-08 $45.1500 $46.1100 $45.0000 $45.6300 8032000 $45.6300 1.000000
1.000000
2017-08-07 $45.2700 $45.4800 $44.8300 $45.1700 6370200 $45.1700 1.000000
1.000000
2017-08-04 $44.9400 $45.5900 $44.8600 $45.5600 6101100 $45.5600 1.000000
1.000000
2017-08-03 $45.6400 $45.9500 $44.6800 $44.9100 9204100 $44.9100 1.000000
1.000000
2017-08-02 $44.3900 $45.6300 $44.2700 $45.6100 9562300 $45.6100 1.000000
1.000000
2017-08-01 $45.3300 $45.3300 $44.6200 $44.7500 6685100 $44.7500 1.000000
1.000000
2017-07-31 $45.3300 $45.8700 $45.2000 $45.3700 8368400 $45.3700 1.000000
1.000000
2017-07-28 $44.7300 $45.9400 $44.6200 $45.2600 10794900 $45.2600 1.000000
1.000000
2017-07-27 $44.3400 $44.6600 $43.8200 $44.6600 9803100 $44.6600 1.000000
1.000000
2017-07-26 $43.9100 $44.3800 $43.5800 $43.7000 7124500 $43.7000 1.000000
1.000000
2017-07-25 $43.3500 $43.9600 $43.2300 $43.6500 8641100 $43.6500 1.000000
1.000000
2017-07-24 $42.7300 $42.9600 $42.5400 $42.6100 6094100 $42.6100 1.000000
1.000000
2017-07-21 $42.9600 $43.1600 $42.5700 $42.6500 6480600 $42.6500 1.000000
1.000000
2017-07-20 $43.7800 $43.8300 $43.1000 $43.2300 7663000 $43.2300 1.000000
1.000000 $0.2650
2017-07-19 $42.6893 $43.4845 $42.6794 $43.3950 8823000 $43.6600 0.993930
1.000000
2017-07-18 $43.1863 $43.1863 $42.5402 $42.8086 6834800 $43.0700 0.993930
1.000000
2017-07-17 $43.0471 $43.2559 $42.8285 $42.9279 7014700 $43.1900 0.993930
1.000000
2017-07-14 $43.0571 $43.5143 $43.0074 $43.1863 5467300 $43.4500 0.993930
1.000000
2017-07-13 $42.9577 $43.2062 $42.6396 $42.9875 7014100 $43.2500 0.993930
1.000000
2017-07-12 $43.5540 $43.7329 $42.6694 $42.9776 7907900 $43.2400 0.993930
1.000000
2017-07-11 $42.9875 $43.3950 $42.6595 $43.0869 5782600 $43.3500 0.993930
1.000000
2017-07-10 $42.5700 $43.2161 $42.5104 $42.9776 5631900 $43.2400 0.993930
1.000000

​
Ticker 2017-08-09 2017-07-21 2017-07-20 2017-07-14
COP $45.6500 $42.6500 $43.2300 $43.1863
​

On Wed, Aug 9, 2017 at 1:50 PM, rus101@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> So I'm pretty sure that Yahoo just made another change last night (Aug 8)
> that added back Unadjusted as well as Adjusted historical closing prices.
> So now when we use current version of smfgetpricebydates, it pulls up
> UNADJUSTED ones, so we get price returns only and not total returns.
>
> Not sure what that means for the add-in, if you can just revert back to
> prior version to make it work like it did before with C and A data fields.
>
> Thanks for all your work man!
>
>

Wed Aug 9, 2017 2:36 pm (PDT) . Posted by:

rus101

So I updated to add-in file from 7/12 and it seems to be working fine now. I just don't know why SPY returns with the 6/9 add-in changed overnight from Total Return to Price Only returns...

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

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)