62

"Things are the way they are because they got that way." - Gerald Weinberg Banks have been in business for a very long time. Yet, much of what we take for granted in terms of technology (capabilities, capacity, and cost) are relatively recent developments. Banks are often stuck on older platforms (mainframe, for instance) where the cost of redundant ...


38

The difference is that Yahoo is showing the unadjusted price that the security traded for on that date, while google is adjusting for price splits. This means that Google is showing how much you would have had to pay to get what is now one share. Since 1979, JNJ has split 3-for-1 once, and 2-for-1 four times. 3x2x2x2x2 = 48. If you bought 1 share at that ...


37

All the other answers here are correct, but I'll add one more perspective. I am a business architect at one of the world's largest retail banks. Every day I experience the frustration of trying to get large-scale corporate IT to do anything, so I feel that your question is just one facet of the wider question: "why are banks so old and busted?" While it's ...


19

There are several reasons to pay for data instead of using Yahoo Finance, although these reasons don't necessarily apply to you if you're only planning to use the data for personal use. Yahoo will throttle you if you attempt to download too much data in a short time period. You can opt to use the Yahoo Query Language (YQL), which does provide another ...


19

That info isn't in the credit card transaction data record. Keep and scan your receipts.


19

What you are positioning as a loan was not a loan at all. Your father bought something to be delivered in the future. Your aunt does not want to deliver it, so she should buy it back at whatever the current market value is. What is the price that your dad believes her share of the inheritance is currently worth? Is that based on actual appraisals and some ...


17

I would say a lot of the answers here aren't quite right. The main issue here is that banking is a highly oligopolous industry - there are few key players (the UK, for example, has only 5 major banks operating under a variety of brands: it's all the same companies underneath) and the market is very, very hard to enter owing to the immense regulatory burden. ...


14

One reason why they limit it is to protect you. If I hack your account, I get your entire financial history. I can see a copy of every check you ever wrote. I can see the account number with every doctor, utility, and credit card. I can also see the account information on the back of those checks for all your relatives who you sent $10 for their birthday. ...


12

United States For press releases about economic data, the Bureau of Economic Analysis press release page is helpful. Depending on the series, you could also look at the Bureau of Labor Statistics press release page. For time series of both historical and present data, the St. Louis Federal Reserve maintains a database such data, including numerous ...


10

I work on a buy-side firm, so I know how these small data issues can drive us crazy. Hope my answer below can help you: Reason for price difference: 1. Vendor and data source Basically, data providers such as Google and Yahoo redistribute EOD data by aggregating data from their vendors. Although the raw data is taken from the same exchanges, different ...


10

The answer in theory is yes. The answer in reality is no. Let me explain: IN THEORY A brokerage/trader like, take your pick: Charles Schwab, E*Trade, Scottrade, et cetera would certainly have a record of who bought and sold what through their system. The IRS would have records of sales that resulted in a taxable event Companies maintain what is called a ...


10

Although if you count only your data, it would be quite less 10 MB, multiply this by 1 million customers and you can see how quickly the data grows. Banks do retain data for longer period, as governed by country laws, typically in the range of 7 to 10 years. The online data storage cost is quite high 5 to 10 times more than offline storage. There are other ...


9

Yes, from June 1968 until December 1968, they closed the NYSE every Wednesday so they could catch up on paperwork representing billions of dollars in unprocessed transactions. Even after the NYSE re-opened on Wednesdays in January 1969, they still had to close it early at 2pm for seven more months. Forbes has a description of this: Not to be forgotten, ...


9

With no written agreement in place, the "right" rate is whatever both parties can agree to. I could argue that I could have invested the money in S&P 500 index funds and made about 9% annually over the last 15 years and the 15,000 would have been over 40,000. The "fair" rate would be whatever rate of return could have been expected from whatever your ...


8

There are several neat (and AFAICT completely undocumented) resources on NASDAQ's public FTP site. For your needs I would recommend: /SymbolDirectory/nasdaqlisted.txt = US Tape C equities /SymbolDirectory/otherlisted.txt = US Tape A/B equities (depending on the value of the ETF column) As for listings and delistings, I know I've seen those updated in /...


8

To add technical detail to other answers, your (and some commenters') estimates of storing that data is woefully (many orders of magnitude) off. Let's take your 10MB of transaction data per user. You're only estimating text records like in Quicken. Now add on the volume of storing everye check's image. That's 100K (if not 500Kb depending on resolution of ...


7

In common with many companies, Microsoft has been engaging in share buyback programmes, where it buys its own shares in the market and then cancels them. It's often a more tax-efficient way to distribute profits to the shareholders than paying a dividend. So there were more Microsoft shares in circulation in 1999 than there are now. See here for information.


7

For example, for a 100.000 loan with a 10% interest, basic logic would imply that you have to pay back 110.000. No. The interest rate is usually given per year, so for each year I owe you 100,000, I owe you an additional 10,000. But I don't owe you the full 100,000 all time long. If I pay you 20,000 at the end of the first year (10,000 interest and 10,000 ...


6

See the FX section of the quantitative finance SE data wiki. Foreign Exchange OANDA Historical Exchange Rates Converterhub Current/Historical Currency Rates Dukascopy - Historical FX prices; XML and CSV ForexForums Historical Data - Historical FX downloads via Amazon S3 GAIN Capital - Historical FX rates (in ZIP format)


6

To see a chart with 1-minute data for a stock on a specific date: Go to Trading Physics Enter the stock symbol in the "Stock ticker" field Select a date Select "1 Day" for the "Days on chart" field Click the Submit button For example, here is the chart for TWTR on November 7, 2013 - the day of the IPO: Here is the chart for TWTR on November 8, 2013 - its ...


5

Interactive Brokers provides historical intraday data including Bid, Ask, Last Trade and Volume for the majority of stocks. You can chart the data, download it to Excel or use it in your own application through their API. EDIT: Compared to other solutions (like FreeStockCharts.com for instance), Interactive Brokers provides not only historic intraday LAST**...


5

FreeStockCharts.com keeps some intra-day trading history. You have to create an account to look up individual stocks. Once you create a free account you can get intra-day trading history for the last month (Hourly for past month, 15 minutes for past week, 1 minute for past day). Going back past one month and it only keeps daily close history. Here is ...


5

Many good points have been brought up, and I'll just link to them here, for ease. Source: I work at a credit/debit card transaction processing company on the Database and Processing Software teams. 1. Security See mhoran_psprep's answer. 2. Tradition See Chris' answer. 3. System Integrity Believe it or not, banks don't expose their primary (or ...


5

The settlement date for any trade is the date on which the seller gets the buyer's money and the buyer gets the seller's product. In US equities markets the settlement date is (almost universally) three trading days after the trade date. This settlement period gives the exchanges, the clearing houses, and the brokers time to figure out how many shares and ...


5

The mathematics site, WolframAlpha, provides such data. Here is a link to historic p/e data for Apple. You can chart other companies simply by typing "p/e code" into the search box. For example, "p/e XOM" will give you historic p/e data for Exxon. A drop-down list box allows you to select a reporting period : 2 years, 5 years, 10 years, all data. Below ...


5

For MCD, the 47¢ is a regular dividend on preferred stock (see SEC filing here). Common stock holders are not eligible for this amount, so you need to exclude this amount. For KMB, there was a spin-off of Halyard Health. From their IR page on the spin-off: Kimberly-Clark will distribute one share of Halyard common stock for every eight shares of ...


5

The Minnesota Mining and Manufacturing Company was established in 1902 as a private company. It first raised public funds around 1903 but had a limited shareholder base. By around 1929, it was reported as being tradeable as an OTC (over-the-counter) stock but it's likely that shares were traded well before this. On 14 Jan 1946, the stock was listed on ...


5

There's often a legal basis to answer this question. For instance, Austria (guessing from your profile) currently uses a 4% Statutory interest rate. You'll need to dig up not just the actual but also the historical rates. Note that you'll want the non-commercial interest rate - some countries differentiate between loans to businesses and loans to ...


5

Trending indicators work well in strong trending markets. They're late in and late out. They're not effective in sideways markets because they will generate many false signals and whipsaws. Oscillating indicators generate more signals and they are best used in trading markets. However, more signals means more false signals and whipsaws. The problem ...


Only top voted, non community-wiki answers of a minimum length are eligible