Message from discussion
Introduction
Received: by 10.223.120.19 with SMTP id b19mr357113far.1.1297669578081;
Sun, 13 Feb 2011 23:46:18 -0800 (PST)
X-BeenThere: sage-finance@googlegroups.com
Received: by 10.223.7.80 with SMTP id c16ls1986396fac.3.p; Sun, 13 Feb 2011
23:46:17 -0800 (PST)
Received: by 10.223.70.136 with SMTP id d8mr357001faj.9.1297669577151;
Sun, 13 Feb 2011 23:46:17 -0800 (PST)
Received: by 10.223.70.136 with SMTP id d8mr356999faj.9.1297669577128;
Sun, 13 Feb 2011 23:46:17 -0800 (PST)
Return-Path: <wst...@gmail.com>
Received: from mail-bw0-f48.google.com (mail-bw0-f48.google.com [209.85.214.48])
by gmr-mx.google.com with ESMTPS id a26si223179faa.0.2011.02.13.23.46.16
(version=TLSv1/SSLv3 cipher=OTHER);
Sun, 13 Feb 2011 23:46:16 -0800 (PST)
Received-SPF: pass (google.com: domain of wst...@gmail.com designates 209.85.214.48 as permitted sender) client-ip=209.85.214.48;
Authentication-Results: gmr-mx.google.com; spf=pass (google.com: domain of wst...@gmail.com designates 209.85.214.48 as permitted sender) smtp.mail=wst...@gmail.com; dkim=pass (test mode) header...@gmail.com
Received: by bwz8 with SMTP id 8so6124231bwz.21
for <sage-finance@googlegroups.com>; Sun, 13 Feb 2011 23:46:15 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
d=gmail.com; s=gamma;
h=domainkey-signature:mime-version:in-reply-to:references:from:date
:message-id:subject:to:content-type:content-transfer-encoding;
bh=Y+g9bGNqYxdJ1MNmRv9rr42fG0PAZIVVCJwCJ6SZKkM=;
b=con7u1jKm43l1d2LZ9YrU4e54YMFTHWZddkN9BHXoNdPL+y07+1uncswGrO14DQXKY
1PNTB9eD/LLosJfYe/aUK/LBTLVug9WT30MPICf+sUYiZgykST1wMmrWj9zFGvpFpflO
Eqr8EWSkD5tJdkxN7PVDMRGzEr/fsdRaptEpw=
DomainKey-Signature: a=rsa-sha1; c=nofws;
d=gmail.com; s=gamma;
h=mime-version:in-reply-to:references:from:date:message-id:subject:to
:content-type:content-transfer-encoding;
b=w72czvE9bpO/VmPsCZ0wfi1EX9jTZA/F4HjLBeObL00i6WsUwKcb4h7OCRe99iu+Zs
G1kLZkhIxg4TiHbo0VHjQoDzfOCGkwFK6r8JjJ5QOllO9TRhY0glrxL8tB7WlP3m1hte
O+9MJMwQOOg5JDOfa/SwAOcgV9Ce727X0emQY=
Received: by 10.204.56.203 with SMTP id z11mr6921669bkg.200.1297669575526;
Sun, 13 Feb 2011 23:46:15 -0800 (PST)
MIME-Version: 1.0
Received: by 10.204.99.74 with HTTP; Sun, 13 Feb 2011 23:45:45 -0800 (PST)
In-Reply-To: <95c722ec-b0f4-4274-952a-20fbb1d97...@f36g2000pri.googlegroups.com>
References: <95c722ec-b0f4-4274-952a-20fbb1d97...@f36g2000pri.googlegroups.com>
From: William Stein <wst...@gmail.com>
Date: Sun, 13 Feb 2011 23:45:45 -0800
Message-ID: <AANLkTinhU5TUNjVcjqhNivK4eYXEMSGxN+yjAzNKu...@mail.gmail.com>
Subject: Re: [sage-finance] Introduction
To: sage-finance@googlegroups.com
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
On Sun, Feb 13, 2011 at 6:29 PM, Paul English <pengli...@gmail.com> wrote:
> Hi Folks,
>
> =A0 This group seems to have been idle for a while, but I thought I
> would introduce myself and see if anyone else out there shared some
> interests and perhaps we can get some development going in the
> quantitative finance domain.
>
> I'm much more interested in currency data than Stocks, so I'd like to
> have a sage.finance.FX (Forex? Currency?). Yahoo Finance supplies this
> data, but sage.finance.Stock fails when fed a currency pair symbol:
>
> finance.Stock('EURUSD').yahoo()
>
> {'stock_exchange': '"N/A"', 'market_cap': 'N/A', '200day_moving_avg':
> 'N/A', '52_week_high': 'N/A', 'price_earnings_growth_ratio': 'N/A',
> 'price_sales_ratio': 'N/A', 'price': '0.00', 'earnings_per_share':
> 'N/A', '50day_moving_avg': 'N/A', 'avg_daily_volume': '0', 'volume':
> 'N/A', '52_week_low': 'N/A', 'short_ratio': 'N/A',
> 'price_earnings_ratio': 'N/A', 'dividend_yield': 'N/A',
> 'dividend_per_share': 'N/A', 'price_book_ratio': 'N/A', 'ebitda': 'N/
> A',
> 'change': 'N/A', 'book_value': 'N/A'}
>
> (Currency rates are always quoted as pairs)
>
> I imagine it would be fairly easy to modify the existing finance.Stock
> class to create a Forex class and have it supply all the same methods.
> Volume would need to be ignored as that is not typically available for
> Forex.
I agree. I think it would be great if you could add this
functionality. How to do so is explained in the Sage Developer's
guide:
http://sagemath.org/doc/developer/
> Along the currency theme, I'm also trying to convert the ~9GB/10 years
> of zipped csv GAIN Forex data:
> http://ratedata.gaincapital.com/
> from ticks into various candlesticks values. While
> sage.finance.timeseries will display a Candlestick chart, it doesn't
> currently output candlestick values as far as I can tell. Again it
> seems like it should be a fairly easy modification, since
> plot_candlestick() already needs to do the conversion in order to plot
> the candlesticks.
That's also a great idea. I think the TimeSeries code is pretty
straightforward (it's just simple Cython code). I wrote most of it,
so if you have questions, don't hesitate to ask.
> Then generally I'm interested in getting access to more common
> technical indicators (stochastics, Bollinger bands...), both for
> Stocks and Forex in SAGE. It may be that those already exist via R
> libraries, or in completely other domains, so I'm still exploring.
I'm sure they do. There can be some advantages to adding them to
TimeSeries, e.g., speed.
> I graduated with my Bachelor of Science in Computer Science in 1998
> from Worcester Polytechnic Institute, but since then I've been a
> Systems Administrator and now I'm a lofty IT Director (as in, I do
> some IT, and spend more time in meetings than a normal sysadmin) -
> meaning my math and programming skills have atrophied somewhat, and
> I've never done any programming professionally aside from smallish
> scripts.
I predict that contributing to Sage could be the funnest thing you do
for a while :-)
> Still - I've always been excited about open source (which has backed a
> non-trivial amount of my career), and recently about Forex and Sage.
>
> --
> You received this message because you are subscribed to the Google Groups=
"sage-finance" group.
> To post to this group, send email to sage-finance@googlegroups.com.
> To unsubscribe from this group, send email to sage-finance+unsubscribe@go=
oglegroups.com.
> For more options, visit this group at http://groups.google.com/group/sage=
-finance?hl=3Den.
>
>
--=20
William Stein
Professor of Mathematics
University of Washington
http://wstein.org