Minggu, 22 Juli 2012

[smf_addin] Digest Number 2286

7 New Messages

Digest #2286

Messages

Sat Jul 21, 2012 7:22 am (PDT) . Posted by:

"jhfrazer@ymail.com" jhfrazer@ymail.com

Good morning,

How might I output RCHGetYahooHistory data to Rows versus Columns? Basically what I need are weekly closes presented left to right as opposed to top to bottom.

If this topis has been dealt with in previous posts I appologise for searching the Group incorrectly.

Thank you for your skill and effort.

John

Sat Jul 21, 2012 10:22 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

You need to use EXCEL's transpose function on the returned data, but you
also need to use the pDim1 and pDim2 parameters of RCHGetYahooHistory() to
tell the function what size array to return (it's otherwise based on the
size of the worksheet range the function is array-entered over). For an
example, see:

http://finance.groups.yahoo.com/group/smf_addin/message/13814

On Sat, Jul 21, 2012 at 7:22 AM, jhfrazer@ymail.com <jhfrazer@ymail.com>wrote:

>
> How might I output RCHGetYahooHistory data to Rows versus Columns?
> Basically what I need are weekly closes presented left to right as opposed
> to top to bottom.
>
> If this topis has been dealt with in previous posts I appologise for
> searching the Group incorrectly.
>

Sat Jul 21, 2012 11:48 am (PDT) . Posted by:

"jhfrazer@ymail.com" jhfrazer@ymail.com

Randy,

Clearly I must be doing something incorrectly. Let me therefore ask a question or two. When using the Transpose Function how should I be hightlighting cells? If I simply placce the formula in an individual cell I only get a single result as opposed to the 7,1 array which I believe I am to get.

If on the other hand I highlight an oversize row of cells and enter the formula and use shift-Crtl-Enter, I get the seven prices but then a collection of #N/A cells fill the remaining cells in the highlighted row of cells.

Can you help me with the differene between the "C" and "A" data types and the "0 or 1" switch for Adjusted or Unadjusted Data.

Finially regarding the pDim1 and pDim2 parameters. I do not find them anywhere in the docs for RCHGetYahooHistory. Where should I be looking for those?

Thank you for your assistance.

John

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> You need to use EXCEL's transpose function on the returned data, but you
> also need to use the pDim1 and pDim2 parameters of RCHGetYahooHistory() to
> tell the function what size array to return (it's otherwise based on the
> size of the worksheet range the function is array-entered over). For an
> example, see:
>
> http://finance.groups.yahoo.com/group/smf_addin/message/13814
>
> On Sat, Jul 21, 2012 at 7:22 AM, jhfrazer@... <jhfrazer@...>wrote:
>
> >
> > How might I output RCHGetYahooHistory data to Rows versus Columns?
> > Basically what I need are weekly closes presented left to right as opposed
> > to top to bottom.
> >
> > If this topis has been dealt with in previous posts I appologise for
> > searching the Group incorrectly.
> >
>

Sat Jul 21, 2012 12:23 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

On Sat, Jul 21, 2012 at 11:48 AM, jhfrazer@ymail.com <jhfrazer@ymail.com>wrote:

>
> Clearly I must be doing something incorrectly. Let me therefore ask a
> question or two. When using the Transpose Function how should I be
> hightlighting cells? If I simply placce the formula in an individual cell
> I only get a single result as opposed to the 7,1 array which I believe I am
> to get.
>

Since you want the output in a row, it would be a 7-column by 1-row range.

If on the other hand I highlight an oversize row of cells and enter the
> formula and use shift-Crtl-Enter, I get the seven prices but then a
> collection of #N/A cells fill the remaining cells in the highlighted row of
> cells.
>

Yup. Because the "7" as pDim1 says you only want 7 rows of output, which
becomes 7 columns of output after the transpose...

> Can you help me with the differene between the "C" and "A" data types and
> the "0 or 1" switch for Adjusted or Unadjusted Data.
>

"C" with "1" should give you the same as "A". The "0 or 1" switch doesn't
affect the "A" output.

Finially regarding the pDim1 and pDim2 parameters. I do not find them
> anywhere in the docs for RCHGetYahooHistory. Where should I be looking for
> those?
>

They're undocumented. I initially added them so I could get data out for
VBA functions. Since they are for more advanced usage, I didn't really want
to "advertise" them. Typically, I've used them as keyword parameters in
VBA, not as positional ones, with the idea that their position might change
-- which would cause problems if people used them in workbooks. That
concept seems to be out the window now.

Sat Jul 21, 2012 10:16 am (PDT) . Posted by:

"s1238085" s1238085

Hello. I'm trying to retrieve data from this
site:http://finance.themarker.com/f/quoten.jhtml?navBar=comp&sType=ta&se\
cCode=373019

<http://finance.themarker.com/f/quoten.jhtml?navBar=comp&sType=ta&secCod\
e=373019
>
with function RCHGetTableCell and until now with no success...The number
in the end of this link is number of specific stock on TASE.This is
syntacsys I have used in Excel:
=RCHGetTableCell("http://finance.themarker.com/f/quoten.jhtml?navBar=com\
p&sType=ta&secCode=
"&A2,1,">תנוע×"
מינימלית",,,,,)where: A2 = 373019
Maybe someone can help me make it work? Thanks.

Sat Jul 21, 2012 10:27 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

I think the problem is that the Hebrew characters you see are rendered by
the browser (or source code viewer) to represent what is in the source
code. What the actual values are may be different, or may be rendered by
EXCEL differently...

For example, if I search on the string you quote below, I don't find it in
the source code of the web page. But all that means is that my viewer of
the source code may be rendering different viewable characters...

I'm not sure what to use as search strings in that case...?

On Sat, Jul 21, 2012 at 6:56 AM, s1238085 <1238085@gmail.com> wrote:

> I'm trying to retrieve data from this site:
>
> http://finance.themarker.com/f/quoten.jhtml?navBar=comp&sType=ta&secCode=373019
>
> with function RCHGetTableCell and until now with no success...
> The number in the end of this link is number of specific stock on TASE.
> This is syntacsys I have used in Excel:
> =RCHGetTableCell("
> http://finance.themarker.com/f/quoten.jhtml?navBar=comp&sType=ta&secCode="&A2,1,">×ª× Ã—â€¢Ã—Â¢Ã—"
> מי× ימ×Å"ית",,,,,)
> where: A2 = 373019
>
> Maybe someone can help me make it work? Thanks.
>

Sat Jul 21, 2012 10:19 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

There's no reason to do that with the smfGetAdvFNElement(). The add-in only
retrieves the web page once, saves it, and then extracts the data from the
saved web pages. So you can extract as many data elements from the web page
as you want without using another Internet access.

The reason the array-entered functions are done on the RCHGetYahooHistory()
and RCHGetYahooQuotes() functions is the data is returned in a CSV file
which is a customized data request that has all of the data that needs to
be parsed as a CSV file.

On Sat, Jul 21, 2012 at 1:00 AM, Koushik Krishnan <notkoushik@yahoo.com>wrote:

>
> Does smfGetADVFNElement support single web query for a group of elements
> -just like how RCHGetYahooHistory does it? I am trying to avoid multiple
> queries to access the data that is mostly available in the same table.
>
> For instance:
> =smfGetAdvFNElement("NYSE:SHW","A",2,"Total Revenue") returns 7979.7
>
> Can I use the same routine like this -
> {=smfGetAdvFNElement("NYSE:SHW","A",2,3,"Total Revenue","cost of sales")}
> to return 7776.4 4120
> 7094.2 3660.2
>
> It looks like smfGetAdvFNElement will need arguements like
> RCGGetYahooHistory. Or maybe I have to use RCHGetHTMLTable/RCHGetTableCell
> - which I am not too familiar with. It would be great if you can give me an
> example.
>

Tidak ada komentar:

Posting Komentar