6 Messages
Digest #3567
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
The problem is that the first column is correct but the rest are blank.
=smfGetOptionQuotes
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
mm/d yyyy
(which works fine in a non-array calculation).
---In smf_addin@yahoogroups.com, <peterscottcook@
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
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")
>
>
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
> put","
>
>
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!
I have a list setup using both individual stocks "=RCHGetYahooQ
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.
>
>
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 "=RCHGetYahooQ
> "l1"
> 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:
Posting Komentar