Front/Back Office Application Support, C, C#, Perl, Python, SQL, Unix

SQL Query Performance

Database performance relies on several layers ranging from operation system, hardware, network, devices, database server, database design, to client side SQL query design in an application. The bottleneck could lay on any layer. However , once the system environments have been established and a database has been properly designed, the performance of the database mainly depends on properly created indexes and SQL query design. Accordiing to Sybase , 80% of Sybase database performance problems can be solved by properly created index and carefully design of SQL queries.

Repo

Repurchase Agreement

This is a form of short-term borrowing for dealers in government securities. The dealer sells the government securities to investers, usually on an overnight basis, and buys them back the following day.

For the party selling the security (and agreeing to repurchase it in the future) it is a repo; for the party on the other end of the transaction, (buying the security and agreeing to sell in the future) it is a reverse repurchase agreement.

Repos are classified as a money-market instrument. They are usually used to raise short-term capital.

Arbitrage

The simultaneous purchase and sale of an asset in order to profit from a difference in the price. This usually takes places on different exchanges or marketplaces.

Here's an example of arbitrage: Say a domestic stock also trades on a foreign exchange in another country, where it hasn't adjusted for the constantly changing exchange rate. A trader purchases the stock where it is undervalued and short seels the stock where it is overvalued, this profiting from the difference. Arbitrage is recommended for experienced investors only.

I wish & I Want

I wish

I wish means: wouldn't it be nice if...

If you always make the right decision, the safe decision, the one most people make, you will be the same as everyone else.
Always wishing life was different.

I want
I want means: if I want it enough I will get it.
Getting what you want means making the decisions you need to make to get what you want.

Not the decisions those around you think you should make.

Making the safe decisions is dull, predictable and leads nowhere new.

How do the Floor Brokers do it?

When working at the trading floor at Cantor Fitzgerald one of the desk , Interest Rates Swaps (IRS), used to trade using hand movements. Have you ever seen the movie trading places? Well it was similar here. I was amazed at the energy and frantic hand movements when the brokers where trading. When you see pictures of the traders in the pit, here's what you're looking at:

Palms in , or "I'm a buyer"
Palms out,or "I'm a seller"

Trading Currencies

The very first financial futures contracts were based on foreign currencies. It should be noted that the spot ( or forward market) is much bigger than the futures. The forwared market , also know as the Interbank market, is dominated by currency dealers at major global banks. Traded electronically and by telephone, the spot market's volume towers over the listed Exchange volume. The average unit is $1 million, and although currencies also can be traded at retail FOREX-type outlets. CFD currency trading has now become very popular with retail customers and institions. Hedge Funds are are also using CFD to hedge positions against currency movements.

Currency Fundamentals

nawk unix tool

Awk Utility Awk scans a file (or input) line by line, from the last line, searching for lines that match a specified pattern and performing selected actions ( enclosed in curly braces) on those lines.
%nawk 'pattern' filename
%nawk '{action}' filename
%nawk 'pattern {action}' filename

-- if the regular expression z is matched anywhere on the line, awk prints the entire line.
nawk -F: '/z/' file.txt

-- if the line begins with one or more upper or lowercase letter a's, the entire line is printed.
nawk '/^[Aa]+/' file.txt

The most clever people at school are not those who always make it in life

What you learn at school are facts. Your job at school is to accumulate and remember facts and figures. The more you remember the better you do.

Those who fail at school are not interested in facts; or maybe the facts are not put to them in a way they find interesting.

Some people simply don't have a great faculty for memory. This does not mean they are stupid. It means their imagination hasn't been fired up by academic tuition.

People who are conventionally clever get jobs on their qualifications ( the past), not on their desire to succeed ( now and the future).

You can achieve the unachievable

Firstly you need to aim beyond what you are capable of. You must develop a complete disregard for where your abilities end. Try to do the things that you're incapable of. If you think you're unable to work for the best company in its sphere, make it your aim to. If you think you're incapable of running a company , make it your aim to. If you think you are unable to make a career change, make it your aim to.

Make your vision of where you want to be a reality.

Nothing is impossible

Front Arena

FRONT ARENA is the definitive integrated solution for sales, trading, risk management, operations and distribution – right across multiple asset classes. FRONT ARENA covers all traded products, liquid and illiquid, OTC and exchange-traded, standardized and structured. All priced consistently and risk-managed in real time. True straight-through processing gives complete control over the entire trade process, from initiation to back-office processing. Running on Unix , Sybase Server & Windows. Either installation locally or via Citrix.

Syndicate content