Intelligent AI Data agent

#devchallenge #runnerhchallenge #ai #machinelearning

This is a submission for the Runner H "AI Agent Prompting" Challenge

What I Built

Get the insights and data to invest in a smart way! Runner H is capable of simulating the action of going to CoinMarketCap, organizing the data in descending order and starting to explore the top 10. Likewise, it enters the X account of each project with the intention of obtaining their followers and following. All of this is summarized and added to an Excel file to view information quickly and consolidated.

Demo

runner.hcompany.ai

How I Used Runner H

Runner H is capable of simulating the action of going to CoinMarketCap, organizing the data in descending order and starting to explore the top 10. Likewise, it enters the X account of each project with the intention of obtaining their posts and interactions. All of this is summarized and added to an Excel file to view information quickly and consolidated.

Below is a step-by-step guide which explains how the agent works:

## Step 1: Access and Sort the DeFi Page
- Open your web browser and navigate to the following URL: https://coinmarketcap.com/view/defi/.
- Locate the sorting option on the page (typically found near the column headers).
- Sort the list by "Volume" in descending order (highest to lowest) to identify the top-performing DeFi assets based on trading volume.

## Step 2: Extract Data from the Top 10 Assets
- From the sorted list, identify the first 10 assets.
- For each of these assets, click on their respective links to visit their individual pages.
- On each asset's page, gather the following information:
  - **Market Cap**: The total market capitalization of the asset.
  - **Volume**: The 24-hour trading volume.
  - **Price**: The current price of the asset.
  - **Project Name**: The official name of the project.
  - **How It’s Used**: A brief description of the project’s purpose or utility (e.g., decentralized finance applications, staking, etc.).
- Calculate the **Percentage Change of Volume** for each asset over the last 24 hours (this data is often available on the page; note the change and determine if it’s positive or negative).
- Create a column labeled **Percentage Indicator** and mark it as "Positive" or "Negative" based on the volume change.

## Step 3: Gather Additional Information from the About Page
- For each of the 10 assets, modify the URL https://coinmarketcap.com/currencies/[symbol]/#About by replacing [symbol] with the asset’s unique symbol (e.g., https://coinmarketcap.com/currencies/uni/#About for Uniswap).
- Visit each modified URL and extract:
  - **About Title**: The title or headline of the "About" section.
  - **About Description**: A summary or detailed explanation of the project from the "About" section.

## Step 4: Create and Populate a Google Sheets Document
- Open Google Sheets and create a new spreadsheet.
- Name the first tab "DeFi_Analysis".
- Set up the following columns in the first row:
  - Symbol
  - Volume
  - Percentage Change
  - Percentage Indicator
  - Market Cap
  - Price
  - About Title
  - About Description
- Enter the collected data for each of the 10 assets into the corresponding rows under these columns.

## Step 5: Collect Twitter Information
- For each of the 10 assets, visit their official Twitter (X) profiles (links are often provided on their CoinMarketCap pages or through a quick search).
- Record the following details:
  - **Twitter Handle**: The asset’s official Twitter username (e.g., @Uniswap).
  - **Followers**: The number of followers the account has.
  - **Following**: The number of accounts the asset follows.
- Create a new tab in the same Google Sheets document and name it "Twitter_Data".
- Set up the following columns in the first row of the "Twitter_Data" tab:
  - Symbol
  - Twitter Handle
  - Followers
  - Following
- Enter the collected Twitter data for each of the 10 assets into the corresponding rows.

## Step 6: Review and Save
- Double-check all entered data for accuracy across both tabs.
- Save the Google Sheets document with a descriptive name (e.g., "DeFi_Analysis_2025-07-05") to ensure easy access for future reference.

Use Case & Impact

Both investors and developers benefit from this agent as it saves them a lot of time by not having to search and go page by page identifying what's new in trending. With the exploration, it obtains important information to identify the relevance of the project as well as the activity on X, knowing if they are projects that are working actively and avoiding making an incorrect decision based on price hype but taking into account price data and interactions.