When tasks get too complicated for Excel and Access, I usually turn to Visual Basic Express (download it for free from Microsoft).
With this program I can make my own programs! The wonderful thing about programming is that you can achieve almost any office task, be it extracting data from the internet, renaming folders, drawing graphs, or anything you put your imagination into.
The big downside is that programming takes time. Even something supposedly simple, like opening up a text file, takes time to code. In the pdf file - VB.NET Made Easy - I explain how my codes, called jpFunctions!, simplify many programming tasks.
JP JANSSEN
Friday, April 29, 2011
Friday, February 4, 2011
Find a Norwegian
I have come up with something I call a niche^ meta^^ search engine. It's named Great Norwegians and lets you look up any person residing in Norway*. Based on official tax data, it estimates whether a name is unique or not. It further links to other search engines that reveal relevant phone, address, and business information.
It is fully functional, but the design can be improved. I will do so if it turns popular.
March 29, 2011:
The Great Norwegian Experiment
How I made a Search Engine on all Norwegian Names
And How it has Performed
Sunday, December 12, 2010
Online Business Card
An online business card is very easy to make.
Friday, December 10, 2010
Data Mining Expertise
Do you need help downloading or processing large amounts of data?
I can probably come to your rescue.
For the master thesis I co-wrote with Peter Georg Burhol, we used tick (trade) data for every stock on the Oslo Stock Exchange for all of 2008. I made a program which needed to run every day for a full year to accomplish this. In addition we downloaded more than a million forum posts. At the end we had gigabytes of data to play with! As a result we could go back in time and find out exactly what had happened around every major event that year.
I also got an A in in Intelligent Machines, a course about Artificial Intelligence, at the Harvard Summer School.
Email me for further information:
mail(at)jpjanssen(dot)com
[View Master Thesis. Norwegian version only]
[View Intelligent Machines Project. Download ZIP with supporting files]
This graph makes use of all trades in a stock called RGT on May 8th 2008.
See pages 32-62 of the thesis.
I can probably come to your rescue.
For the master thesis I co-wrote with Peter Georg Burhol, we used tick (trade) data for every stock on the Oslo Stock Exchange for all of 2008. I made a program which needed to run every day for a full year to accomplish this. In addition we downloaded more than a million forum posts. At the end we had gigabytes of data to play with! As a result we could go back in time and find out exactly what had happened around every major event that year.
I also got an A in in Intelligent Machines, a course about Artificial Intelligence, at the Harvard Summer School.
Email me for further information:
mail(at)jpjanssen(dot)com
[View Master Thesis. Norwegian version only]
[View Intelligent Machines Project. Download ZIP with supporting files]
This graph makes use of all trades in a stock called RGT on May 8th 2008.
See pages 32-62 of the thesis.
Sunday, December 5, 2010
Option Pricing
Exam tip for finance students!
If your professor talked about options throughout the semester, chances are you will be asked to calculate call and put prices. A popular way of doing this, in introductory classes at least, is by using the binomial option pricing formula.
This requires a lot of calculations, so the task is quite time consuming and the result is prone to error. Practice, practice, practice! This will save you time on the exam and guarantee a good result!
When I trained for an exam a few years back, I made this program to check whether my pen-and-paper calculations were correct. [Excel version]
If your professor talked about options throughout the semester, chances are you will be asked to calculate call and put prices. A popular way of doing this, in introductory classes at least, is by using the binomial option pricing formula.
This requires a lot of calculations, so the task is quite time consuming and the result is prone to error. Practice, practice, practice! This will save you time on the exam and guarantee a good result!
When I trained for an exam a few years back, I made this program to check whether my pen-and-paper calculations were correct. [Excel version]
Sunday, November 21, 2010
My Archive
Ebooks
The Stock Market Alligator
Essays on the Market Ecosystem
Developing Trader
A Young Speculator's Sketchbook
What is Happening to the Dollar?
Faber and Rogers VS Bernanke and Krugman
MSc Thesis
En gjennomgang av samtlige børspauser i 2008 [English version not available]
En sammenligning av informasjonsflyten fra Hegnar Online, Hegnar Onlines diskusjonsforum og Oslo Børs
Web Design
Find a Norwegian
Search engine on all Norwegian names
The Business and Finance Club at Harvard Summer 2009
Accomplishments
$250 awarded for a technical article I wrote at age 21 [PDF copy, pages 16-17]
The Stock Market Alligator
Essays on the Market Ecosystem
Developing Trader
A Young Speculator's Sketchbook
What is Happening to the Dollar?
Faber and Rogers VS Bernanke and Krugman
MSc Thesis
En gjennomgang av samtlige børspauser i 2008 [English version not available]
En sammenligning av informasjonsflyten fra Hegnar Online, Hegnar Onlines diskusjonsforum og Oslo Børs
Web Design
Find a Norwegian
Search engine on all Norwegian names
The Business and Finance Club at Harvard Summer 2009
Accomplishments
$250 awarded for a technical article I wrote at age 21 [PDF copy, pages 16-17]
Subscribe to:
Posts (Atom)
