Senin, 08 Oktober 2012

[smf_addin] Digest Number 2367

15 New Messages

Digest #2367
1a
Re: Text Extraction by "Randy H" rharmelink
1b
Re: Text Extraction by "Randy H" rharmelink
1c
Retrieve historical quote by "Wayne Lewis" wlewis33592
1d
Re: Retrieve historical quote by "Randy Harmelink" rharmelink
2a
Re: Google Docs Integration by "westes2" westes2
2b
Re: Google Docs Integration by "Randy Harmelink" rharmelink
4b
6
1000 page web limit by "codyklein" codyklein
7
SMF Add In Formula Errors by "Chris Ball" peggysue281

Messages

Mon Oct 8, 2012 3:42 am (PDT) . Posted by:

"Randy H" rharmelink

Here's what I get:

Applies to Description Footnotes All Industries Arithmetic
average of the last five years of Common Equity % Total Assets
That's all the content *I* see in the table.

On Mon, Oct 8, 2012 at 2:20 AM, back <backmehl@yahoo.de
<mailto:backmehl@yahoo.de> > wrote:

yes the formula works, but i can't get the table-content !!!

Regards
--- In smf_addin@yahoogroups.com <mailto:smf_addin@yahoogroups.com> ,
Randy Harmelink <rharmelink@...> wrote:
>
> That formula works fine for me.
>
> On Thu, Sep 27, 2012 at 6:53 AM, back <backmehl@...> wrote:
>
> >
> > i tried:
> >
> > =RCHGetHTMLTable("
> >
http://product.datastream.com/navigator/HelpFiles/DatatypeDefinitions/en\
/0/WC08245.htm
<http://product.datastream.com/navigator/HelpFiles/DatatypeDefinitions/e\
n/0/WC08245.htm> ";
> > "Applies To";-1;"";1)
> >
> > ... but it doesn't work ...

Mon Oct 8, 2012 4:25 am (PDT) . Posted by:

"Randy H" rharmelink

Sounds like you are entering the formula into a single cell instead of
array-entering it over a range...

On Mon, Oct 8, 2012 at 3:59 AM, back <backmehl@yahoo.de
<mailto:backmehl@yahoo.de> > wrote:

> Hi,
>
> this is strange ... i get only "Applies To" (???)

Mon Oct 8, 2012 8:34 am (PDT) . Posted by:

"Wayne Lewis" wlewis33592

I'm trying to bring into Excel a single historical closing price for one
stock symbol on one day & can't make any of the functions in the Yahoo
SMF group work properly.
I'm looking for a function like: =Function(stock symbol, date). Can
someone help?

--

Mon Oct 8, 2012 8:41 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

You can use either RCHGetYahooHistory() or smfPricesByDates(). For example,
either of these would retrieve the adjusted closing price from last Monday:

=RCHGetYahooHistory("MMM",2012,8,1,2012,8,1,,"A",0)
=smfPricesByDates("MMM","8/1/2012")

On Mon, Oct 8, 2012 at 7:03 AM, Wayne Lewis <wlewis@la-fl.com> wrote:

> I'm trying to bring into Excel a single historical closing price for one
> stock symbol on one day & can't make any of the functions in the Yahoo
> SMF group work properly.
> I'm looking for a function like: =Function(stock symbol, date). Can
> someone help?
>

Mon Oct 8, 2012 3:48 am (PDT) . Posted by:

"westes2" westes2

The GoogleFinance() function is very incomplete....

To work out the parsing details of the raw HTML pages seems like way too much work.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Since Google doesn't utilize VBA, it wouldn't be possible.
>
> However, Google has its own version of such extractions, using the
> GoogleFinance(), ImportData(), ImportHTML(), and ImportXML() functions.
>
> On Sun, Oct 7, 2012 at 10:24 PM, westes2 <westes@...> wrote:
>
> > I don't suppose the author would consider implementing these functions for
> > use inside of Google Spreadsheets? It would be enormously powerful to
> > build financial models that retrieved updated data and could be shared with
> > the world through the cloud.
> >
>

Mon Oct 8, 2012 4:11 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Especially since here they can just ask Randy what the parsing details are.
:)

On Mon, Oct 8, 2012 at 3:48 AM, westes2 <westes@earthbroadcast.com> wrote:

> The GoogleFinance() function is very incomplete....
>
> To work out the parsing details of the raw HTML pages seems like way too
> much work.
>

Mon Oct 8, 2012 3:50 am (PDT) . Posted by:

"westes2" westes2

Will your functions work in a cloud environment in something like Windows SkyDrive?

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Check out the documentation for the RCHGetTableCell() function in the
> DOCUMENTATION folder in the FILES area of the group. For example, to get
> the most recent # of preferred shares for WFC from Yahoo:
>
> =RCHGetTableCell("http://finance.yahoo.com/q/bs?s=WFC",1,">Preferred Stock")
>
> On Sun, Oct 7, 2012 at 10:22 PM, westes2 <westes@...> wrote:
>
> > Is there any documentation for how you can retrieve an arbitrary line on
> > the balance sheet or income statement on a particular data source web site?
> >
> > For example, I would like to retrieve tangible book value from Yahoo.
> >
> > Or from the Yahoo balance sheet I would like to recover the preferred
> > shares entry under the Equity section of the balance sheet.
> >
>

Mon Oct 8, 2012 4:12 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Doubtful. It uses some Windows reference libraries.

You can't install EXCEL there, can you?

On Mon, Oct 8, 2012 at 3:50 AM, westes2 <westes@earthbroadcast.com> wrote:

> Will your functions work in a cloud environment in something like Windows
> SkyDrive?
>

Mon Oct 8, 2012 5:12 am (PDT) . Posted by:

"smithjhhic" smithjhhic

Randy,
Yes, thank you very much. Is there a method to strip the space and K at the end so value is numeric only?
Jeff

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Is this all you want:
>
> =RCHGetTableCell("http://www.marketvolume.com/stocks/moneyflow.asp?s=AAPL
> ",8,">Change",,,,1)
> =RCHGetTableCell("http://www.marketvolume.com/stocks/moneyflow.asp?s=AAPL
> ",5,">Change",,,,1)
>
> On Sun, Oct 7, 2012 at 11:46 AM, smithjhhic <smithjhhic@...> wrote:
>
> > I am not very experienced and having difficulty implementing "bushpilote"
> > suggestion. I am trying to return "14-day SBV" and "14-day Volume MA" for
> > the most recent date. Do I need to bring back the entire table to obtain
> > the data for those two cells for the most recent date? Is there a formula I
> > can enter to obtain just those two cells for a symbol in C3? Any help would
> > be appreciated.
> >
>

Mon Oct 8, 2012 6:16 am (PDT) . Posted by:

"bushpilote@yahoo.ca" bushpilote

Welcome back Randy.

Can you help me understand how you came up with the number of non-blank positions in the formula (ie why [...">Change",1] returns an error and [...">Change",,,,1] gets you the data)?

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Is this all you want:
>
> =RCHGetTableCell("http://www.marketvolume.com/stocks/moneyflow.asp?s=AAPL
> ",8,">Change",,,,1)
> =RCHGetTableCell("http://www.marketvolume.com/stocks/moneyflow.asp?s=AAPL
> ",5,">Change",,,,1)
>
> On Sun, Oct 7, 2012 at 11:46 AM, smithjhhic <smithjhhic@...> wrote:
>
> > I am not very experienced and having difficulty implementing "bushpilote"
> > suggestion. I am trying to return "14-day SBV" and "14-day Volume MA" for
> > the most recent date. Do I need to bring back the entire table to obtain
> > the data for those two cells for the most recent date? Is there a formula I
> > can enter to obtain just those two cells for a symbol in C3? Any help would
> > be appreciated.
> >
>

Mon Oct 8, 2012 8:36 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

You could use EXCEL's SUBSTITUTE() function to remove the two bytes.

On Mon, Oct 8, 2012 at 5:12 AM, smithjhhic <smithjhhic@yahoo.com> wrote:

> Is there a method to strip the space and K at the end so value is numeric
> only?
>

Mon Oct 8, 2012 8:38 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

Because the "1" is a particular parameter. the empty positions are
place-holders for parameters I'm not using.

[...">Change",1] says to search for ">Change" and then search for 1.

[...">Change",,,,1] says to search for ">Change" and then skip to the next
table row.

On Mon, Oct 8, 2012 at 6:16 AM, <bushpilote@yahoo.ca> wrote:

>
> Can you help me understand how you came up with the number of non-blank
> positions in the formula (ie why [...">Change",1] returns an error and
> [...">Change",,,,1] gets you the data)?
>

Mon Oct 8, 2012 8:33 am (PDT) . Posted by:

"freebelvin" freebelvin

To mhreyn and any others, also thanks in reply to Randy's alternate group suggestion:

(1.) I wrote a python script that fetches the same data fields Randy has encoded into his documentation.

(2.) My script works at a command line interface. It is not part of Excel. I import the data and then write out my own csv files, which can be manipulated in a second pass. My script is not merged into Excel directly.

(3.) This is an alternate mode of data retrieval for those who are willing to get into the weeds of programming python scripts. And that is not a trivial effort!

(4.) If anyone is interested in seeing what I did then I could either upload examples to the files section or you can email me directly at freebelvin@mindspring.com.

Thanks,

belvin

--- In smf_addin@yahoogroups.com, "mhreyn" <mhreyn@...> wrote:
>
> Hi,
>
> I would be interested in learning/contributing to this effort using Python. Let me know if you are interested.
>
>
> --- In smf_addin@yahoogroups.com, "freebelvin" <freebelvin@> wrote:
> >
> > Greetings to all via my first post to this group.
> >
> > I recently joined this group because you all do some things I wanted to learn. I've been studying the literature on the site and I'm very impressed with the level of technology, and wish to express my thanks to Randy and others for developing these tools and generously sharing them with others.
> >
> > It turns out that I'm an engineer and have a few tricks too. I thought I might take this opportunity to describe what I've been doing, and the question in this post is closely related to my approach. First let me say that I do not in any way put this out as any form of technology competition! I only bring this up as a way of expanding people's awareness of what is possible.
> >
> > What I have done is to use the same URL linking and fetching mechanisms embedded inside the excel macros, but I have embedded them instead into python scripts. This leads to much more programming effort, but also provides much more flexibility in handling the data. In the example below, a script could be coded with the website URL and fields to extract and fetch the data on a schedule. The data could then be printed to the screen, or additional algorithms could be attached to generate alerts, perform follow-on calculations, etc. The possibilities are broad, but I admit, this does require a level of software skill. And I will comment that as a C programmer, learning python syntax has been quite an adventure for me.
> >
> > OK, that's it. If anyone wishes to know more about this approach to processing web-based market data, please let me know and I can follow up. Again, please consider this to be an augmentation of the technology already existing in this group, and not as the beginning of any type of competition!
> >
> >
> > belvin
> >
> >
> >
> > --- In smf_addin@yahoogroups.com, "metastkuser100" <metastkuser100@> wrote:
> > >
> > > I would like to:
> > >
> > > a) Screen scrape two numbers from a website, every 15 minutes, which then populate a table in Excel, throughout market hours, M-F.
> > >
> > > b) Then plot an Excel chart based on the data in the table. As the day progresses, the table and the chart gets automatically updated every 15 minutes.
> > >
> > > This is possibly way beyond my abilities, but I'm willing to give a real good try!
> > >
> > > Can the first part be done by SMF plugin?
> > >
> >
>

Mon Oct 8, 2012 9:11 am (PDT) . Posted by:

"codyklein" codyklein

Is there a way to return this number to see where one is at. In my case I have a spreadsheet where its impossible to tell due to all the vba code and just the entire structure. I always thought I was well below the limit but suspect I'm am hitting it. Anyway it would be good to know how many web pages have been downloaded.

Mon Oct 8, 2012 9:25 am (PDT) . Posted by:

"Chris Ball" peggysue281

I am trying to use the add in and keep recieving the errors for some
formulas, here are a couple of examples:

=RCHGetElementNumber(Ticker,25)
=RCHGetElementNumber(Ticker,48)
=RCHGetElementNumber(Ticker,84)
=RCHGetElementNumber(Ticker,AN12)

I am using version 2.1.2012.04.07

Any help is greatly appreciated.
Diposting oleh EXCEL FEED LEARNING di 09.25

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)