[DocChat][Finance] Market Competitors Information Aggregation / 市場競爭對手資訊彙總
English / 中文
Goal：Utilize MediaTek Assistant for calculating and plotting data in xlsx files.
Reference File：N/A
The Prompt to MediaTek Assistant
Prompt 1
Please tell me the annual dividend for Apple's stock.
Prompt 2
Assuming you are a professional financial analyst, based on this data, could you provide me with the dividend and market capitalization for each company in 2023? Please present the information in a visual format that you deem appropriate as per your professional judgment.
Tips
Background: Analyzing an xlsx file with 2 sheets.
Cross-worksheet data calculation
Explain the results of the data calculation in a conversational manner.
MediaTek Assistant Output Result
Result1
Result2
目的：利用 MediaTek Assistant 對 xlsx 資料計算與繪圖
Reference File：N/A
提示 MediaTek Assistant 的範例
Prompt1
請告訴我每年蘋果的股利
Prompt2
假設你是一位專業的財務分析師，請根據這份資料，請給我 2023 年每個公司的股利及市值？呈現方式請依照您的專業判斷，選用適合的視覺化呈現方式
解題思路
請達對一份有 2 個 Sheet 的 xlsx 進行分析
跨工作表的資料計算
口語化的方式解釋資料計算結果
MediaTek Assistant 輸出結果範例
Result1
Result2
Related Use Case