Kamis, 17 Agustus 2017

[smf_addin] Digest Number 4123

8 Messages

Digest #4123

Messages

Wed Aug 16, 2017 8:11 am (PDT) . Posted by:

jharlan

Thank you,

I ended up using


RCHGetTableCell("https://fintel.io/sm/us/"&A1,1,"Enterprise Value ($M)")



To resolve the issue.


-Jim

Wed Aug 16, 2017 6:34 pm (PDT) . Posted by:

sushiwaitress

Just FYI, it worked without changing the URL.
Adding the https: and changing "Prev Close" to "Previous Close" was all it took!

Thu Aug 17, 2017 7:38 am (PDT) . Posted by:

bob_15861586

The following use to work:


=smfGetOptionQuotes("QQQ 1/18 2019 $60 put","5",,"OX2")


I now get the message: Error


The version of SMF that I am using is:
Stock Market Functions add-in, Version 2.1.2017.05.03 (C:\SMF Add-In; Windows (32-bit) NT :.00; 15.0; ; ; 1)

Bob


Thu Aug 17, 2017 9:28 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

For me, it's alternating between returning the value and returning "Error".
I'm getting a lot of time-outs from the web site. One of the reasons I
don't use it any more -- it can be so slow. Even in my browser. You could
try using "B" instead of "OX2", and get the data from Barchart?

On Thu, Aug 17, 2017 at 7:38 AM, bob_15861586@
​...
wrote:

> The following use to work:
>
> =smfGetOptionQuotes("QQQ 1/18 2019 $60 put","5",,"OX2")
>
> I now get the message: Error
>
> The version of SMF that I am using is:
> Stock Market Functions add-in, Version 2.1.2017.05.03 (C:\SMF Add-In;
> Windows (32-bit) NT :.00; 15.0; ; ; 1)
>

Thu Aug 17, 2017 12:31 pm (PDT) . Posted by:

bob_15861586

Randy,

Using "B" instead of "OX2" solved my problem and I thank you.


Bob

Thu Aug 17, 2017 6:20 pm (PDT) . Posted by:

yolande_tulasse

I use Zacks Earnings Announcement data.

Seems there is a tiny error:

Elements 1301, 1302 & 1303 return the same values as 1306, 1307 & 1308. But they should not.

(note: values returned by 1306, 1307 & 1308 are correct. 1301, 1302 & 1303 are not).


Thanks Randy!
Keep up the awesome work




Thu Aug 17, 2017 6:25 pm (PDT) . Posted by:

yolande_tulasse

Man I shouldn't rush posting...

Sorry Randy. I just updated smf-elements-8.txt and everything works like a charm.


Thanks!
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Posting Komentar