Jumat, 23 Juni 2017

[smf_addin] Digest Number 4068

8 Messages

Digest #4068

Messages

Fri Jun 23, 2017 12:55 am (PDT) . Posted by:

philip_r_small

HI


Thanks very much Randy. That is now working. I copied from the e-mail and "reassembled" the code as it split it over 3 lines. This produced a value of 0. I then tried copying from this web page and that worked fine. In reassembling the code I had missed the space between the last quotation marks - something to watch out for in future!


I will look further in to how to do this, as it looks useful for other websites that I look at.




Fri Jun 23, 2017 8:20 am (PDT) . Posted by:

msimmsx

There are 2 small problems with the new smfGetYahooHistory:

1) when I use a date in the end_date parameter, a error is triggered....something like an overflow error....field too small for data....something to that effect.
I just eliminate the parm and use the default which is null. However, when I do that, see #2.


2) Yahoo's JSON-enabled service now returns the current day's quote in the history. I had to use logic to insure history is updated on to the prior day as the current day is not really "history".


Fri Jun 23, 2017 11:09 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Example of #1 please.

#2 is something Yahoo does on and off, which has created problems for
people. It doesn't have anything to do with the JSON extraction. If you
grab the CSV file using the button on their web page, you'll get the
current day's quote as well.

Technically, though, it is history -- at least 15 minutes old. :)

On Fri, Jun 23, 2017 at 8:20 AM, marksimms@
​...
wrote:

>
> There are 2 small problems with the new smfGetYahooHistory:
>
> 1) when I use a date in the end_date parameter, a error is
> triggered....something like an overflow error....field too small for
> data....something to that effect.
> I just eliminate the parm and use the default which is null. However, when
> I do that, see #2.
>
> 2) Yahoo's JSON-enabled service now returns the current day's quote in the
> history. I had to use logic to insure history is updated on to the prior
> day as the current day is not really "history".
>
>

Fri Jun 23, 2017 8:21 am (PDT) . Posted by:

msimmsx

SMF_ADDIN works with 64 bit office....to get it to work you just have to import the BAS files into your own XLAM or XLSM workbook...and recompile and set-up all of the references.

Fri Jun 23, 2017 10:19 am (PDT) . Posted by:

mitchellidr

I am a complete rookie with SMF functions, so any help is appreciated. What is the formula to return, in one cell, the historical closing price. I use to use: =RCHGetYahooHistory("JNJ",2009,10,21,2009,10,21,,"C",0).

Any help, I know it's a newbie type question. Thanks.

Fri Jun 23, 2017 10:51 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

If you want the unadjusted close for 10/21:

=RCHGetYahooHistory("JNJ",2009,10,21,2009,10,21,,"u",0)

Or, using the new function:

=smfGetYahooHistory("JNJ",,"10/21/2009",,"u",0)

Adjusted closes can be retrieved with:

=RCHGetYahooHistory("JNJ",2009,10,21,2009,10,21,,"c",0)
=smfGetYahooHistory("JNJ",,"10/21/2009",,"c",0)
=smfPricesByDates("JNJ","10/21/2009")

The last function can be passed multiple dates, and can have non-trading
day dates (close is carried forward).

On Fri, Jun 23, 2017 at 7:12 AM, ian.d.mitchell@
​...
wrote:

>
> I am a complete rookie with SMF functions, so any help is appreciated.
> What is the formula to return, in one cell, the historical closing price.
> I use to use: =RCHGetYahooHistory("JNJ",2009,10,21,2009,10,21,,"C",0).
>
> Any help, I know it's a newbie type question. Thanks.
>

Fri Jun 23, 2017 10:20 am (PDT) . Posted by:

wjqdds

Could you explain what you mean by next to each other and opened up the size or each array 8 columns by 35 rows? I also use Options Tracker from the Fool and have been trying to figure out the problem and came across this thread. I guess I will start to learn more about arrays as I can't picture what you mean and can't seem to change the orientation.

Thanks,
Bill





Fri Jun 23, 2017 10:55 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

They just meant each function invocation was array-entered over a range
that was 8 columns by 35 rows in size, and they arranged those ranges so
they were side by side instead of stacked on top of each other.

On Fri, Jun 23, 2017 at 9:59 AM, wjqdds@
​..
wrote:

>
> Could you explain what you mean by next to each other and opened up the
> size or each array 8 columns by 35 rows? I also use Options Tracker from
> the Fool and have been trying to figure out the problem and came across
> this thread. I guess I will start to learn more about arrays as I can't
> picture what you mean and can't seem to change the orientation.
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Diposting oleh EXCEL FEED LEARNING di 19.08

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)