Bill Bundle Posted December 5, 2012 Report Share Posted December 5, 2012 There's a lot of excel spreadsheets that I'm finding; so I might as well post them all in one thread. Here's the latest. Stock Valuation and Analysis Spreadsheet Website: http://smartstockresearch.com/InvestingBasics/Articles/Stock-Analysis-Spreadsheet.html Download: http://www.keepandshare.com/doc/2269667/ssr-free-stock-analysis-spreadsheet-xlsx-september-28-2010-8-46-pm-95k?da=y bobaloo and thankyou 2 Quote Link to comment Share on other sites More sharing options...
Bill Bundle Posted December 5, 2012 Author Report Share Posted December 5, 2012 Obtaining Stock Prices in Excel Quote Link to comment Share on other sites More sharing options...
Bill Bundle Posted December 5, 2012 Author Report Share Posted December 5, 2012 Live Stock Quotes in Microsoft Excel This video is Part 1 of a series of tutorials on stock quote spreadsheets; so go to YouTube to http://www.youtube.com/user/ExcelisHell for more. Website: http://www.teachmsoffice.com/ Quote Link to comment Share on other sites More sharing options...
Bill Bundle Posted December 5, 2012 Author Report Share Posted December 5, 2012 A Truck Load of Spreadsheets More free financial spreadsheets than you can use in one lifetime. http://www.exinfm.com/free_spreadsheets.html Quote Link to comment Share on other sites More sharing options...
Bill Bundle Posted December 5, 2012 Author Report Share Posted December 5, 2012 Stock Watch Website: http://breaktru.com/stock.html Download: http://www.breaktru.com/stock.zip . http://www.breaktru.com/images/stockwatch2.gif . Get on-line quotes from: CNN.com Quicken.com Quote.com NASDAQ.com MoneyCentral.com Toronto (Yahoo) Yahoo India Yahoo Hong Kong Yahoo Deutschland Quote Link to comment Share on other sites More sharing options...
Bill Bundle Posted December 5, 2012 Author Report Share Posted December 5, 2012 (edited) MS Excel Fundamental and Technical Stock Analysis Using Data from Finviz.com Website: http://www.magic-broker.com/index.php?option=com_jdownloads&Itemid=7&view=viewdownload&catid=3&cid=2 . http://www.youtube.com/watch?v=vJa5UKkk76M Edited December 5, 2012 by Bill Bundle Quote Link to comment Share on other sites More sharing options...
Bill Bundle Posted December 5, 2012 Author Report Share Posted December 5, 2012 Creating a Price/Volume Chart in Excel http://www.youtube.com/watch?v=8lo9WnKlsKI Quote Link to comment Share on other sites More sharing options...
Bill Bundle Posted December 5, 2012 Author Report Share Posted December 5, 2012 How to create Stock chart in Excel 2010 Quote Link to comment Share on other sites More sharing options...
Bill Bundle Posted December 5, 2012 Author Report Share Posted December 5, 2012 Excel Trading Tool Free Excel Trading Tool Website: http://www.vbafin.com/ Download: http://www.vbafin.com/documents/Unreal.xls .http://www.youtube.com/watch?v=Sqqn7JbMnAI Quote Link to comment Share on other sites More sharing options...
Bill Bundle Posted December 5, 2012 Author Report Share Posted December 5, 2012 Stock Analysis by Gummy Website: http://www.financialwebring.org/gummy-stuff/Stock-Analysis.htm Download: http://www.financialwebring.org/gummy-stuff/Excel/stock-analysis.xls . http://www.financialwebring.org/gummy-stuff/images/stock-analysis-SS.gif Quote Link to comment Share on other sites More sharing options...
Bill Bundle Posted December 5, 2012 Author Report Share Posted December 5, 2012 (edited) Creating Automated Trading System in Excel . Website: http://www.spreadsheetml.com/automatedstocktradingsystem/index.shtml Download: http://www.spreadsheetml.com/automatedstocktradingsystem/AutomatedStockTradingSystem.zip Documentation: http://www.spreadsheetml.com/automatedstocktradingsystem/Creating%20an%20Automated%20Stock%20Trading%20System%20in%20Excel.pdf Edited December 5, 2012 by Bill Bundle newbie0101, Bucast and indo37 3 Quote Link to comment Share on other sites More sharing options...
Bill Bundle Posted December 5, 2012 Author Report Share Posted December 5, 2012 Technical Indicators in Excel Spreadsheet- Free Addons Website: http://www.marketcalls.in/spreadsheet/technical-indicators-in-excel-spreadsheet-free-addons.html Homepage: http://ta-lib.org/hdr_dw.html Download: http://prdownloads.sourceforge.net/ta-lib/ta-lib-0.4.0-msvc.zip Documentation: http://ta-lib.org/excel_doc.html List of Available Indicators in the form of funtions AD – Chaikin A/D Line ADOSC – Chaikin A/D Oscillator ADX – Average Directional Movement Index ADXR – Average Directional Movement Index Rating APO – Absolute Price Oscillator AROON – Aroon AROONOSC – Aroon Oscillator ATR – Average True Range AVGPRICE – Average Price BBANDS – Bollinger Bands CCI – Commodity Channel Index CORREL – Pearson’s Correlation Coefficient ® DEMA – Double Exponential Moving Average DX – Directional Movement Index EMA – Exponential Moving Average HT_DCPERIOD – Hilbert Transform – Dominant Cycle Period HT_DCPHASE – Hilbert Transform – Dominant Cycle Phase HT_PHASOR – Hilbert Transform – Phasor Components HT_SINE – Hilbert Transform – SineWave HT_TRENDLINE – Hilbert Transform – Instantaneous Trendline HT_TRENDMODE – Hilbert Transform – Trend vs Cycle Mode KAMA – Kaufman Adaptive Moving Average LINEARREG – Linear Regression LINEARREG_ANGLE – Linear Regression Angle LINEARREG_INTERCEPT – Linear Regression Intercept LINEARREG_SLOPE – Linear Regression Slope MA – All Moving Average MACD – Moving Average Convergence/Divergence MACDEXT – MACD with controllable MA type MACDFIX – Moving Average Convergence/Divergence Fix 12/26 MAMA – MESA Adaptive Moving Average MAX – Highest value over a specified period MEDPRICE – Median Price MFI – Money Flow Index MIDPOINT – MidPoint over period MIDPRICE – Midpoint Price over period MIN – Lowest value over a specified period MINUS_DI – Minus Directional Indicator MINUS_DM – Minus Directional Movement MOM – Momentum OBV – On Balance Volume PLUS_DI – Plus Directional Indicator PLUS_DM – Plus Directional Movement PPO – Percentage Price Oscillator ROC – Rate of change : ((price/prevPrice)-1)*100 ROCP – Rate of change Percentage: (price-prevPrice)/prevPrice ROCR – Rate of change ratio: (price/prevPrice) ROCR100 – Rate of change ratio 100 scale: (price/prevPrice)*100 RSI – Relative Strength Index SAR – Parabolic SAR SAREXT – Parabolic SAR – Extended SMA – Simple Moving Average STDDEV – Standard Deviation STOCH – Stochastic STOCHF – Stochastic Fast STOCHRSI – Stochastic Relative Strength Index T3 – Triple Exponential Moving Average (T3) TEMA – Triple Exponential Moving Average TRANGE – True Range TRIMA – Triangular Moving Average TRIX – 1-day Rate-Of-Change (ROC) of a Triple Smooth EMA TSF – Time Series Forecast TYPPRICE – Typical Price VAR – Variance WCLPRICE – Weighted Close Price WILLR – Williams’ %R WMA – Weighted Moving Average newbie0101 and indo37 2 Quote Link to comment Share on other sites More sharing options...
Bill Bundle Posted December 5, 2012 Author Report Share Posted December 5, 2012 FRED Add-In for Microsoft Excel Federal Reserve Economic Data (FRED) Add-In is free software Website with download: http://research.stlouisfed.org/fred-addin/ . http://www.youtube.com/watch?v=OAH-wGtP_k8 newbie0101 1 Quote Link to comment Share on other sites More sharing options...
Bill Bundle Posted December 5, 2012 Author Report Share Posted December 5, 2012 Visual Basic Code For Excel Stock Indicators Website: http://exceltrader.net/ MACD VBA: http://exceltrader.net/470/macd-vba/ Stochastics VBA: http://exceltrader.net/506/stochastics-indicator-vba-and-formula-versions/ newbie0101 1 Quote Link to comment Share on other sites More sharing options...
indo37 Posted December 6, 2012 Report Share Posted December 6, 2012 Thanks Bill, well done! Kind regards Quote Link to comment Share on other sites More sharing options...
yc0137 Posted December 6, 2012 Report Share Posted December 6, 2012 Thank Bill! Quote Link to comment Share on other sites More sharing options...
Bill Bundle Posted December 10, 2012 Author Report Share Posted December 10, 2012 (edited) Excel As A Real Time Data Source For Amibroker Amibroker Tech Support: http://finance.groups.yahoo.com/group/amibroker/ This utility developed by Josh. If your trading terminal supports RTD or link to excel then this utility helps to get LIVE data to Amibroker. It's FREE and opensource utility. The video tutorial shows about how to get live data to Amibroker. This utility also gets live data from google and yahoo. It also provides feature to backfill data to Amibroker. Any questions, contact the developer. Discussion Thread: http://www.traderji.com/data-feeds/70159-realtime-data-now-odin-tradetiger-google-yahoo-amibroker-fcharts-qtstalker.html . . Alternate Download: http://www.4shared.com/zip/CmWa_Jkr/RTNOW.html Proceedure: http://www.traderji.com/data-feeds/70159-realtime-data-now-odin-tradetiger-google-yahoo-amibroker-fcharts-qtstalker-11.html#post693333 Also there's another method described in Using Excel as a DDE Server http://www.mail-archive.com/[email protected]/msg24328.html Edited December 12, 2012 by Bill Bundle indo37 1 Quote Link to comment Share on other sites More sharing options...
Bill Bundle Posted December 11, 2012 Author Report Share Posted December 11, 2012 Determine Your Portfolio Value in Excel Using Live Stock Quotes Quote Link to comment Share on other sites More sharing options...
Bill Bundle Posted December 12, 2012 Author Report Share Posted December 12, 2012 Excel/VBA Automated Trading Platform Website: http://exceltrader.net/atsxls-ib-automated-trading-charting-and-backtesting/ . indo37 1 Quote Link to comment Share on other sites More sharing options...
indo37 Posted December 13, 2012 Report Share Posted December 13, 2012 Thanks. Unfortunately it`s USD 89,00!!! Thanks again, Bill Quote Link to comment Share on other sites More sharing options...
thankyou Posted December 13, 2012 Report Share Posted December 13, 2012 Thanks Bill, You have uploaded so many excel goodies here. Got to be testing some of these. Thanks. Real pleasure to have so many of these. Quote Link to comment Share on other sites More sharing options...
Bill Bundle Posted December 13, 2012 Author Report Share Posted December 13, 2012 Thanks. Unfortunately it`s USD 89,00!!! Thanks again, Bill Maybe there's an educated version somewhere and we just haven't found it yet? Quote Link to comment Share on other sites More sharing options...
FXWallabie Posted December 15, 2012 Report Share Posted December 15, 2012 Hi Bill Bundle; I congratulate you for the high quality of yours posts. Thanks. Quote Link to comment Share on other sites More sharing options...
FXWallabie Posted December 15, 2012 Report Share Posted December 15, 2012 Hi; I believe that this soft is very interesting: AnalyzerXL (add-in for Excel). In this soft is possible download Historical data of Stocks, Indices and Commodities, all EOD. Also work real time, with RTQuotes XL, building a Quotecenter with this data in real time (yahoo subscription, and free delayed 15 min) The web site is: http://www.analyzerxl.com/ Quote Link to comment Share on other sites More sharing options...
Bill Bundle Posted December 15, 2012 Author Report Share Posted December 15, 2012 (edited) Technical Analysis in Excel Spreadsheet- Free Addons This addin is different from the "Technical Indicators in Excel Spreadsheet- Free Addons" that I previously posted. The programming genius that developed this addin has a tech support forum in the Yahoo! smf_addin · EXCEL Stock Market Functions Add-in Group. If you have programming background, you'll enjoy learning about this addin and its abundant possibilities of application. Its free data sources come from places that you would never expect with fundamental, technical and economic data that you can update with a click of your mouse. This is a cornicopia of possibilities of programming, market analysis and portfolio tracking. Participating in all this deep analytics can really suck up your time; but you can enjoy the hell out of it with all the examples that are posted in the file section to help your programming design. You'll discover a whole new universe of using MS Excel for your market analysis and get free help from some of the best programmers in the business. You can use both the Tech Indicator add-in and the Tech Analysis add-in together in the same spreadsheet. The free Add-in can be found in the file page of his forum. Yahoo! smf_addin · EXCEL Stock Market Functions Add-in http://finance.groups.yahoo.com/group/smf_addin/ and you may need Visual Basic help from Yahoo! xltrader http://tech.groups.yahoo.com/group/xltraders/ Edited December 16, 2012 by Bill Bundle Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.