Kamis, 26 Maret 2015

[smf_addin] Digest Number 3368

4 Messages

Digest #3368
1a
Re: Current Price by plconnell65
1b
Re: Current Price by "Randy Harmelink" rharmelink
2a
How Does This Work? by jterrenceho
2b
Re: How Does This Work? by "Randy Harmelink" rharmelink

Messages

Wed Mar 25, 2015 5:53 am (PDT) . Posted by:

plconnell65


Thanks so much for your help. Spreadsheet is a work in process and those
codes are great. My biggest concern when calling out for assistance is
that I have done my best due diligence to accomplish what I am trying to do
before I reach out to the site. So that brings up another question. I am
looking for codes within the RCH get element numbers() from the zip file. Where
do I find this default code list for RCHGetYahooQuotes(). My excel and SMF
are at the 101 level so this site will be a big help as I process all this
info. Thanks again for your help. Pat Connell


In a message dated 3/24/2015 3:31:35 P.M. Eastern Daylight Time,
smf_addin@yahoogroups.com writes:

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_
(mailto:plconnell@aol.com) [smf_addin] <_smf_addin@yahoogroups.com_
(mailto: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

Wed Mar 25, 2015 7:57 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

The function documentation is now on the web site:

http://ogres-crypt.com/SMF/Documentation/

Also check out the "Tips and FAQs" web page.

Unfortunately, the add-in is a constantly evolving thing, so I won't
guarantee everything is up-to-date. :)

On Wed, Mar 25, 2015 at 5:53 AM, plconnell@... wrote:

>
> Thanks so much for your help. Spreadsheet is a work in process and those
> codes are great. My biggest concern when calling out for assistance is
> that I have done my best due diligence to accomplish what I am trying to do
> before I reach out to the site. So that brings up another question. I am
> looking for codes within the RCH get element numbers() from the zip file.
> Where do I find this default code list for RCHGetYahooQuotes(). My excel
> and SMF are at the 101 level so this site will be a big help as I process
> all this info. Thanks again for your help. Pat Connell
>

Wed Mar 25, 2015 11:59 am (PDT) . Posted by:

jterrenceho

Randy,


First, I want to thank you for sharing your work with all of us.


I am very interested in how you are able to download the data points from the different sources. I am asking this because I am trying to develop an Excel application to tag data in XBRL (Extensible Business Reporting Language). What you are doing would be very helpful towards the development of the XBRL application.


Best Regard,


John




Wed Mar 25, 2015 12:33 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

It's mostly a matter of which functions to use. For XBRL, I would suspect
the best option would be smfGetTagContent(), with RCHGetWebData() as a last
resort.

On Wed, Mar 25, 2015 at 10:33 AM, jterrenceho@... wrote:

>
> I am very interested in how you are able to download the data points from
> the different sources. I am asking this because I am trying to develop an
> Excel application to tag data in XBRL (Extensible Business Reporting
> Language). What you are doing would be very helpful towards the development
> of the XBRL application.
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar