Archive for March, 2009
Yahoo Stocks API Documentation
Yahoo offers a free Stock Quotes API. I found informal documentation at http://ilmusaham.wordpress.com/tag/stock-yahoo-data/ which I’ll re-iterate here in the event that site disappears.
Here is an example link to the Yahoo Stocks feed in CSV format:
http://ca.finance.yahoo.com/d/quotes.csv?s=AX-UN.TO+BEI-UN.TO&f=sd1t1ohgv&e=.csv
It currently shows two symbols: the AX-UN.TO and BEI-UN.TO. You can choose which symbols you want to display by replacing the blue text in the url with desired symbols, each separated by a plus sign. The red string in the url specifies the columns you want in the CSV file. The red string currently tells the csv to pull symbol (s), last trade date (d1), last trade time (t1), open (0), day’s high (h) and day’s low (g). The list of available field options are shown in table below.
| a | Ask | a2 | Average Daily Volume | a5 |
Ask Size |
b |
Bid | b2 |
Ask (Real-time) | b3 | Bid (Real-time) |
b4 |
Book Value | b6 |
Bid Size | c |
Change & Percent Change |
| c1 | Change | c3 |
Commission | c6 |
Change (Real-time) |
c8 |
After Hours Change (Real-time) | d | Dividend/Share | d1 |
Last Trade Date |
d2 |
Trade Date | e |
Earnings/Share | e1 | Error Indication (returned for symbol changed / invalid) |
e7 |
EPS Estimate Current Year | e8 |
EPS Estimate Next Year | e9 |
EPS Estimate Next Quarter |
| f6 | Float Shares | g |
Day’s Low | h |
Day’s High |
j |
52-week Low | k | 52-week High | g1 |
Holdings Gain Percent |
g3 |
Annualized Gain | g4 |
Holdings Gain | g5 | Holdings Gain Percent (Real-time) |
g6 |
Holdings Gain (Real-time) | i |
More Info | i5 |
Order Book (Real-time) |
| j1 | Market Capitalization | j3 |
Market Cap (Real-time) | j4 |
EBITDA |
j5 |
Change From 52-week Low | j6 | Percent Change From 52-week Low | k1 |
Last Trade (Real-time) With Time |
k2 |
Change Percent (Real-time) | k3 |
Last Trade Size | k4 | Change From 52-week High |
k5 |
Percebt Change From 52-week High | l |
Last Trade (With Time) | l1 |
Last Trade (Price Only) |
| l2 | High Limit | l3 |
Low Limit | m |
Day’s Range |
m2 |
Day’s Range (Real-time) | m3 | 50-day Moving Average | m4 |
200-day Moving Average |
m5 |
Change From 200-day Moving Average | m6 |
Percent Change From 200-day Moving Average | m7 | Change From 50-day Moving Average |
m8 |
Percent Change From 50-day Moving Average | n |
Name | n4 |
Notes |
| o | Open | p |
Previous Close | p1 |
Price Paid |
p2 |
Change in Percent | p5 | Price/Sales | p6 |
Price/Book |
q |
Ex-Dividend Date | r |
P/E Ratio | r1 | Dividend Pay Date |
r2 |
P/E Ratio (Real-time) | r5 |
PEG Ratio | r6 |
Price/EPS Estimate Current Year |
| r7 | Price/EPS Estimate Next Year | s |
Symbol | s1 |
Shares Owned |
s7 |
Short Ratio | t1 | Last Trade Time | t6 |
Trade Links |
t7 |
Ticker Trend | t8 |
1 yr Target Price | v | Volume |
v1 |
Holdings Value | v7 |
Holdings Value (Real-time) | w |
52-week Range |
| w1 | Day’s Value Change | w4 |
Day’s Value Change (Real-time) | x |
Stock Exchange |
y |
Dividend Yield |
Office Exercise - Chinese Shadow Boxing
Working in an office usually means you lead a sedentary life. It’s difficult to go the gym when you have a busy schedule. But there are still plenty of ways to stay fit in your 10 ft. by 10 ft. cubicle. You can stretch, do push ups, do sit ups, jumping jacks etc…
I prefer Chinese shadow boxing over all other exercise because it gets your heart rate up. Here’s me shadow boxing at my last job.
A busy work schedule is no excuse to not exercise. As I’ve demonstrated here, it’s easy to work on your cardio at your desk.
If you don’t exercise, you leave yourself vulnerable to high blood pressure, heart disease and many other illnesses. This will in turn take its toll on your work.
A healthy worker is a productive worker.
School vs. Work
If you’re a graduating high school student, and you are deciding which university/college program will land your dream job, then I have something to tell you. Most young adults, such as yourself, have no idea what the real workforce is like. You may think that school is the end-all and be-all to getting a job. Well, you are incredibly mistaken.
School and Work are two ABSOLUTELY different environments. You will find that much of what you learn in school is not relevant in the working world. To put things into perspective, consider this: education takes up 2 lines of a 2 page resume and 1 minute of a 30 minute interview. Sure school is good for learning the basics, but what lands you your job depends almost entirely on work experience and who you impress (important…it’s who you impress as opposed to who you know)
Therefore, I suggest you do the following:
1) Get a volunteer job or a part time paid job in the field you’re interested in. This will expose you to the true nature of the discipline. Then you’ll know for sure if you like it. It will also give you the much needed work experience for your future full time job.
2) Go to conferences and seminars to speak with Professionals in your field. Ask them about their job. Tell them about your aspirations and your personality. They will give you insight on how to get ahead in the field. You will also be networking with some important people. If you impress these individuals (this is important, knowing someone means nothing if you can’t impress them), they may consider you for future job positions.
When I first entered university, I made a big mistake in not following advices 1 and 2. It set me back 3-4 years.
How to Grow a Web Business
I’m sure every developer who’s ever wanted to start a business had trouble coming up with that one really awesome idea to make him millions. Personally, I feel that approach is too overrated. Here are two other approaches to consider:
Approach 1: Build for Niche Market
David from 37signals explains this one:
Watch live video from HackerTV on Justin.tv
Basically, don’t obsess over coming up with that one big application to change the world. You have a better chance at winning the lottery. Instead, take an already existing idea and just make it [slightly] better. Then rely on marketing power to take it the rest of the way. Have several of these apps, and you will do quite well.
Approach 2: Focus on Creating Assets
Instead of focusing on which business idea has the most potential for profit, I focus on which business idea allows me to build multi-purpose/re-useable technology. The advantage here is that regardless of whether the immediate business succeeds or fails, I will have created an asset of value that I can re-sale or re-use in the future. There will always be at least one other person who will find my technology useful, and will pay me to use it. This is what I call the “no-loss” scenario.
Get a Career in Web Development
The following question was asked on yahoo answers:
How to get into Web Design and Development?
I’m am taking a certificate in Web Design and Development from an accredited online university. Will I be able to get into the industry with this? Can someone comment on their experience on wages with the certificate and your experiences afterwards?
My Answer:
Education makes up 2 lines of a 2 page resume. It takes up 1 minute of a 30 minute interview. That should give you an idea of how relevant school material is in the real working world.
School is ok for learning the fundamentals, but it is by no means the deciding factor on whether you’re employed or not.
I’m a web application architect who’s hired people before. If you want to impress an employers, do the following:
1) have a good portfolio of projects - if you have no work experience, then put together volunteer projects for your friends. Employers will be impressed by your commitment and sacrifice. Tell employers straight up, “I haven’t worked in a company before because I’m at the beginning of my career. But I work hard and I have potential as evidenced by my portfolio of charitable web projects for non-profit organizations, family and friends. I am always willing to sacrifice for my career and for the company I work for.”
2) network with people in the industry - go to conferences and events and meet professionals in the field. Tell them you’re a student, and you want advice on how to improve your skills.
If you do items 1 and 2, you will have no problem getting a job. By the time you graduate, you may even have enough experience to start your own web firm.