2 Messages
Digest #3818
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!
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?
>
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:
Posting Komentar