> ## Documentation Index
> Fetch the complete documentation index at: https://blog.openkuber.com/llms.txt
> Use this file to discover all available pages before exploring further.

# How to use the Asahi Analysis

> Google Sheets complete guide

The sheets add-on -> [https://workspace.google.com/marketplace/app/openkuber/228240472818](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.

<Columns cols={3}>
  <Card title="Write / View:" href="https://blog.openkuber.com/Sheets-docs/write">
    Auto-generate research summaries for tickers (Write writes into your sheet; View shows results without editing).
  </Card>

  <Card title="Graphs" href="https://blog.openkuber.com/Sheets-docs/graphs">
    Create charts (Revenue, EPS, P/E, peer comparisons, sentiment visuals).
  </Card>

  <Card title="Portfolio" href="https://blog.openkuber.com/Sheets-docs/portfolio">
    Aggregate holdings to get buy/hold/sell guidance across fundamentals, technicals and sentiment.
  </Card>

  <Card title="Strategy" href="https://blog.openkuber.com/Sheets-docs/strategy">
    Compose & backtest trading/investment rules.
  </Card>

  <Card title="Feedback">
    Built-in form to help improve the toolkit.
  </Card>
</Columns>

## **Recommended sheet layout (before you begin)**

Keep a simple, consistent layout so the plugin can detect data reliably:

| **A (Ticker)** | **B (Qty)** | **C (Buy Price)** | **D (Notes)** |
| :------------- | :---------- | :---------------- | :------------ |
| AAPL           | 10          | 165.00            | Core holding  |

Tips:

* Use one ticker per row and a header row.
* If you plan to track P\&L, include quantity and buy price columns.