Selasa, 05 Juli 2016

[smf_addin] Digest Number 3737

3 Messages

Digest #3737
1.1
RCHGetYahooHistory by jpaulaustin
1.2
Re: RCHGetYahooHistory by "Randy Harmelink" rharmelink
1.3
Re: RCHGetYahooHistory by "Paul Austin" jpaulaustin

Messages

Mon Jul 4, 2016 7:45 am (PDT) . Posted by:

jpaulaustin

Randy,
I just discovered your Add-In. The following entry only sets one cel to "Adjusted Price." I would have expected it to download all the month-end adjusted prices between the dates. I tried to download the template and it doesn't seem to be comparable to what I'm trying to do. If you could just help me get started, I'm usually pretty self-sufficient thereafter. Thanks for making such great tools! Paul

=RCHGetYahooHistory("ibm",2007,12,31,2016,6,30,"m","A",1,1,1)


Mon Jul 4, 2016 7:50 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

I suspect you just entered the formula into a single cell. You need to
array-enter it over a range. A function can only return data into cells
that it has explicitly been given access to.

On Mon, Jul 4, 2016 at 6:45 AM, paul@austinco.net [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> I just discovered your Add-In. The following entry only sets one cel to
> "Adjusted Price." I would have expected it to download all the month-end
> adjusted prices between the dates. I tried to download the template and it
> doesn't seem to be comparable to what I'm trying to do. If you could just
> help me get started, I'm usually pretty self-sufficient thereafter. Thanks
> for making such great tools! Paul
>
> =RCHGetYahooHistory("ibm",2007,12,31,2016,6,30,"m","A",1,1,1)
>

Mon Jul 4, 2016 2:03 pm (PDT) . Posted by:

"Paul Austin" jpaulaustin

That does the trick! Thank you again for making such great tools available.

On Jul 4, 2016 10:50 AM, "Randy Harmelink rharmelink@gmail.com [smf_addin]"
<smf_addin@yahoogroups.com> wrote:

>
>
> I suspect you just entered the formula into a single cell. You need to
> array-enter it over a range. A function can only return data into cells
> that it has explicitly been given access to.
>
> On Mon, Jul 4, 2016 at 6:45 AM, paul@austinco.net [smf_addin] <
> smf_addin@yahoogroups.com> wrote:
>
>>
>> I just discovered your Add-In. The following entry only sets one cel to
>> "Adjusted Price." I would have expected it to download all the month-end
>> adjusted prices between the dates. I tried to download the template and it
>> doesn't seem to be comparable to what I'm trying to do. If you could just
>> help me get started, I'm usually pretty self-sufficient thereafter. Thanks
>> for making such great tools! Paul
>>
>> =RCHGetYahooHistory("ibm",2007,12,31,2016,6,30,"m","A",1,1,1)
>>
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar