Sabtu, 19 September 2015

[smf_addin] Digest Number 3516

8 Messages

Digest #3516

Messages

Fri Sep 18, 2015 12:48 pm (PDT) . Posted by:

jchealey66

Hi,


Does the smf addin work ok on windows 10?


Anybody having any issues or problems?


Do I need to change anything?



Would like to upgrade from windows 7 sometime soon.



Thanks,
Regards,
James

Fri Sep 18, 2015 4:07 pm (PDT) . Posted by:

lewglenn

Works just fine with Windows 10. You shouldn't have to change a thing.

Fri Sep 18, 2015 5:01 pm (PDT) . Posted by:

"Gus Vega" gavega

It works pretty well in my laptop.

Gavega

Sent from my iPhone

> On Sep 18, 2015, at 3:48 PM, jameshealey@tradernetwork.co.uk [smf_addin] <smf_addin@yahoogroups.com> wrote:
>
> Hi,
>
>
>
> Does the smf addin work ok on windows 10?
>
>
>
> Anybody having any issues or problems?
>
>
>
> Do I need to change anything?
>
>
>
> Would like to upgrade from windows 7 sometime soon.
>
>
>
> Thanks,
>
> Regards,
>
> James
>
>

Fri Sep 18, 2015 1:16 pm (PDT) . Posted by:

jchealey66

Hi Everyone,

Is it possible to use the smfPricesByDates function in one array formula to return data for multiple tickers at the same time?

{=smfPriceByDates(A2,B1:J1)} - single ticker with multiple dates formula.

I have tried adapting the above array formula to a multiple tickers formula (see below) where the ticker symbols are the rows A2 to A10 and the dates are the columns B1 to J1.

{=smfPriceByDates(A2:A10,B1:J1)}


I get a #VALUE! in the cells.


Any thoughts and help would be much appreciated,


Thanks,
James





Fri Sep 18, 2015 10:48 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

No. Only a single ticker per function invocation. Just copy the function to
as many tickers as needed.

On Fri, Sep 18, 2015 at 1:16 PM, jameshealey@...wrote:

>
> Is it possible to use the smfPricesByDates function in one array formula
> to return data for multiple tickers at the same time?
>
> {=smfPriceByDates(A2,B1:J1)} - single ticker with multiple dates formula.
>
> I have tried adapting the above array formula to a multiple tickers
> formula (see below) where the ticker symbols are the rows A2 to A10 and the
> dates are the columns B1 to J1.
>
> {=smfPriceByDates(A2:A10,B1:J1)}
>
> I get a #VALUE! in the cells.
>
> Any thoughts and help would be much appreciated,
>

Fri Sep 18, 2015 2:40 pm (PDT) . Posted by:

bob_15861586

Hi,


The following is not working for me:
=smfGetYahooOptionQuote("NSC", "C", DATE(2016,1,15),90,"a")
It returns an error. I updated my version of SMF to 2.1.2015.07.08 and the problem did not go away. I am now thinking the problem is Yahoo and if I just wait the problem will fix itself. Is that true?


Thanks
Bob

Fri Sep 18, 2015 10:54 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Looks to me like the IE page on Yahoo is not populating with options
prices...

On Fri, Sep 18, 2015 at 2:40 PM, bob_15861586@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> The following is not working for me:
>
> =smfGetYahooOptionQuote("NSC", "C", DATE(2016,1,15),90,"a")
>
> It returns an error. I updated my version of SMF to 2.1.2015.07.08 and
> the problem did not go away. I am now thinking the problem is Yahoo and
> if I just wait the problem will fix itself. Is that true?
>
>

Fri Sep 18, 2015 11:00 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Why would a $107 put be trading between $250 and $270?

On Thu, Sep 17, 2015 at 1:42 PM, tony estep tonyestep@...wrote:

>
> I posted earlier that I couldn't get anything except Error from my
> attempts to retrieve options prices. I tried various approaches, and
> finally the smfGetYahooOptionQuote did indeed return prices. I was
> overjoyed -- but it didn't last long, because the prices aren't correct.
> It's not that they're stale; it's as if they are coming from some
> completely wrong source.
>
> For example, the QQQ 107 Puts 10/16/15 are selling at this moment at 263.
> They have traded between 250 and 270 today. But my smf function returns a
> Last sale of 1.82. I have checked and re-checked my call to the function,
> and I think it's correct. Anybody have any words of wisdom??
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Diposting oleh EXCEL FEED LEARNING di 01.57

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)