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 ...
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...
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! ...
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. ^^ ...
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...
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'...
can anyone provide me an example on how I can fetch the real-time stocks of google finance ...
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? ...
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...
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...
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 ...
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...
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...
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...
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...
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...
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...
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. ...
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). ...
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. ...