stocks

How can I use Math::Business::EMA with DBI to calculate exponential moving averages in Perl?

Script pulls data from mysql: $DBI::result = $db->prepare(qq{ SELECT close FROM $table WHERE day <= '$DATE' ORDER BY day DESC LIMIT $EMA }); $DBI::result->execute(); while($row = $DBI::result->fetchrow) { print "$row\n"; }; with the following example results: 1.560 1.560 1.550... But I need to work out ...

using Excel VBA, given the daily price of 50 stocks, choose 10 stocks such that they have the minumum correlation

The high-level goal is to choose 10 stocks that have the lowest correlation among one another, out of a pool of 50, so that I can have a well-diversified portfolio. I have managed to write some VBA macro to download the past 3 years of daily price data from Yahoo finance, and then compute the 50x50 correlation matrix (using the Correl f...

What are some javascript charting libraries that allow plotting stock prices?

I need to be able to represent high and lows using a javascript charting libraries. All the libraries I have seen only allow defining the "high" value and the low value is always defaulted to zero. Thanks! ...

Automating Etrade

Hey everyone, I was wondering how would I start programming an interface to trading stocks in Etrade in python. I am attempting to make an automated trading bot, but there is no api publicly available for automated trading with Etrade. Thanks in advance. ^^ ...

Adding / Removing values for an Email based daily stock value reporter - made inPHP

Hi, i'm buidling a very simple email based website that users can, when registering list out all the stocktickers they're intersted in following. The program then on a daily basis goes and fetches that information and sends it out to every user. i have the portion which fetchs the information from the stock websites, but i'm looking for...

Launch Apple's Stocks app, with a particular stock selected

I would like to launch Apple's Stocks app to show information for a particular stock, on a non-jailbroken phone. I'm not interesting in how to get a quote or graph a stock myself, just opening Stocks.app. I was hoping that the Stocks app would have a custom URL format, so opening a URL like stocks://AAPL would do the trick. But I haven'...

fetch google finance data

can anyone provide me an example on how I can fetch the real-time stocks of google finance ...

Development Platforms for Financial modeling (What do the Quants use?)

Quantitative Analysts or "Quants" predict the behavior of markets to maximize profits. I am interested in the software that they use to accomplish this. Are there development platforms, libraries, languages or Data Mining suites specifically tailored to Financial Modeling? ...

Is there an API that I can use to get historical and recent EOD stock quotes?

Hey I just need the link for the API that Google/Yahoo have (I know they have it but I cant find the link) that I can use to get historical and recent End of day stock quotes. For example I want to be able to query the quote for MSFT on Jan 15,2009 and get the moving averages and 52 week highs, etc. Can anyone point them out to me? Thank...

Where can I trade on the Stock Market via API?

Possible Duplicate: Real life trading API I have made an interactive stock trading system, and want to try it out with real money. Can anyone suggest a place where I could hook my system up to an API and make trades? Ideally, it would also have a testing area where I could test it with their api for a while, before going liv...

How to calculate realized P&L of stock trades using the FIFO method in Python?

I'm looking for a Python plugin that would calculate the realized P&L for a number of stock transactions using the FIFO method. For example, assume we have the following three MSFT trades : +75 MSFT 25.10 +50 MSFT 25.12 -100 MSFT 25.22 The sell of 100 shares at 25.22 would fully net against the buy of 75 at 25.10 and partially net ...

Are document databases good for storing large amounts of Stock Tick data?

I was thinking of using a database like mongodb or ravendb to store a lot of stock tick data and wanted to know if this would be viable compared to a standard relational such as Sql Server. The data would not really be relational and would be a couple of huge tables. I was also thinking that I could sum/min/max rows of data by minute/ho...

Multiple OHLC datasets in one image

How can I chart multiple datasets in one image using JFreeChart ? Essentially I want to chart a stock's price and it's moving average line in one image. I've tried getting the XYPlot and adding the second dataset, but it does not work. DefaultOHLCDataset dataset = new DefaultOHLCDataset(symbol, items); DefaultOHLCDataset dataset2 = ne...

Stock purchases and stock quote data

I apologize for being rather vague here, but I'm working on a project involving stock data and stock purchases. I'm sure I'm going to end up having to get a broker involved, but I was wondering if anyone knows of any documentation on the underlying technology involved with existing trading sites, as well as the channels through which sys...

Is there a World-Wide Stock Market real-time quotes Application Programming Interface (API)?

Hi there, I'm looking for an Application Programming Interface which will allow me to access quotes and other data about multiple company symbols for at least the following stock exchanges: American Stock Exchange (AMEX) Australian Stock Exchange (ASX) Bank of Canada Bombay Stock Exchange (BOM) Canadian Venture Exchange (CVE) Euronex...

Getting a stock's price history

Are there any simple HTTP APIs out there which will let me get the stock price for a symbol (such as GOOG) at a specific date and time? Something like... http://somewebsite.com/? symbol=GOOG& year=2010& month=7& day=30& hour=4& minute=00 Giving a response of $484.85 I'm hoping to have an end result of a haske...

Possible to make a consistently successful stock market playing bot?

Who has created a bot to play the stock market and what kind of return did you see? I'm currently still in very alpha stages but I can play the stock market with play money and get some very nice results using historical real time data. Currently I have around 8 parameters that go into configuring the buy and sell function. When I varied...

Is there anywhere to get a free stockmark data feed/dump?

The Stock Market world seems to almost be as fragmented as our nation's Real Estate Fiefdoms. At any rate, are there any providers of free data dumps, API's, or feeds related to stocks or commodities? Delay time isn't important. ...

Anyone know how to get historical stock data for free in ASP.NET?

I'm looking for an API that can be accessed via C# implementation where I can get access to free stock market historical information (index and individual companies). ...

Protocols used by stock exchanges

My career goal is to work as a software developer for an online stock broker website or for a stock exchange. I am curious about the protocols used by the stock network. For example, what protocol does an online stock broker website use to send a sell order to a stock exchange? Thanks. ...