Messages In This Digest (7 Messages)
- 1a.
- Re: WSJ Market Data From: bushpilote@yahoo.ca
- 2a.
- Controlling updates From: Glen Fullmer
- 2b.
- Re: Controlling updates From: Randy Harmelink
- 3a.
- Get data for over 3000 companies? From: CheeseMan
- 3b.
- Re: Get data for over 3000 companies? From: Randy Harmelink
- 4a.
- data in php file or mysql From: mic_peg
- 4b.
- Re: data in php file or mysql From: Randy Harmelink
Messages
- 1a.
-
Re: WSJ Market Data
Posted by: "bushpilote@yahoo.ca" bushpilote@yahoo.ca bushpilote
Fri Oct 7, 2011 4:25 am (PDT)
Got It. Got both functions to work. Once again thanks for your quick reply.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> It's an array-entered function (over a range) with no row/column number
> combinations...
>
> You said you wanted the RCHGetHTMLTable() function for retrieval, not
> RCHGetTableCell().
>
> On Thu, Oct 6, 2011 at 6:27 AM, <bushpilote@...> wrote:
>
> >
> > At my end, the function returns the text "P/E RATIO". I tried using
> > different row/column number combination to try to get the actual pe with no
> > luck.
> >
> > --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@> wrote:
> > >
> > > Simple as pie:
> > >
> > > =RCHGetHTMLTable("
> > http://online.wsj.com/mdc/ ",">Dowpublic/page/ 2_3021-peyield. html
> > > Industrial",-1,"",1)
> >
>
- 2a.
-
Controlling updates
Posted by: "Glen Fullmer" gfullmer@cox.net gfullmer
Fri Oct 7, 2011 10:18 am (PDT)
Is there a way not to update any SMF function until a button is pressed?
When adding to a spreadsheet it recomputes with every addition. I got
rid of the NOW() functions, but it is still slow.
Thanks,
Glen
--
Glen Fullmer, gfullmer@cox.net , http://members.cox.net/gfullmer
---
http://personalcashflow.blogspot. - cash flow blogcom
http://www.alreadytoharvest. - historical novelcom
http://www.youtube.com/gfullmer - fractal Movies
"True love doesn't want anything" - Eckhardt Tolle
"Charity doesn't think about itself" - St. Paul
"all things whatsoever ye would that men
should do to you, do ye even so to them" - Jesus
---
- 2b.
-
Re: Controlling updates
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Fri Oct 7, 2011 11:05 am (PDT)
The functions should be non-volatile unless you make them volatile with
something like NOW(). If you have things recomputing, it should mean you've
made the functions volatile. Also, row/column insertions and deletions will
trigger a recalculation.
I leave all of my function invocation non-volatile and then use the
smfForceRecalculation macro (assigned to a toolbar button) to update things
when I need them updated.
On Fri, Oct 7, 2011 at 10:18 AM, Glen Fullmer <gfullmer@cox.net > wrote:
> Is there a way not to update any SMF function until a button is pressed?
> When adding to a spreadsheet it recomputes with every addition. I got
> rid of the NOW() functions, but it is still slow.
>
- 3a.
-
Get data for over 3000 companies?
Posted by: "CheeseMan" jcrenshaw75@yahoo.com jcrenshaw75
Fri Oct 7, 2011 10:59 am (PDT)
Hello,
I was wondering if it was possible to get data for about 3200
companies*. I tried running the SML Lite version of Yahoo Get Quotes,
and I got to about 200 companies before all the info just "whited out".
These are the data fields that I need:
-- Minority Interest (most recent quarter balance sheet)-- 20-day Moving
Average (I think I'll have to calculate this my self using Yahoo's
historical price data)-- 200-day Moving Average (This is on the Yahoo
Key Statistics page)
Thanks,Joe
*I have a list of the tickers if anyone wants to help out on this
- 3b.
-
Re: Get data for over 3000 companies?
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Fri Oct 7, 2011 11:20 am (PDT)
The 200 company limit on getting quotes from Yahoo is a Yahoo limitation,
not an add-in limitation. Also, their 200-day SMA is based on CALENDAR days,
not TRADING days.
The add-in isn't intended for downloading large amounts of data. I actually
don't want people abusing the free data services by doing that type of
thing. As it is, the add-in only has storage space for 1000 web pages per
"session". As far as I'm concerned, that's more than enough for any
reasonable use.
You can get the 20-day and 200-day SMA from FinViz for all companies they
cover in a single Internet access. Try using that to "pare down" your 3200
companies to a more reasonable size before going after other data.
On Fri, Oct 7, 2011 at 10:29 AM, CheeseMan <jcrenshaw75@yahoo.com > wrote:
>
> I was wondering if it was possible to get data for about
> 3200 companies*. I tried running the SML Lite version of Yahoo Get Quotes,
> and I got to about 200 companies before all the info just "whited out".
>
> These are the data fields that I need:
>
> -- Minority Interest (most recent quarter balance sheet)
> -- 20-day Moving Average (I think I'll have to calculate this my self using
> Yahoo's historical price data)
> -- 200-day Moving Average (This is on the Yahoo Key Statistics page)
>
>
- 4a.
-
data in php file or mysql
Posted by: "mic_peg" mic_peg@yahoo.com mic_peg
Fri Oct 7, 2011 11:38 pm (PDT)
hi there,
if data are stored in the table which is part of php variables, will it work on rchgethtmltable ?
for example:
<table width="100%" border="1" cellpadding="1"...>
<?php while($rsForms= mysql_fetch_array($rs) )
echo "<td>". $rows["ticks"] . "<BR></TD>";
echo "<td>". $rows["price"] . "<BR></TD>";
?>
</table>
alternatively, anyway to extract data from mysql db?
Thanks.
- 4b.
-
Re: data in php file or mysql
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Fri Oct 7, 2011 11:41 pm (PDT)
The PHP code you're showing is executed server-side. By the time the add-in
is retrieving the source code, it's client side and there should be no trace
of the PHP code. PHP is just used to generate the source code of the web
page.
For SQL, you'd need to do your own queries. Nothing in the add-in is set up
to do it. Unless the SQL product you're using is driven by URL parameters
and delivers a web page based on those parameters.
On Fri, Oct 7, 2011 at 11:21 PM, mic_peg <mic_peg@yahoo.com > wrote:
>
> if data are stored in the table which is part of php variables, will it
> work on rchgethtmltable ?
>
> for example:
>
> <table width="100%" border="1" cellpadding="1"...>
>
> <?php while($rsForms= mysql_fetch_array($rs) )
> echo "<td>". $rows["ticks"] . "<BR></TD>";
> echo "<td>". $rows["price"] . "<BR></TD>";
>
> ?>
>
> </table>
>
> alternatively, anyway to extract data from mysql db?
>
Need to Reply?
Click one of the "Reply" links to respond to a specific message in the Daily Digest.
MARKETPLACE
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Individual | Switch format to Traditional
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe
Tidak ada komentar:
Posting Komentar