Rabu, 25 Maret 2015

[smf_addin] Digest Number 3367

3 Messages

Digest #3367
2a
Current Price by plconnell65
2b
Re: Current Price by "Randy Harmelink" rharmelink

Messages

Tue Mar 24, 2015 9:34 am (PDT) . Posted by:

spamfiel

Public bond quotes are available here:
http://finra-markets.morningstar.com/BondCenter/BondDetail.jsp?ticker=C435795&symbol=SOGC3670900 http://finra-markets.morningstar.com/BondCenter/BondDetail.jsp?ticker=C435795&symbol=SOGC3670900

Tue Mar 24, 2015 12:25 pm (PDT) . Posted by:

plconnell65

I am a newbee to the group. I am also a newbee to SMF_addin. Trying to put
a spreadsheet together and am having trouble finding the current price
associated with my stock symbol. Went through all the elements of yahoo and
others in the zip file with no luck. Found a message from back in 2011 that
says You should use the RCHGetYahooQuotes() function for current quotes data.
I've done that. =RCHGetYahooQuotes(A2)
No Success that pulls up the symbol JNJ which is in my cell A2. Any help I
could use Thanks Pat Connell

Tue Mar 24, 2015 12:31 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

The default "code list" for RCHGetYahooQuotes() is "sl1d1t1c1ohgv", which
would return ticker symbol, last price, date and time of last price, change
for the date, opening/high/low price of the day, and volume for the day. If
you just entered it into a single cell, you'd just get the first item in
that list -- symbol. You need to array-enter it over a multi-column range
to get all of the items.

To just get price in a single cell, you'd need a single Yahoo code:

=RCHGetYahooQuotes(A2,"l1")

On Tue, Mar 24, 2015 at 10:33 AM, plconnell@aol.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> I am a newbee to the group. I am also a newbee to SMF_addin. Trying to
> put a spreadsheet together and am having trouble finding the current price
> associated with my stock symbol. Went through all the elements of yahoo and
> others in the zip file with no luck. Found a message from back in 2011 that
> says You should use the RCHGetYahooQuotes() function for current quotes
> data. I've done that. =RCHGetYahooQuotes(A2)
> No Success that pulls up the symbol JNJ which is in my cell A2. Any help I
> could use Thanks Pat Connell
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Posting Komentar