Tag: Microsoft
-
A Market-Neutral Strategy
The work aims to solve the problem of Markowitz portfolio optimization for a one-year investment horizon through the pairs trading cointegrated strategy. Market-neutral trading strategies seek to generate returns independent of market swings to achieve a zero beta against its relevant market index. Statistical arbitrage (SA), pairs trading, and APO signals are analyzed. The study…
-
Practical SQL Queries, Cheat Sheets, and Interview Q&A for Data Scientists
Professionals aspiring for a career in data science must master SQL, a crucial skill. This comprehensive SQL server tutorial includes practical exercises, cheat sheets, interview Q&A tailored to data scientists, and installation requirements. From RDBMS basics to advanced concepts for data science interviews, this resource emphasizes the significance of SQL in database operations.
-
IQR-Based Log Price Volatility Ranking of Top 19 Blue Chips
The focus is on risk assessment of top blue chips. We determine market regimes using standard deviation (STD) of log-domain stock prices.
-
Blue-Chip Stock Portfolios for Quant Traders
This post delves into optimizing blue-chip stock portfolios using Python fintech libraries for private DIY self-traders. It includes steps for examining trading signals, comparing stock returns, performing analyses, and implementing forecast models. The content covers AAPL trading signals, risk vs. ROI analysis, a 4-stock portfolio, Monte-Carlo predictions, SPY return/volatility, and SPY Prophet forecast. The examples…
-
Automating Microsoft Excel Tasks & Reports with Python
The article provides a detailed guide on automating Excel tasks using Python and the Openpyxl library. It includes topics like Excel-to-Python data import, operations on Excel (like writing, creating new columns, new rows, and implementing formulas), working with worksheets, adding basic charts, and even formatting cells. However, advanced features like running macros and converting Excel…
-
ML Prediction of High/Low Video Game Hits with Data Resampling and Model Tuning
The post outlines a ML-based approach to forecast video game sales, using several techniques to enhance training, accuracy, and prediction. The Kaggle’s VGChartz dataset, containing sales data and other game-specific information, was used to build and refine the model. Several ML techniques including RandomForestClassifier and Logistic Regression yielded top predictors, with the critic’s score deemed…
-
Datapane Stock Screener App from Scratch
This content provides a quick guide for value investors to use the Datapane stock screener API in Python. It includes instructions for installation, importing standard libraries, setting the stock ticker, downloading stock Adj Close price, and creating visualizations. The post also describes how to build a powerful report using Datapane’s layout components.
-
A Closer Look at the Azure Cloud Portfolio – 1. Essentials
The article presents an extensive overview of Microsoft Azure services in comparison with Amazon Web Services (AWS) and Google Cloud Platform (GCP). It reveals that Azure’s cloud revenue for 2021 outperformed AWS and GCP combined, comprising nearly 80% of Fortune 500 companies as clients. The piece elaborates on Azure’s cloud concepts, Azure Synapse SQL Pool,…
-
LSTM Price Predictions of 4 Tech Stocks
The given content explains the process of using Exploratory Data Analysis (EDA) and Long Short-Term Memory (LSTM) Sequential model for comparing the risk/return of four major tech stocks: Apple, Google, Microsoft, and Amazon, considering the tech scenario in 2023. The analysis involves examining stock price patterns, their correlations, risk-return assessment, and predicting stock prices using…
-
Cloud-Native Tech Autumn 2022 Fair
Let’s dive deeper into the cloud-native tech trends and features to follow in Q4 2022 and beyond. Contents: Markets Services Serverless Cybersecurity DevSecOps ML/AI/IoT Use-Cases Events Training Explore More Infographic
-
Power BI for Data Scientists
Power BI is a business analytics tool that provides interactive data visualization capabilities, advanced analytics, and artificial intelligence. Power BI’s AI features include image recognition, text analytics, key driver analysis, and machine learning model building. It offers cloud-based services and a desktop-based interface, allowing data preparation, data discovery, and interactive dashboarding. Supported by Windows, Android,…
-
Technology Focus Weekly Update 16 Oct ’22
Get top data-driven technology highlights of the week: new SaaS products, tech business applications and learnings of the week: DevOps, DevSecOps, Cybersecurity, public cloud platforms (AWS/GCP/Azure), MarTech, ML/AI, MLOPs, NLP, edtech, e-courses, upcoming events, and related Infographics. Contents: DevOps November 8th, 2022 | 11 a.m. ET Providing reliable and secure services doesn’t just happen. Traditionally,…
-
Bear vs. Bull Portfolio Risk/Return Optimization QC Analysis
Based on the Portfolio Allocation and Optimization Algorithm discussed earlier and the related portfolio management, let’s run the Bear vs. Bull QC test of the portfolio P=[MSFT, AAPL, NDAQ] in terms of the Risk/Return Ratio (RRR). We have got a Sharpe ratio of less than one that is considered unacceptable or bad. The risk the…
-
Cloud-Native Tech Status Update Q3 2022
Cloud Computing Trends Q3 2022, market Share update key services IaaS PaaS FaaS Saas Cloud digital transformation all-the-way DevSecOps CI/Cd GitLab MLOps IoT Tech GCP gateway Big data Deloitte use-cases Stock markets Health Tech Cybersecurity Highlights Events Webinars AWS Storage E-training
Our Blogs 