Jumat, 16 Maret 2018

[smf_addin] Digest Number 4315[1 Attachment]

15 Messages

Digest #4315

Messages

Fri Mar 16, 2018 6:16 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

So, if you start up EXCEL and open a new workbook, you're saying this
function:

=RCHGetElementNumber("Version")

....returns the #NAME? error?

And that when the add-in is activated, this:

=smfConvertData("1B")

....returns a blank?

On Fri, Mar 16, 2018 at 3:38 AM, cschwartz@
​...
wrote:

>
> - The Add-in is always activated
> - I need to go to "Edit Link" (under Data) in order to activate the SMF
> function - I don;t know why but I do
> - The Version of SMF is from Jan.24/18
> - The issue only started happening after a new update went on my computer
> from windows
> - the SMFConvertData also doe snot work. It puts a blank in the cell.
>
>

Fri Mar 16, 2018 7:14 am (PDT) . Posted by:

"Higrm" higrm

Hi Randy,I just wanted to see what happened on my sheet, so I entered the =smfConvertData("1B")  but the answer I got was 1,000,000.  I then tried 1M, and got 1,000.  Which is also what I got when I tried 1K.  I've never needed this function, but are those the correct results?  Or am I missing three zeros on the B and M results?
Thanks,Higrm


On Friday, March 16, 2018, 2:17:24 PM GMT+1, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:

 

So, if you start up EXCEL and open a new workbook, you're saying this function:
=RCHGetElementNumber("Version&quot;)
....returns the #NAME? error?
And that when the add-in is activated, this:
=smfConvertData("1B")
....returns a blank?

Fri Mar 16, 2018 7:53 am (PDT) . Posted by:

stumpy_chris

Yes both both:

The version formula returns the #NAME?


The smfConvertData returns a blank cell

Fri Mar 16, 2018 8:05 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

When I first wrote my conversion routines, it was for tables that had
numbers in "thousand of dollars", so I converted the "1B" and "1M"
exception into "thousands of dollars" as well. That hasn't been the right
decision in all cases.

I've considered changing it, but I'm not sure what backlash that might have
for existing usages of the function...

On Fri, Mar 16, 2018 at 7:14 AM, Higrm higrm@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> I just wanted to see what happened on my sheet, so I entered the
> =smfConvertData("1B") but the answer I got was 1,000,000. I then tried
> 1M, and got 1,000. Which is also what I got when I tried 1K. I've never
> needed this function, but are those the correct results? Or am I missing
> three zeros on the B and M results?
>
>

Fri Mar 16, 2018 8:12 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

OK, so the first result means the add-in isn't activated. Did you try
unblocking the XLA file? Are you using any other add-ins?

The second result makes no sense to me at all. If the VBA code runs into an
error, it should be returning what was sent.

On Fri, Mar 16, 2018 at 7:52 AM, cschwartz@
​...
wrote:

>
> Yes both both:
>
> The version formula returns the #NAME?
>
> The smfConvertData returns a blank cell
>

Fri Mar 16, 2018 8:43 am (PDT) . Posted by:

"Higrm" higrm

Thanks for clarifying.  I looked into the VBA and see that there some inconsistency since "Bil" brings back a different value than "B", but I suppose that is because it was used on different tables.  No need to do any modifications on my behalf, as I stated I've not needed to do any conversions myself.

        Select Case True
            Case UCase(Right(s2, 1)) = "B": s2 = Left(s2, Len(s2) - 1): nMult = 1000000
            Case UCase(Right(s2, 1)) = "K": s2 = Left(s2, Len(s2) - 1): nMult = 1000
            Case UCase(Right(s2, 1)) = "M": s2 = Left(s2, Len(s2) - 1): nMult = 1000
            Case Right(s2, 1) = "%": s2 = Left(s2, Len(s2) - 1): nMult = 0.01
            Case Right(s2, 4) = " Bil": s2 = Left(s2, Len(s2) - 4): nMult = 1000000000
            Case Right(s2, 4) = " Mil": s2 = Left(s2, Len(s2) - 4): nMult = 1000000
            Case Right(s2, 4) = " bil": s2 = Left(s2, Len(s2) - 4): nMult = 1000000000
            Case Right(s2, 4) = " mil": s2 = Left(s2, Len(s2) - 4): nMult = 1000000
            Case Right(s2, 5) = " Bill": s2 = Left(s2, Len(s2) - 5): nMult = 1000000000
            Case Right(s2, 5) = " Mill": s2 = Left(s2, Len(s2) - 5): nMult = 1000000
            Case Right(s2, 8) = " Billion": s2 = Left(s2, Len(s2) - 8): nMult = 1000000000
            Case Right(s2, 8) = " Million": s2 = Left(s2, Len(s2) - 8): nMult = 1000000
            Case Else: nMult = 1


On Friday, March 16, 2018, 4:08:31 PM GMT+1, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:

 

When I first wrote my conversion routines, it was for tables that had numbers in "thousand of dollars", so I converted the "1B" and "1M" exception into "thousands of dollars" as well. That hasn't been the right decision in all cases.
I've considered changing it, but I'm not sure what backlash that might have for existing usages of the function....
On Fri, Mar 16, 2018 at 7:14 AM, Higrm higrm@yahoo.com [smf_addin] <smf_addin@yahoogroups.com> wrote:

I just wanted to see what happened on my sheet, so I entered the =smfConvertData("1B")  but the answer I got was 1,000,000.  I then tried 1M, and got 1,000.  Which is also what I got when I tried 1K.  I've never needed this function, but are those the correct results?  Or am I missing three zeros on the B and M results?

Fri Mar 16, 2018 8:44 am (PDT) . Posted by:

stumpy_chris

I noticed there was another add-in ticked (which i have no unticked)

I don't think the SMF function is blocked (but it is still not working). I have no idea what to do.


Is there any other information you need me to provide.


Fri Mar 16, 2018 11:01 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

If it's not loading, it's not loading. Unfortunately, I don't know of a way
to investigate/diagnose the problem on your end. But I am aware of the
Microsoft Security Update I mentioned, and they suggested several
work-arounds. I know those worked for some people. If those work-arounds
don't work, there must be something else in your configuration that is
causing the problem, but I don't know how to discover that.

On Fri, Mar 16, 2018 at 8:44 AM, cschwartz@
​...
wrote:

>
> I noticed there was another add-in ticked (which i have no unticked)
>
> I don't think the SMF function is blocked (but it is still not working).
> I have no idea what to do.
>
> Is there any other information you need me to provide.
>
>

Fri Mar 16, 2018 12:53 pm (PDT) . Posted by:

stumpy_chris

It makes no sense. I have no idea why the SMF is not being recognized.

Here is a screen shot. I have to do this every time I go into Excel. Now always shows "Status is Unknown"






Attachment(s) from
1 of 1 Photo(s)

Fri Mar 16, 2018 1:48 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Mine says "Status Unknown" as well...

It will always say unknown, until I click "Check Status". But if I open the
"Edit Links" box again, it's right back to unknown.

But you can only see the "Edit Links" box if you have something in that
workbook using that link. So EXCEL knows your workbook is using the add-in.

Does the location of that source match what you get from the "Version"
results?

On Fri, Mar 16, 2018 at 12:53 PM, cschwartz@
​...
wrote:

>
> It makes no sense. I have no idea why the SMF is not being recognized.
>
> Here is a screen shot. I have to do this every time I go into Excel.
> Now always shows "Status is Unknown"
>
>
>

Fri Mar 16, 2018 1:52 pm (PDT) . Posted by:

stumpy_chris

Thanks for the help with this.

The Status Unknown issue then helps - I think that part is working.


Why am I still getting blanks with the SMF Convert Data when i am trying to pull fund prices

Fri Mar 16, 2018 2:07 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

So many functions call smfConvertData(), and they wouldn't work if that
function isn't working. It's designed to return what was sent if there is a
problem converting what was sent. So it makes no sense to me that sending
"1B" to the function returns blank.

On Fri, Mar 16, 2018 at 1:52 PM, cschwartz@
​...
wrote:

>
> Thanks for the help with this.
>
> The Status Unknown issue then helps - I think that part is working.
>
> Why am I still getting blanks with the SMF Convert Data when i am trying
> to pull fund prices
>

Fri Mar 16, 2018 2:55 pm (PDT) . Posted by:

stumpy_chris

Not sure what you mean here.

the smfCovertData was pulling mutual funds prices from Globe Investor. It was working up until a few days ago, not it returns a blank in the cell.

Fri Mar 16, 2018 3:43 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

smfConvertData() doesn't pull data at all. It is a utility function that
converts a string into a number if it can, otherwise it returns the
original string.

You told me this returned a blank:

=smfConvertData("1B")

....which shouldn't be possible. It is possible the function pulling the
data is now returning nothing, so when that result is sent to
smfConvertData(), you get nothing back. But that's not what you told me is
happening. Did you not try the "Version" function either?

So, what do these two functions return:

=RCHGetElementNumber("Version&quot;)
=smfConvertData("1B")

And give me an example of the full formula that is not working now, without
any cell references.

On Fri, Mar 16, 2018 at 2:55 PM, cschwartz@
​...
wrote:

>
> Not sure what you mean here.
>
> the smfCovertData was pulling mutual funds prices from Globe Investor.
> It was working up until a few days ago, not it returns a blank in the cell.
>
>

Fri Mar 16, 2018 3:56 pm (PDT) . Posted by:

stumpy_chris

Here you go:


=RCHGetElementNumber("Version") gets me:

Stock Market Functions add-iin Version 2.1.2018.01.24 (C:\Users\nugge\Documents\SMF; Windows (64-bit) NT 10.00; 16.0; ; ; 2)


=smfConvertData("1B") gets me: #NAME?



Formula being used:
=smfConvertData(smfStrExtr(smfGetTagContent("https://www.theglobeandmail.com/globe-investor/funds-and-etfs/funds/summary/?id=93852","p",-1,"Fund price:"),":","("))



Which returns a blank cell


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

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)