3 Messages
Digest #3367
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
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
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(
I've done that. =RCHGetYahooQuotes(
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
>
>
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(
> data. I've done that. =RCHGetYahooQuotes(
> 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