Rabu, 18 Februari 2015

[smf_addin] Digest Number 3329

4 Messages

Digest #3329
1a
1b
1c
Re: DailyFinance by "Randy Harmelink" rharmelink

Messages

Tue Feb 17, 2015 6:33 pm (PST) . Posted by:

lexstar

In other words, if I have say 10 funds and I want to pull the CLOSE for a specific date (ie 1/2/2015):

FUND................... DATE......................CLOSE 1
2
3
4
5
6
7
8
9
10


Any ideas? I've tried various ways but have no success. :(

Tue Feb 17, 2015 6:46 pm (PST) . Posted by:

lexstar

Can the Start Date & End Date refer to a cell containing a start date & end date? Or, must those dates be static within the formula?

Wed Feb 18, 2015 12:11 am (PST) . Posted by:

"Randy Harmelink" rharmelink

Try something like:

=RCHGetTableCell("
http://www.motleyfool.idmanagedsolutions.com/stocks/historical_quotes.idms?START_DATE=
"&TEXT(C4-5,"yyyy-mm-dd")&"&END_DATE="&TEXT(C4+5,"yyyy-mm-dd")&"&CODE_MARKET=US,@US&SYMBOL_US="&B4&"&BLOCKSIZE=100&OFFSET=0",4,TEXT(C4,"mm/dd/yyyy"))

On Tue, Feb 17, 2015 at 7:33 PM, lexstar@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
>
> In other words, if I have say 10 funds and I want to pull the CLOSE for a
> specific date (ie 1/2/2015):
>
> FUND................... DATE......................CLOSE
> 1
> 2
> 3
> 4
> 5
> 6
> 7
> 8
> 9
> 10
>
> Any ideas? I've tried various ways but have no success. :(
>

Tue Feb 17, 2015 7:40 pm (PST) . Posted by:

kitiany


I found it. They use a cross reference table. For example "Folate" is actually "nutrient_112" at the bottom of the source code. But the output value is calculated based on the entered "Serving Size".
Wonderful. Found another use for your add-ins.
Kit
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar