Skip to main content
The sheets add-on -> https://workspace.google.com/marketplace/app/openkuber/228240472818 The Asahi Analysis Toolkit turns Google Sheets into a lightweight research workstation instantly generating research-style writeups, visual charts, portfolio diagnostics, backtests and sentiment analysis from the tickers you already keep in your sheet. Below is a single, complete blog post you can publish that explains the whole plugin workflow (based on your transcript) and uses the screenshots you provided as visual references.

​
Introduction

If your workflow lives in Google Sheets  a small watchlist, portfolio or a research notebook Asahi lets you go from raw tickers to actionable insights without bouncing between tabs. The plugin reads tickers from a range (e.g., A2:A10) and gives you multiple lenses: written summaries, charts, sentiment dashboards and portfolio-level recommendations. Use this guide to set up a clean sheet, generate analyses, interpret the outputs, and integrate them into your research process.

Write / View:

Auto-generate research summaries for tickers (Write writes into your sheet; View shows results without editing).

Graphs

Create charts (Revenue, EPS, P/E, peer comparisons, sentiment visuals).

Portfolio

Aggregate holdings to get buy/hold/sell guidance across fundamentals, technicals and sentiment.

Strategy

Compose & backtest trading/investment rules.

Feedback

Built-in form to help improve the toolkit.
Keep a simple, consistent layout so the plugin can detect data reliably:
A (Ticker)B (Qty)C (Buy Price)D (Notes)
AAPL10165.00Core holding
Tips:
  • Use one ticker per row and a header row.
  • If you plan to track P&L, include quantity and buy price columns.