Messages In This Digest (2 Messages)
- 1a.
- Re: getyahoohistory From: chj.2010
- 1b.
- Re: getyahoohistory From: Randy Harmelink
Messages
- 1a.
-
Re: getyahoohistory
Posted by: "chj.2010" chasjohn02@yahoo.com chj.2010
Sat Jul 9, 2011 7:26 am (PDT)
I created a Named Range: Tick and assigned a cell to the range. If I use the named range I get a blank screen. If I copy the cell contents and paste them into the formula, I get data.
getyahoohistory(Tick) - Doesn't work Tick = $E$5 = "RDN"
getyahoohistory("RDN")- Works
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Sure. It's a user-defined function, so it can be used pretty much the same
> way as a normal function -- literal, cell reference, or named range cell.
>
> On Fri, Jul 8, 2011 at 5:38 PM, chj.2010 <chasjohn02@...> wrote:
>
> > Looked through some of the posts and couldn't find anything germane to my
> > question, which is:
> > Is it possible to use a Named Range in lieu of an actual stock symbol?
> >
> > my Named Range would be a cell containing stock symbol.
> >
> > e.g
> > getyahoohistory(Symbol) vs getyahoohistory( "IBM")
> >
>
- 1b.
-
Re: getyahoohistory
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sat Jul 9, 2011 8:49 am (PDT)
Works fine here. Can you upload the file (or attach one to a message) so I
can look at it?
Almost all of my templates use ranged names. Shouldn't be a factor at all.
On Sat, Jul 9, 2011 at 7:25 AM, chj.2010 <chasjohn02@yahoo.com > wrote:
>
> I created a Named Range: Tick and assigned a cell to the range. If I use
> the named range I get a blank screen. If I copy the cell contents and paste
> them into the formula, I get data.
>
> getyahoohistory(Tick) - Doesn't work Tick = $E$5 = "RDN"
> getyahoohistory("RDN")- Works
>
Need to Reply?
Click one of the "Reply" links to respond to a specific message in the Daily Digest.
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Individual | Switch format to Traditional
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe
Tidak ada komentar:
Posting Komentar