I just noticed on a digg story that Google Spreadsheets lets you put live stock data in the cells. It’s the same as Google Finance data, which means it has the typical 20-minute delay. If it were real-time data, I’d use the heck out of it to program complicated real-time alerts based on a bunch of criteria. With a 20-minute delay, it’d just be pointing out opportunities I’ve already missed. :-(
I could maybe see this used to publish a shared spreadsheet that determined in 20-min delay time which stocks are posting higher than average volume for the day. Maybe there are other good ideas out there. The key limitation to doing anything too complex with it, is that you can’t ask for the quote for a day/time. Like, imagine what you could do for swing trading off daily charts if you could have a list of cells for the closing price for the last 50 days. Suddenly a whole wealth of technical indicators could be programmed in, spreadsheet-wise. And, every 20 minutes it would update. Kinda cool. If it’s all keyed to a symbol on the top row, just changing that symbol does the same analysis for a different stock, etc. But, it’s not quite there, yet.
You can get:
- price: market price of the stock - delayed by up to 20 minutes.
- priceopen: the opening price of the stock for the current day.
- high: the highest price the stock traded for the current day.
- low: the lowest price the stock traded for the current day.
- volume: number of shares traded of this stock for the current day.
- marketcap: the market cap of the stock.
- tradetime: the last time the stock traded.
- datadelay: the delay in the data presented for this stock using the googleFinance() function.
- volumeavg: the average volume for this stock.
- pe: the Price-to-Earnings ratio for this stock.
- eps: the earnings-per-share for this stock.
- high52: the 52-week high for this stock.
- low52: the 52-week low for this stock.
- change: the change in the price of this stock since yesterday’s market close.
- beta: the beta value of this stock.
- changepct: the percentage change in the price of this stock since yesterday’s close.
- closeyest: yesterday’s closing price of this stock.
- shares: the number of shares outstanding of this stock.
- currency: the currency in which this stock is traded.
December 4th, 2006 at 7:20 am
That would be a great way to do fundamental analysis on a company!
December 5th, 2006 at 11:02 am
Check out XLQ at http://www.qmatix.com - it is a tool I use every day and can do everything you talked about in your post and about 100x more than that within Excel. Combine XLQ, Excel and AAII’s Stock Investor Pro and you can do it all and add in fundamental data.
December 5th, 2006 at 11:34 am
What I really need is access to a real-time feed. With my background, I can program the stuff that products like qmatrix do without much trouble. I see they can connect to iqfeed, which I was considering buying. Real-time feeds are not cheap, though…
January 18th, 2007 at 9:49 am
If you dig into XLQ, you will find it buffers the google or msn data for later retrievial and keeps it up to date for your spreadsheet access and Check out the wild spreadsheets at http://www.wisertrader.com/excel.php
Runs a index momentum, industry, portfolio,market chart and a stock chart.
January 25th, 2007 at 8:42 pm
CAN THESE BE USED TO TRADE FUTURES
January 25th, 2007 at 10:32 pm
Looks like we’ve got another overcapitalized trader ;-) sheesh I never get TIRED of that joke.
Anyway, if by “THESE” you mean the google finance stuff, then no. If you meant the xlq stuff the other comments mentioned, I have no idea.
February 7th, 2007 at 5:58 pm
You know if is possible show index quote?
I try with ^IXIS symbol for example but not correct.
June 25th, 2008 at 12:45 pm
Richard, why don’t u pull the prices from the exchange website? that would be realtime.
June 25th, 2008 at 1:52 pm
Actually, Mac, they’ve just recently upgraded the google finance quotes so that they are real-time. If I were trading stocks, and didn’t have RadarScreen or similar, I would definitely be using this to screen for opportunities. Very cool.