Selasa, 08 Agustus 2017

[smf_addin] Digest Number 4115

7 Messages

Digest #4115

Messages

Tue Aug 8, 2017 1:04 am (PDT) . Posted by:

thefish8467

Thanks for searching for the doc ... this is strange. I can pull all values using the SMF functions BUT cannot get anything other than the #VALUE error in column F, I use Windows 10 HOME 10.0.15063 Build 15063 with Excel 2016 Professional Plus Version 1706 (Build 8229.2103). I have all the add-in's enabled in Excel. When I step through the simple formula (=VALUE(E3)) it looks like I am receiving a text value ??? (=VALUE("-0.21"). I will check via search why this could be happening as it is clearly working on your setup.

Tue Aug 8, 2017 1:21 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Here's a sample of what I'm seeing:

*Ticker* *Previous Day Close* *Last Price* *Change* *Trend*
MMM 207.65 207.44 -0.21 -0.21
AXP 85.97 85.85 -0.12 -0.12
BA 237.71 240.23 2.52 2.52
CAT 114.35 114.71 0.36 0.36
CVX 110.11 109.78 -0.33 -0.33
CSCO 31.8 31.84 0.04 0.04
KO 45.5 45.64 0.14 0.14

On Tue, Aug 8, 2017 at 1:04 AM, dvisser01@
​...
wrote:

>
> Thanks for searching for the doc ... this is strange. I can pull all
> values using the SMF functions BUT cannot get anything other than the
> #VALUE error in column F, I use Windows 10 HOME 10.0.15063 Build 15063 with
> Excel 2016 Professional Plus Version 1706 (Build 8229.2103). I have all the
> add-in's enabled in Excel. When I step through the simple formula
> (=VALUE(E3)) it looks like I am receiving a text value ???
> (=VALUE("-0.21"). I will check via search why this could be happening as it
> is clearly working on your setup.
>

Tue Aug 8, 2017 4:14 am (PDT) . Posted by:

thefish8467

Thanks for the sample - here is my result - I have tested the data coming across from the Current Quotes Data and they are text?? (I used the ISTEXT function to test):


Ticker Previous Day Close Last Price Change Trend C3 Value/Text D3 Value/Text E3 Value/Text MMM 207.65 207.44 -0.21 #VALUE! TRUE TRUE TRUE AXP 85.97 85.85 -0.12 #VALUE! TRUE TRUE TRUE BA 237.71 240.23 +2.52 #VALUE! TRUE TRUE TRUE CAT 114.35 114.71 +0.36 #VALUE! TRUE TRUE TRUE CVX 110.11 109.78 -0.33 #VALUE! TRUE TRUE TRUE CSCO 31.80 31.84 +0.04 #VALUE! TRUE TRUE TRUE KO 45.50 45.64 +0.14 #VALUE! TRUE TRUE TRUE DIS 107.69 106.35 -1.34 #VALUE! TRUE TRUE TRUE DD 82.01 81.79 -0.22 #VALUE! TRUE TRUE TRUE XOM 80.21 80.16 -0.05 #VALUE! TRUE TRUE TRUE


I tried formatting the source data to numbers ("," Format) but that did not change the error or type of value brought over with the VLOOKUP function. Could it be a Excel 2016 bug?



Tue Aug 8, 2017 9:21 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

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:

>
> Thanks for the sample - here is my result - I have tested the data coming
> across from the Current Quotes Data and they are text?? (I used the ISTEXT
> function to test):
>
> *Ticker* *Previous Day Close* *Last Price* *Change* *Trend* C3 Value/Text D3
> Value/Text E3 Value/Text
> MMM 207.65 207.44 -0.21 #VALUE! TRUE TRUE TRUE
> AXP 85.97 85.85 -0.12 #VALUE! TRUE TRUE TRUE
> BA 237.71 240.23 +2.52 #VALUE! TRUE TRUE TRUE
> CAT 114.35 114.71 +0.36 #VALUE! TRUE TRUE TRUE
> CVX 110.11 109.78 -0.33 #VALUE! TRUE TRUE TRUE
> CSCO 31.80 31.84 +0.04 #VALUE! TRUE TRUE TRUE
> KO 45.50 45.64 +0.14 #VALUE! TRUE TRUE TRUE
> DIS 107.69 106.35 -1.34 #VALUE! TRUE TRUE TRUE
> DD 82.01 81.79 -0.22 #VALUE! TRUE TRUE TRUE
> XOM 80.21 80.16 -0.05 #VALUE! TRUE TRUE TRUE
>
> I tried formatting the source data to numbers ("," Format) but that did
> not change the error or type of value brought over with the VLOOKUP
> function. Could it be a Excel 2016 bug?
>

Tue Aug 8, 2017 5:50 am (PDT) . Posted by:

gareneau

"The 2017.05.03 version of the add-in doesn't have updates for the changes Yahoo made to their Historical quotes. You'd need the 2017.07.13 beta version to get that data. Those Yahoo changes have been a major source of messages on the Yahoo group for the past few months."


Randy, newbie here and trying to get sorted out with the add-in. I went back to the June 9th post for the beta and saw the .xla link. However, it doesn't work (error webpage). Then I tried to scroll through the messages to see if someone experienced the same problem but didn't find a solution. Now I read above I need the 07.13 version not the 06.09 version (if I understand this right).


Where I might find the link to the correct beta add in so I can install? I went to this page: http://ogres-crypt.com/SMF/ http://ogres-crypt.com/SMF/ and opened the Zip file for the beta version but the version I now see in Excel is dated 07.12.


Thanks,


Gary

Tue Aug 8, 2017 6:29 am (PDT) . Posted by:

gareneau

I should add that I know you said the beta version file won't be on the ogres-crypt website, so I'm looking for a working link to the correct version in one of the messages here.

Tue Aug 8, 2017 9:38 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Sorry, 2017.07.13 is a typo. Should have been 2017.07.12.

The beta version of the add-in on the front page is the current version of
the beta (although the version I run has a few additional changes now).

On Tue, Aug 8, 2017 at 6:29 AM, gareneau@
​...
wrote:

>
> I should add that I know you said the beta version file won't be on the
> ogres-crypt website, so I'm looking for a working link to the correct
> version in one of the messages here.
>
> On Tue, Aug 8, 2017 at 5:50 AM, gareneau@
> ​...
> wrote:
>
>> "The 2017.05.03 version of the add-in doesn't have updates for the
>> changes Yahoo made to their Historical quotes. You'd need the 2017.07.13
>> beta version to get that data. Those Yahoo changes have been a major source
>> of messages on the Yahoo group for the past few months."
>>
>> Randy, newbie here and trying to get sorted out with the add-in. I went
>> back to the June 9th post for the beta and saw the .xla link. However, it
>> doesn't work (error webpage). Then I tried to scroll through the messages
>> to see if someone experienced the same problem but didn't find a solution.
>> Now I read above I need the 07.13 version not the 06.09 version (if I
>> understand this right).
>>
>> Where I might find the link to the correct beta add in so I can install?
>> I went to this page: http://ogres-crypt.com/SMF/ and opened the Zip file
>> for the beta version but the version I now see in Excel is dated 07.12.
>>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Diposting oleh EXCEL FEED LEARNING di 18.55

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)