I'm creating a database schema for storing historical stock data. I currently have a schema as show below. My requirements are to store "bar data" (date, open, high, low, close volume) for multiple stock symbols. Each symbol might also have multiple timeframes (e.g. Google Weekly bars and Google Daily bars). My current schema puts th...
Got this question in an interview today, and its optimized solution stopped me cold (which blows, because I really wanted to work for this company...) Given a single array of real values, each of which represents the stock value of a company after an arbitrary period of time, find the best buy price and its corresponding best sell price...
i am on the process of building a website execlusively for trading purposes. including live quotes and level 2 quotes. charts. user protofollio with automatic updates. news and so on. am i allowed to use google finance tools on my website? and if yes how can i go about doing so? thanks in advance ...
I am developing a website where i want to show live stock updates for both bse and nse. Is it possible to show to show live updates? Is it free or do i have to pay something to bse pr nse for that matter. I also want to show the updates on my tv channel. Can anyone please tell me how to do it and what procedure i have to follow. ...
I'd like to be able to pass in a stock symbol and a date to pull in the closing price. Does anyone know of any good free api's? This is for non-commercial use if that matters. ...
I need to get the index of a exchange like NASDAQ rather than the price of a specific stock in that exchange. I suppose that Finance::Quote will come to the rescue , but after a quick go-through of the document, I find it the way one can use the module for query is like: %info = $q->fetch("australia","CML") which means both the ex...
Hi, For a learning exercise, i'm wanting to create candlestick (stock) graphs for stocks using zedgraph. Now on google finance, i can get daily open-high-low-close data which is perfect for making these graphs, but i'm wanting to create intra-day graphs, eg open-high-low-close data for an hour (or 5 mins, or 1 min even). Is there any w...
Hey, I would like to make an program that acts like a big filter for stocks. To do so, I need to have real-time (or delayed) quotes from the market. I started getting stock quotes by requesting pages from yahoo, accordingand parsing the html to the ticker, and parsing the html. I was wondering how to do this requesting and parsing html....
I'm building a web semantic project that gathers the maximum ammount of historic data about a certain company and tries to predict its future market stock values. For data I have the historic stock values (not normalized), news (0 to 1 polarity) and subjective content (also a 0 to 1 polarity). What is the best AI system to train and us...
Hi, I have a string of stock price data data and I want to be able to count how many days the price moves up or down lasted. So for example, from the data I have a used "if" functions to determine if a day was up or down: "U" for and Up day and "D" for a Down day. Lets say the string then looks like this: UUUDDUDUDUDUUU I want a for...
Hi, I'm writing a stock charting application on iPhone using core-plot. What kind of chart should I use to plot the volume chart? Since I will also need to overlay the price charts onto the volume chart, how should I go about doing this? Here's an image for reference (By no means am I trying to reimplement stockcharts functionality, jus...
Hi: Thanks for the answers, I have not used StackOverflow before so I was suprised by the number of answers and the speed of them - its fantastic. I have not been through the answers properly yet, but thought I should add some information to the problem specification. See the image below. I can't post an image in this because i don't ...
Hello, For one of our project, we need to pull huge real time stock data from 4 remote servers across two countries. The trivial process here, check the sources for a regular interval and save the update to database. But as these are real time stock data of more than 1000 companies, I have to pull every second, which isn't good in case...
Hi All, Below is the example I got from google finance for a stock quote. But it doesnt seem to be working. Stock price isnt displayed. Thanks <body> Hello world! Here is your portfolio:<br/> GOOG: <span id=_IG_SYM1_l></span> (<span id=_IG_SYM1_c></span>)<br/> AAPL: <span id=_IG_SYM2_l></span> (<span id=_IG_SYM2_c></span>)<br/> ...
If I am working on creating a watch list. What is the best way through DDE to get the name, volume, bid, ask, and last trade? I am going to be using Think or Swim's Desktop software, which only supports DDE. I am using NDDE. I am looking for an answer from this website: http://ndde.codeplex.com/Thread/View.aspx?ThreadId=63269 I am...
hi there! how do i (after getting the right stock prices from a source) show it on a "live graph". i'm looking for a php/ajax toolkit that allows me to create that graph live? is that the right thing to use or a flash based solution is better? are there 3rdparty sites that offer to create live graphs given input data? ...
I'm trying to build a financial iPhone app that has a stock search as one of its features. I noticed that the Bloomberg app (and the default Stock app) query online whenever they're looking for stocks. Does anyone know how they do this? I once built a PHP backend that queried the Yahoo Finance API using http requests but I doubt this i...
I'm looking for a web service similar to StrikeIron Zacks Company Profile. In particular I'm looking for company headquarters based on company name or stock ticker. If anyone knows where Google, Yahoo, or StrikeIron find this information, I would greatly appreciate it. Thanks in advance ...
I am creating a database schema to be used for technical analysis like top-volume gainers, top-price gainers etc.I have checked answers to questions here, like the design question. Having taken the hint from boe100 's answer there I have a schema modeled pretty much on it, thusly: Symbol - char 6 //primary Date - dat...
I need a (free or cheap) source for end-of-day stock/mutual funds/index values. Major world indexes & European stocks are my primary interest. I keep seeing that Yahoo/Google/Microsoft offer this data, yet I can't find a HOWTO doc (or similar) on getting the data. Reuters is an option - ~$300/month puts it out of my range. Sample of w...