[smf_addin] Digest Number 3329

EXCEL Stock Market Functions Add-in Group

4 Messages

Digest #3329

1a

Re: DailyFinance by lexstar

1b

Re: DailyFinance by lexstar

1c

Re: DailyFinance by "Randy Harmelink" rharmelink

2a

Re: Nutrition Data Page by kitiany

Messages

1a

Re: DailyFinance

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. :(

Reply to sender . Reply to group . Reply via Web Post . All Messages (8) . Top ^

1b

Re: DailyFinance

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?

Reply to sender . Reply to group . Reply via Web Post . All Messages (8) . Top ^

1c

Re: DailyFinance

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. :(
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (8) . Top ^

2a

Re: Nutrition Data Page

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

Reply to sender . Reply to group . Reply via Web Post . All Messages (3) . Top ^

For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Visit Your Group

• Privacy • Unsubscribe • Terms of Use