Posts
Published 14 April 2011
in archive
with tags
yql
,
yahoofinance
I am writing a bit of code to grab stock data and Yahoo's CSV data source is absolutely terrible. Commas in the middle of data in a CSV file? madness!
Continue reading …
Published 26 January 2011
in archive
with tags
microsoftexcel
I hate it in Excel when my currency has to be either spaced out nicely OR red when negative. There is the currency, which has nice colours, for negatives, which is good. But then the accounting format has nice spacing, with the pound sign on the left.
Continue reading …
Published 20 January 2011
in archive
with tags
sql
If you look at this SQL article [old link removed], you may either be impressed or insult me for bad coding practise. FYI, it does run on 1000 rows in < 1 second. When I was using MsSql (before I migrated to CentOS/Mono/MySql) I sometimes had to go to extortionate amounts of effort to get stuff done, but with MySql it all seems, a bit too easy.. So from the giant SQL that you saw in the previous article, I can do all that on the same tables (bar one change) with the following SQL:
Continue reading …
Published 14 January 2011
in archive
with tags
c
Following on from the problems I had with my previous string.format C function, I decided to rewrite it today under heavy valgrind observation.
Continue reading …
Published 13 January 2011
in archive
with tags
c
Another C function which works quite well and has no bugs that I know of yet...
Continue reading …