On the fateful Wednesday of November 1st, 2017 Yahoo decided to stop their – until then – free service of delivering real time market data as a text stream through a special URL. For hundreds of businesses and individuals who had relied for years on Yahoo's benevolent free service, this single action meant only one thing: Instant death! Continue reading "Yahoo Finance Live Feeds in Excel after their API Discontinuation in November 2017"
Whereas the opinions on the usefulness of technical analysis are highly controversial, it is generally agreed that the fundamental analysis does make sense. Value investing, e.g. the choice of companies with low p/e and p/b coefficients but high RoE and EBIT-Margin is not an uncommon approach. However, the data quality and creative data interpretation are critical. Otherwise one yields yet another GiGo: Garbage in, Garbage out! Continue reading "Your Fundamental Analysis is Only as Good as Your Data are: The Example of NWL"
Two months ago we suggested you to buy a list of stocks, carefully selected from SP500 index on both fundamental and technical criteria. One month later we have published the results: though our stocklist has clearly beaten SPY there were no evidences of formal statistical significance. Now there are. Moreover, you have an opportunity to buy our next stockpicking report just for $10. Continue reading "What You Have Missed by Not Buying Our Stocklist for just $5 – Part II: Statistical significance"
One month ago we screened all stocks from SP 500 index and suggested busy investors to get rid of information overload and purchase our stock list just for 5 USD. Only a few investors considered our offer, which has brought about 3% return within a month, whereas SP 500 return stagnated around zero. Continue reading "What You Have Missed by Not Buying Our Stocklist for just $5"
Retail investors are overwhelmed with information. Meanwhile the payload of these numerous analytics and market reviews is zero or even negative. Is a passive investment in an index ETF a solution to this problem? Yes, but not necessarily the best one. We provide a short list of S&P 500 stocks with good fundamentals, low volatilities and correlations and nice charts from technical point of view. Continue reading "Investor, get rid of information overload!"
Elle keeps practicing to read the charts and recently she found a strong resistance level for DAX at 12600. So we partially went to cash, however, somewhat prematurely. We tried to turn this setback into an opportunity and bought Viacom (VIAB) stocks... which dropped by -6% today. Still we hold it for a fundamentally good investment and will keep the stock. Continue reading "JuniorDepot6a – Suboptimal Market Timing and 2nd Stockpicking Attempt with Viacom"
StockPup.com generously shares the fundamental data for several hundred stocks. However, there are a lot of outliers and missing data. We present some interesting results for the market summary and the long-term trends.
Continue reading "A Quick but Insightful Look at Stock Fundamental Data Summary"
Many "experts", at least in Germany, state nowadays: currently the markets are driven by macroeconomic factors (FED and ECB policies, quantitative easing, etc) thus the stock picking does not make sense. We show that it still does. Continue reading "Does Stock Picking Still Make Sense? Yes, it does!"
By current artificial intelligence, big data and robo-advisory hype many people believe that computers can do everything for you. I am pretty skeptical about it. Never denying (and actively engaging by myself) a computer-aided trading and investment I always claim "man and machine" rather than "man vs. machine". In this post I show you how to summarize and visualize the data from Alpha Vantage for 6356 American stocks. Continue reading "Visualizing the Data on 6356 American Stocks – with R source code"
Elle, a 7-year old girl, insisted last month on investing in GoPro. Now she has to learn the pain of losing money.
Continue reading "JuniorDepot5 – Learning Pain of Loss with GoPro Action"