Kamis, 13 Oktober 2016

[smf_addin] Digest Number 3818

2 Messages

Digest #3818
1b
Re: Speeding up yahoo data retrieval by "Randy Harmelink" rharmelink

Messages

Wed Oct 12, 2016 4:44 pm (PDT) . Posted by:

beatnut8827

Hi Randy
I will give the array idea a go. Is there a way of using the highbetween and the history functions in an array e.g. with columns Ticker, StartDate, Endate, Price?
Thanks
Neil

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

You might be able to do the array-entered retrieval in one worksheet, and then use lookup formulas into that worksheet with your other worksheets that actually use (or present) the data in a different configuration..


It has helped some people in the past when Yahoo quotes got funky, such as having 92 functions work great, while 8 return an error of some type. If you use the array-entered, you's still have an 8% failure rate, but it would be all or nothing. Otherwise, recalculating might just have a different 8 not work correctly.


On Mon, Oct 10, 2016 at 8:22 PM, neil@... mailto:neil@... [smf_addin] <smf_addin@yahoogroups.com mailto:smf_addin@yahoogroups.com> wrote:

Thanks. It's a bit of a mixtyre but mainly quotes. The array option won't work for my implementation. So will just have to be patient!








Wed Oct 12, 2016 6:25 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Sorry, no. That
​needs the historical quotes CSV file. That's an extraction that needs to
be done ticker by ticker.

On Wed, Oct 12, 2016 at 4:44 PM, neil@theatreofimage.com.au [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> I will give the array idea a go. Is there a way of using the highbetween
> and the history functions in an array e.g. with columns Ticker, StartDate,
> Endate, Price?
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar