Sabtu, 29 Juli 2017

[smf_addin] Digest Number 4105

6 Messages

Digest #4105

Messages

Sat Jul 29, 2017 4:10 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Should be an easy process. I would add two steps:

1.5) Exit EXCEL (which is implied by step 3).

2.5) Since I don't update the ZIP file every time I make changes to element
definitions, grab any updated element definitions:

http://ogres-crypt.com/SMF/Elements

If you already had up-to-date element definitions, just prevent the add-in
from overwriting those files with older files when you extract from the ZIP
file in step (2).

On Sat, Jul 29, 2017 at 3:57 PM, bob_15861586@
​...
wrote:

> If I want to update to he latest version of SMF, will the following
> procedure work?
>
> 1) Download the latest version of SMF
>
> 2) Extract the files into the directory "SMF Add-In"
>
> 3) Start Excel again.
>
> It seems very simple but some how, I am thinking to update SMF is going to
> be a several our job. I am hoping that somebody could comment.
>
>
>

Sat Jul 29, 2017 4:24 pm (PDT) . Posted by:

bob_15861586

Randy,

I did it my way and it works. GetVersion now returns:

Stock Market Functions add-in, Version 2.1.2017.05.03 (C:\SMF Add-In; Windows (32-bit) NT :.00; 15.0; ; ; 1)

The file RCHGetElementNumber-Element-Definitions.xls has a date of 5/2/2017 and a size of 2965KB.

Therefore I conclude I have the current version of SMF. Do you agree?

Bob

Sat Jul 29, 2017 4:40 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

The XLS file is not the element definitions themselves. It is what
documents the elements that are available.

You need to check each of the smf-elements-*.txt files. However, the only
element changes uploaded since then was:

smf-elements-8.txt <http://ogres-crypt.com/SMF/Elements/smf-elements-8.txt>
--
2017-07-17 03:00 AM
Earnings.com data elements
2017-05-02: Zacks web page changes
2017-07-17: Fix #1301-#1305

​I didn't update the XLS file for that change because I'm in the process of
updating Yahoo mutual fund element definitions, so it's a mixed bag at this
point.

On Sat, Jul 29, 2017 at 4:24 PM, bob_15861586@
​...
wrote:

>
> I did it my way and it works. GetVersion now returns:
> Stock Market Functions add-in, Version 2.1.2017.05.03 (C:\SMF Add-In;
> Windows (32-bit) NT :.00; 15.0; ; ; 1)
>
> The file RCHGetElementNumber-Element-Definitions.xls has a date of
> 5/2/2017 and a size of 2965KB.
>
> Therefore I conclude I have the current version of SMF. Do you agree?
>
>

Sat Jul 29, 2017 6:21 pm (PDT) . Posted by:

mokwit


VRX CATO CNSL PTC PFPT BLKB

sample tickers where used to get data for 559 and 3428 - from memory Option data was returned for some - I think PFPT and VRX but not all as data not always present.

Sat Jul 29, 2017 6:22 pm (PDT) . Posted by:

mokwit

Sample tickers where used to get data for 961 and 559

VRX CATO CNSL PTC PFPT BLKB


- got option data for some of them PFPT and VRX maybe but not all as dat not always present

Sat Jul 29, 2017 6:35 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

They're all working as expected here:

*Ticker* *559* *3428* *961*
VRX N/A -2409 -1410000
CATO 1.35 47.21 32880
CNSL 0.52 14.93 2960
PTC 1.2 -54.47 -39670
PFPT 0.59 -111.21 -92670
BLKB 2.13 41.52 46790
Source YahooAE Google YahooKS

​Which version of the add-in are you using? Are your element definitions
up-to-date?​

On Sat, Jul 29, 2017 at 6:22 PM, pmanz@
​...
wrote:

>
> Sample tickers where used to get data for 961 and 559
>
> VRX CATO CNSL PTC PFPT BLKB
>
> ​​
> - got option data for some of them PFPT and VRX maybe but not all as dat
> not always present
>
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)