Messages In This Digest (4 Messages)
- 1a.
- GetOption function From: rrricks
- 1b.
- Re: GetOption function From: Randy Harmelink
- 2a.
- Help for newbie !! From: sohalbiest
- 2b.
- Re: Help for newbie !! From: Randy Harmelink
Messages
- 1a.
-
GetOption function
Posted by: "rrricks" rrricks@yahoo.com rrricks
Thu Dec 8, 2011 4:50 pm (PST)
Where do I get the SMFGetOption function?
- 1b.
-
Re: GetOption function
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Thu Dec 8, 2011 5:59 pm (PST)
The new option functions are in the normal 2.1.2010.08.02 version of the
add-in. However, there are also changes and newer option functions in the
2.1.2011.12.01 beta version of the add-in from the "Works in Progress"
folder of the files area of the group.
On Thu, Dec 8, 2011 at 4:20 PM, rrricks <rrricks@yahoo.com > wrote:
> Where do I get the SMFGetOption function?
>
- 2a.
-
Help for newbie !!
Posted by: "sohalbiest" john_koufos@yahoo.com sohalbiest
Thu Dec 8, 2011 11:40 pm (PST)
Hello to everyone!!
I ve Just discovered the smf addin and I am pretty excited !
I am interested in downloading specific data from yahoo.finance. for example quarterly eps .
What is the exact cintax for doing that using rch.get.element.number ?
is it something like ...
='C:\Program Files\SMF Add-In\RCH_Stock_Market_Functions .xla'!RCHGetElem entNumber( Ticker; 5316)
Do I have to do anything else or I just drop that to the excel cell ?
Can that be updated by using web data refresh button ?
Thank you !
John
- 2b.
-
Re: Help for newbie !!
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Thu Dec 8, 2011 11:47 pm (PST)
On Fri, Dec 9, 2011 at 12:34 AM, sohalbiest <john_koufos@yahoo.com > wrote:
>
> I am interested in downloading specific data from yahoo.finance. for
> example quarterly eps .
>
> What is the exact cintax for doing that using rch.get.element.number ?
>
> is it something like ...
>
> ='C:\Program Files\SMF
> Add-In\RCH_Stock_Market_Functions .xla'!RCHGetElem entNumber( Ticker; 5316)
>
See the documentation for the function in the "Documentation" folder of the
files area. You DON'T want the file path on the front of the function --
check out the "Location Error" item in the "Links" area of the group, where
there are tips and FAQs related to the add-in. If you have a file path in
front of the function, it means EXCEL was not able to resolve the link, so
you need to do it manually.
So it would just be:
=RCHGetElementNumber(Ticker; 5316)
...provided you have a cell named "Ticker" in the workbook.
> Do I have to do anything else or I just drop that to the excel cell ?
>
For the most part, the add-in is user-defined functions. Some need to be
array-entered, if they can return a range of data -- how to do that is
described in the documentation of those functions.
> Can that be updated by using web data refresh button ?
>
No. They are functions, not web queries. In general, the best way to update
the add-in functions is to use the smfForceRecalculation macro -- info on
it can be found in the "Links" area of the group.
Need to Reply?
Click one of the "Reply" links to respond to a specific message in the Daily Digest.
MARKETPLACE
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