Selasa, 24 November 2015

[smf_addin] Digest Number 3567

6 Messages

Digest #3567
1a
array problem by pete_cook2001
1b
Re: array problem by pete_cook2001
1c
Re: array problem by "Randy Harmelink" rharmelink
2b
Re: Not pulling in stock data by "Randy Harmelink" rharmelink
3
SpreadsheetGear - anyone here using it? by "Kermit W. Prather" kermitpra

Messages

Mon Nov 23, 2015 9:08 am (PST) . Posted by:

pete_cook2001

I must be having a brain fart and I'm hoping someone can spot it. I am using this array formula to create a 15Rx27C table of bid prices for puts across multiple dates and strike prices. Expiration dates are contained in the putstrikedate table and strike prices are contained in the putstrikes table.


The problem is that the first column is correct but the rest are blank.



=smfGetOptionQuotes(ticker&" "&putstrikedate&" $"&tputstrikes&" put","b",,"OX2")



Many thanks!


Peter

Mon Nov 23, 2015 10:01 am (PST) . Posted by:

pete_cook2001

I should add that putstrikedate is of the form

mm/d yyyy

(which works fine in a non-array calculation).

---In smf_addin@yahoogroups.com, <peterscottcook@...> wrote :

I must be having a brain fart and I'm hoping someone can spot it. I am using this array formula to create a 15Rx27C table of bid prices for puts across multiple dates and strike prices. Expiration dates are contained in the putstrikedate table and strike prices are contained in the putstrikes table.


The problem is that the first column is correct but the rest are blank.



=smfGetOptionQuotes(ticker&" "&putstrikedate&" $"&tputstrikes&" put","b",,"OX2")



Many thanks!


Peter



Mon Nov 23, 2015 10:50 am (PST) . Posted by:

"Randy Harmelink" rharmelink

That formula would only work for a single strike date and a single strike
price. "putstrikedate" and "tputstrikes" cannot be ranges.

On Mon, Nov 23, 2015 at 10:08 AM, peterscottcook@gmail.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> I must be having a brain fart and I'm hoping someone can spot it. I am
> using this array formula to create a 15Rx27C table of bid prices for puts
> across multiple dates and strike prices. Expiration dates are contained in
> the putstrikedate table and strike prices are contained in the putstrikes
> table.
>
> The problem is that the first column is correct but the rest are blank.
>
> =smfGetOptionQuotes(ticker&" "&putstrikedate&" $"&tputstrikes&"
> put","b",,"OX2")
>
>

Mon Nov 23, 2015 10:29 am (PST) . Posted by:

mikewa_68

Something must have changed as things are inconsistent since late last week.
I have a list setup using both individual stocks "=RCHGetYahooQuotes(C2, "l1", ,"NOW()",,)" and arrays.
They are inconsistent in their return, sometimes working, and sometimes returning "Error".

New template loaded and, as stated, it works for a while and then stops.
The arrays setup fail more chronically than the individual stocks, but I suspect thats due to one of the stocks in the array failing causing the whole return to choke.

RCHGetElementNumber seems to be working consistently, so may try and switch over to that API.

If anyone has any insight on whether this is a Yahoo issue or if there may be a different cause.


Thanks!

Mon Nov 23, 2015 10:52 am (PST) . Posted by:

"Randy Harmelink" rharmelink

If RCHGetYahooQuotes() returns "Error", my first inclination would be a
communication error of some type with Yahoo.

On Mon, Nov 23, 2015 at 9:41 AM, mikewa_68@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Something must have changed as things are inconsistent since late last
> week.
>
> I have a list setup using both individual stocks "=RCHGetYahooQuotes(C2,
> "l1", ,"NOW()",,)" and arrays.
> They are inconsistent in their return, sometimes working, and sometimes
> returning "Error".
>
> New template loaded and, as stated, it works for a while and then stops.
> The arrays setup fail more chronically than the individual stocks, but I
> suspect thats due to one of the stocks in the array failing causing the
> whole return to choke.
>
> RCHGetElementNumber seems to be working consistently, so may try and
> switch over to that API.
>
> If anyone has any insight on whether this is a Yahoo issue or if there may
> be a different cause.
>
>

Mon Nov 23, 2015 11:33 am (PST) . Posted by:

"Kermit W. Prather" kermitpra


I was wondering if anyone in this group was using or has tried the
SpreadsheetGear

Kermit

<http://apps.developermedia.com/click/167923?_z=12201511236522070> Need
Lightning-Fast Excel Calculations?
Use SpreadsheetGear to evaluate complex Excel-based models with the fastest
and
most complete Excel-compatible calculation engine available.
Includes 398 Excel-compatible functions, multithreaded recalc, array formula
support and more.
<http://apps.developermedia.com/click/167922?_z=12201511236522070> Try it
now!
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar