3 Messages
Digest #3737
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)
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
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)
>
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
>
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)
>>
>
>
>
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
>>
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar