[Yahoo documentation of quote fields]

[External documentation of fields]

These use the numpy library, I believe. I adapted them to work in a more vanilla python way as I could not get my head around numpy.

Exponential moving average

def ema(s, n):
    """
    returns an n period exponential moving average for
    the time series s

    s is a list ordered from oldest (index 0) to most recent
    (index -1) n is an integer

    returns a numeric array of the exponential moving average
    """
    s = array(s)
    ema = []
    j = 1
    #get n sma first and calculate the next n period ema
    sma = sum(s[:n]) / n
    multiplier = 2 / float(1 + n)
    ema.append(sma)
    #EMA(current) = ( (Price(current) - EMA(prev) ) xMultiplier) + EMA(prev)
    ema.append(( (s[n] - sma) * multiplier) + sma)
    #now calculate the rest of the values
    for i in s[n+1:]:
        tmp = ( (i - ema[j]) * multiplier) + ema[j]
        j = j + 1
        ema.append(tmp)
    return ema

Simple moving average

def movavg(s, n):
    """
    returns an n period moving average for the time series s
       
    s is a list ordered from oldest (index 0) to most recent (index -1)
    n is an integer

        returns a numeric array of the moving average

    See also ema in this module for the exponential moving average.
    """
    s = array(s)
    c = cumsum(s)
    return (c[n-1:] - c[:-n+1]) / float(n-1)

Excel: Find unique values in column

Sub FindUniqueValues()
    Call Rows("1:1").Insert(Shift:=xlDown)
    Range("A1").Value = "Email"
    Range("B1").Value = "Unique"
    Call Columns("A:B").Sort(Key1:=Range("A2"), _
        Order1:=xlAscending, Header:=xlYes, _
        OrderCustom:=1, MatchCase:=False, _
        Orientation:=xlTopToBottom, _
        DataOption1:=xlSortNormal)
        
    Dim wks As Worksheet
    Set wks = ThisWorkbook.ActiveSheet
    Dim startCell As Range, endCell As Range:
    Set startCell = Range("B2")
    Set endCell = wks.Cells.SpecialCells(xlCellTypeLastCell)
    startCell.FormulaR1C1 = "=RC[-1]<>R[1]C[-1]"
    Dim r As Range
    Set r = Range(startCell, endCell)
    Call startCell.AutoFill(Destination:=r)
    Call wks.Calculate
    Set r = Columns("A:B")
    Call r.AutoFilter
    Call r.AutoFilter(Field:=2, Criteria1:="TRUE")
End Sub

numpy provides the underlying data structures (array and matrices among other things) you require. This will handle all your vector stuff, reading/writing to and from files, "loop macros", etc.

scipy provides a set of scientific programming libraries, including stats, fft and many other things. Have a look around and see if it already does what you want.

matplotlib takes care of all your plotting needs, and plays nice with numpy and scipy.

Add a COM reference to:
Microsoft OLE DB Service Component 1.0 Type Library
Microsoft ActiveX Data Objects 2.7 // any 2.5 or higher version is fine

You can then write code like:

//
// Prompt for a totally new connection string
//
private void button1_Click(object sender, EventArgs e)
{
    bool Cancelled = false;
    string ConnectionString = string.Empty;

    MSDASC.DataLinks d = new MSDASC.DataLinks();
    d.hWnd = (int)this.Handle;
    ADODB._Connection c = (ADODB._Connection)d.PromptNew();
    if (c == null)
        Cancelled = true;
    else
    {
        Cancelled = false;
        ConnectionString = c.ConnectionString;
    }
}

//
// Edit a connection string
//
private void button2_Click(object sender, EventArgs e)
{
    bool Saved = false;
    string ConnectionString = "Provider=SQLOLEDB.1;Integrated
Security=SSPI;Persist Security Info=False;User ID=sa;Initial
Catalog=Northwind;Data Source=.";

    MSDASC.DataLinks d = new MSDASC.DataLinks();
    d.hWnd = (int)this.Handle;
    object c = new ADODB.Connection();
    ((ADODB._Connection)c).ConnectionString = ConnectionString;
    Saved = d.PromptEdit(ref c);
    if (Saved)
    {
        ConnectionString = ((ADODB._Connection)c).
          ConnectionString;
    }
}

Using the Visual Studio Connection String Dialog

• AdoGuy article
• AdoGuy download

SQL Server 2005 GUID primary keys

CREATE TABLE Employee 
            (EmployeeID uniqueidentifier DEFAULT NEWSEQUENTIALID())

Screen: overhead volume breakout

• Search for last down day with a large range and high volume (2x 20-day MA volume)
• Watch point is that day's open
• Wait for stock to clear that point

Microsoft communities

Custom molds for earphones and headsets

[The essentials of trading]

[Trade with form]

Is it better to rent or buy?
Calculator compares renting and buying for a specific rental versus a specific home purchase.

Python and sqlite package

• pysqlite releases
• sqlite
• pysqlite wiki

[HDB 2008-06-04] This seems to have moved to an unidentified location. Or, more likely, it has been removed from the internet. It's really useful. I wish I'd downloaded it when I had the chance.

PathCompactPathEx()

[DllImport("shlwapi.dll", CharSet = CharSet.Auto)]
static extern bool PathCompactPathEx(
    [Out] StringBuilder pszOut, 
    string szPath, int cchMax,
    int dwFlags);

static string PathShortener(string path, int length)
{
    StringBuilder sb = new StringBuilder();
    PathCompactPathEx(sb, path, length, 0);
    return sb.ToString();
}

• tradingmarkets
  Lots of good info.
• hardrightedge
  good resource
• realitytrader
  scalping techniques
• tradethenews
  It would be nice to have a spare pc to run the news via audio
• briefing
  subscription based news
• advfn - charts and much more free stuff
  
• investorflix
  rent trading DVD's
• wealth-lab
  shared trading strategies
• activetradermag bookstore
  low cost tapes
• activetradermag
  good magazine
• gndt
  best trading platform around

[USB phone recorder]

[iPod DJ mixing console]

[Lehman's Roller Mill (elegant little Italian grain grinder)]

Python and databases

• dmoz: python database and persistence
• adodbapi
  A Python module that makes it easy to use Microsoft ADO for connecting with databases and other data sources.

Coding Horror links

• Is Your Database Under Version Control?

  The database is a critical part of your application. If you deploy version 2.0 of your application against version 1.0 of your database, what do you get? A broken application. And that's why your database should always be under source control right next to your application code. You deploy the app, and you deploy the database. Like peanut butter and chocolate, they are two great tastes that taste great together.

• Cool Gifts for Geeks: 2006 Edition
• PowerPoint presentations
• Code smells
• The Last Configuration Section Handler.. Revisited
• FizzBuzz

So I set out to develop questions that can identify this kind of developer and came up with a class of questions I call "FizzBuzz Questions" named after a game children often play (or are made to play) in schools in the UK. An example of a Fizz-Buzz question is the following:

Write a program that prints the numbers from 1 to 100. But for multiples of three print "Fizz" instead of the number and for the multiples of five print "Buzz". For numbers which are multiples of both three and five print "FizzBuzz".

Most good programmers should be able to write out on paper a program which does this in a under a couple of minutes. Want to know something scary? The majority of comp sci graduates can't. I've also seen self-proclaimed senior programmers take more than 10-15 minutes to write a solution.

• When Understanding Means Rewriting

  It's not that developers want to rewrite everything; it's that very few developers are smart enough to understand code without rewriting it.

• How Not To Become a Rockstar Programmer

  The only way to get better at writing code is to write code. So study "good code*" all you want, but write as much code as you can.

• The Ultimate Code Kata

  It's an important distinction [between doing your programming job and practicing programming]. I may drive to work every day, but I'm far from a professional driver. Similarly, programming every day may not be enough to make you a professional programmer. So what can turn someone into a professional driver or programmer? What do you do to practice?

All you need to do is:

• Open FireFox options
• Go to General | Connection Settings
• Use the Manual proxy configuration option
• Set t 127.0.0.1 Port 8888

Who Is This Person? [Firefox Add-ons]

With the Who Is This Person? Firefox extension, highlight a name on a web page and with a click look up someone's personal details in LinkedIn, Wikipedia, Technorati, Yahoo Person Search, Google News, TailRank and more. Useful!

S3Fox Organizer for FireFox

S3Fox Organizer for Amazon(S3Fox) v0.4: (NEW!) This firefox extension(browser plugin) provides an user friendly interface for Amazon's S3 (Simple Storage Service) . Its interface is very much similar to the FTP interface that lists local folders in the left panel and S3 buckets/files/folders in the right panel. Files/folders can be moved from the local computer to Amazon's storage space and vice versa.

S3Fox

Financial blogs

• [etfconnect.com]
• [Inventing money]
• [calculated risk]
• [Bill Burnham]

[Technical trading strategies]
[Reuters stock screener]
[Barcharts top 100]
[John Murphy's Ten Laws of Technical Trading]

[Keyboard equivalents of Remote Desktop]
[MetaCritics books]
[Year end quizzes]
[MetaFilter on smart women don't marry]
[Bell curve for doctors]
[Frictionless Testing with TestDriven.NET]
[Fixing/locking down a user PC]
[The graphing calculator story]
[Death and taxes: USA Congress discretionary spending]
[.NET Passport 2.5 Software Development Kit: Software and Documentation]

• The Kirk Report
  lots of news and links, updates everyday, posts his trades
• traderxblog
  posts his trades, shows charts, educates, very good active trader
• tradermike
  posts some trades, free chart analysis
• slytrader
  posts his trades and charts, very good active trader
• tradediary - posts his trades
• nasdaqtrader
• stocktradingguy
• traderjamie
• stockcoach
• tapeworm
• slovakchart
• activetrade
• englishmantrader

• Prefetching
  Fasterfox uses idle bandwidth times to pre-fetch and cache the links on your current page.
• Network Tweaks
  You set how Fasterfox controls simultaneous connections, pipelining, caching and more.
• Pop-up Blocker
  It blocks Flash plug-in pop-ups now.
• Page Load Timer
  This tests the effectiveness of your settings.

• [Magic Password Generator]
• [Password Hasher]
• [SecurePassword Generator]
• [PasswordMaker]
• [Password Composer]

Websites for definitons and neologisms

• [urbandictionary.com]
• [doubletongued.org]
• [wordspy.com]

Alphabetize procedures/subs

Also, you might be interested something to sort imports/using's.