How do I export or sync data from TD Ameritrade into Google Finance or another online Finance site?
"Mint is one alternative. If you want the raw data in CSV format, you can use ""Export"" feature under"
Google Finance gives you this information. even in Bloomberg intraday data you're limited to 140days. If you want more you need cash, a lot of cash. Just the sheer size of data is ridiculous. Unless you're Blackrock or some big firms like that then probably can't afford to buy it and store it - it won't fit on one Excel file haha This would be a nice Raspberry Pi project for Mathematica, which comes bundled free on the Raspbian OS. You can program it up and leave it running.  It's not expensive and doesn't use much power. A program to monitor stock prices or volume could be written as simply as :-  This checks the volume of trades of Oct 2014 US crude oil futures every 30 seconds and sends an email if the volume jumps by more than 100. The financial data in this example is curated from Yahoo.  If specific data is not available or not updated frequently enough, if you can find an alternative online data source it's usually possible read the data in.  For example, this is apparently real-time data :- {Crude Oil, 92.79, -0.67, -0.71%} After leaving the above program running while writing this the volume of trades has risen like so :-  Edit I just set this running on a Raspberry Pi.  I had to use gmail for the email setup as described in this post: Configuring Mathematica to send email from a notebook.  Anyway, it's working.  Hope I don't get inundated with emails. ;-) "For US equities, Edgar Online is where companies post their government filings to the SEC. On Google Finance, you would look at the ""SEC filings"" link on the page, and then find their 10K and 10Q documents, where that information is listed and already calculated. Many companies also have these same documents posted on their Investor Relations web pages." I use Yahoo Finance to plot my portfolio value over time. Yahoo Finance uses SigFig to link accounts (I've linked to Fidelity), which then allows you to see you exact portfolio and see a plot of its historical value. I'm not sure what other websites SigFig will allow you to sync with, but it is worth a try. Here is what the plot I have looks like, although this is slightly out of date, but still gives you an idea of what to expect. "I keep spreadsheets that verify each $ distribution versus the rate times number of shares owned. For mutual funds, I would use Yahoo's historical data, but sometimes shows up late (a few days, a week?) and it isn't always quite accurate enough. A while back I discovered that MSN had excellent data when using their market price chart with dividends ""turned on,"" HOWEVER very recently they have revamped their site and the trusty URLs I have previously used no longer work AND after considerable browsing, I can no longer find this level of detail anywhere on their site !=( Happily, the note above led me to the Google business site, and it looks like I am ""back in business""... THANKS!" "Save the effort.  For personal finance purpose, just use the simple tools.  For example, if you like P&G very much but you want to diversify with ETF, use: http://etfdb.com/stock/PG/ https://www.etfchannel.com/finder/?a=etfsholding&symbol=PG Pick a ETF with highest weighting. Replace ""PG"" in the link with other tickers." You can easily build a Google Sheet spreadsheet to track what you want as Sheet has a 'googlefinance()' function to look-up the same prices and data you can enter and track in a Google Finance portfolio, except you can use it in ways you want. For example, you can track your purchase price at a fixed exchange rate, track the current market value as the product of the stock's price times the floating exchange rate, and then record your realized profit and loss using another fixed exchange rate.  You don't have to record the rates either, as googlefinance() func is able to lookup prices as of a particular date. You can access Google Sheet through a web browser or Android app. It looks like GOOG did not have a pre-market trade until 7:14 am ET, so Google Finance was still reporting the last trade it had, which was in the after-hours session yesterday. FB, on the other hand, was trading like crazy after-hours yesterday and pre-market today as it had an earnings report yesterday. "There needs to be a buyer of the shares you are offering.  There are a lot of feature rich options for buying and selling.  I don't understand them all in depth, but for example on TD Ameritrade here are some of the order types ""Limit"", ""Market"", ""Stop Market"", ""Stop Limit"", ""Trailing Stop %"", ""Trailing Stop $"".  This web page will explain the different order types https://invest.ameritrade.com/cgi-bin/apps/u/PLoad?pagename=tutorial/orderTypes/overview.html Stock with a higher volume will allow your trade to execute faster, since there are more frequent trades than stocks with lower volume. (UPDATE: More specifically, not more frequent trades, but more shares changing hands.) I'm a bit of a noob myself, but that's what I understand." "If you're looking to generate your own charts, you can get up-to-date TSP fund share prices in a Google Docs spreadsheet by ""scraping"" the data from the HTML of certain TSP webpages. You'll need to do this because the GoogleFinance function does not recognize ""private"" funds or collective trusts like those of the TSP. See this thread for tips: Bogleheads • View topic - GoogleFinance price quotes for TSP Funds" Bloomberg is really just a huge database.  You can look up just about anything you need to know.  Launchpad is much better than the old NW market monitors.  The Excel API is useful.  If it wasn't where all my brokers are I would consider something different like Eikon.  It has some limitations but it's a useful system and parts of my job would be a pain without it. "Considering the fact that you are so unaware of how to find such data, I find it very very hard to believe that you actually need it. ""All trade and finance data for as much tickers and markets as possible."" Wtf does that even mean. You could be referencing thousands of different types of data for any given ""ticker"" with a statement so vague. What are you looking for?" I dont know if this data is available for the 1980s, but this response to an old question of mine discusses how you can pull stock related information from google or yahoo finance over a certain period of time. You could do this in excel or google spreadsheet and see if you could get the data you're looking for.  Quote from old post: Google Docs spreadsheets have a   function for filling in stock and fund   prices. You can use that data to graph (fund1   / fund2) over some time period. "To expand on keshlam's answer: A direct feed does not involve a website of any kind.  Each exchange publishes its order/trade feed(s) onto a packet network where subscribers have machines listening and reacting. Let's call the moment when a trade occurs inside an exchange's matching engine ""T0"".  An exchange then publishes the specifics of that trade as above, and the moment when that information is first available to subscribers is T1.  In some cases, T1 - T0 is a few microseconds; in other (notorious) cases, it can be as much as 100 milliseconds (100,000x longer). Because it's expensive for a subscriber to run a machine on each exchange's network -- and also because it requires a team of engineers devoted to understanding each exchange's individual publication protocols -- it seems unlikely that Google pays for direct access.  Instead Google most likely pays another company who is a subscriber on each exchange around the world (let's say Reuters) to forward their incoming information to Google.  Reuters then charges Google and other customers according to how fast the customer wants the forwarded information.  Reuters has to parse the info it gets at T1, check it for errors, and translate it into a format that Google (and other customers) can understand.  Let's say they finish all that work and put their new packets on the internet at time T2. Then the slow crawl across the internet begins.  Some 5-100 milliseconds later your website of choice gets its pre-processed data at time T3.  Even though it's preprocessed, your favorite website has to unpack the data, store it in some sort of database, and push it onto their website at time T4. A sophisticated website might then force a refresh of your browser at time T4 to show you the new information.  But this forced refresh involves yet another slow crawl across the internet from where your website is based to your home computer, competing with your neighbor's 24/7 Netflix stream, etc.  Then your browser (with its 83 plugins and banner ads everywhere) has to refresh, and you finally see the update at T5. So, a thousand factors come into play, but even assuming that Google is doing the most expensive and labor-intensive thing it can and that all the networks between you and Google and the exchange are as short as they can be, you're not going to hear about a trade -- even a massive, market-moving trade -- for anywhere from 500 milliseconds to 5 seconds after T0.  And in a more realistic world that time will be 10-30 seconds. This is what Google calls ""Realtime"" on that disclaimer page, because they feel they're getting that info to you as fast as they possibly can (for free). Meanwhile, the computers that actually subscribe to an exchange heard about the trade way back at time T1 and acted on that information in a few microseconds.  That's almost certainly before T2 and definitely way way before T3.  The market for a particular instrument could change direction 5 times before Google even shows the first trade. So if you want true realtime access, you must subscribe to the exchange feed or, as keshlam suggests, sign up with a broker that provides its own optimized market feeds to you. (Note: This is not an endorsement of trading through brokers.)"