Tong Quan Tai San
Cap nhat real-time •
Tong Gia Tri Tai San
$0
+0.00%
Loi Nhuan Rong
$0
+0.00%
Thanh Khoan
0.00%
Khoe manh
Da Dang Hoa
0.0
Xuat sac
Xu Huong Gia Tri Tai San
12 thang qua
Phan Bo Danh Muc
Theo loai tai san
Phan Bo Theo Loai
Phan Bo Theo Rui Ro
0.0%
ROI (Return on Investment)
+0.0% so voi nam ngoai
0.00
Sharpe Ratio
Tot
0.0%
Bien Dong (Volatility)
Thap
Diem Rui Ro Danh Muc
Dua tren phan tich VaR & Stress Test
7.2
/ 10
Value at Risk (95%)-$2.4M
Maximum Drawdown-8.5%
Beta (vs S&P 500)0.85
Correlation0.62
Phan Tich Thanh Khoan
Kha nang chuyen doi thanh tien mat
Danh Sach Tai San Chi Tiet
Tat ca cac loai tai san trong danh muc
| Tai San | Loai | Gia Tri Hien Tai | Gia Goc | Lai/Lo | Ty Suat | Thanh Khoan | Xu Huong | Cap Nhat |
|---|
Ket Noi Du Lieu Real-time
Tich hop Google Sheets de cap nhat so lieu tu dong
Dashboard nay duoc thiet ke de ket noi voi Google Sheets. Duoi day la huong dan tich hop de dong bo du lieu tu dong:
1
Tao Google Sheet
Tao mot Google Sheet voi cac cot: Ten Tai San | Loai | Gia Tri | Gia Goc | Ngay Cap Nhat. Chia se sheet o che do "Anyone with link can view".
2
Lay Sheet ID
Copy Sheet ID tu URL. Vi du: trong
docs.google.com/spreadsheets/d/SHEET_ID/edit, phan SHEET_ID chinh la ID can lay.3
Cau Hinh Dashboard
Thay the
YOUR_SHEET_ID trong phan JavaScript ben duoi bang ID thuc cua ban. Dashboard se tu dong fetch du lieu moi 30 giay.
// === GOOGLE SHEETS INTEGRATION CODE ===
const SHEET_ID = 'YOUR_SHEET_ID_HERE';
const SHEET_NAME = 'Assets';
async function fetchSheetData() {
const url = `https://docs.google.com/spreadsheets/d/${SHEET_ID}/gviz/tq?tqx=out:json&sheet=${SHEET_NAME}`;
try {
const response = await fetch(url);
const text = await response.text();
const json = JSON.parse(text.substring(47).slice(0, -2));
const rows = json.table.rows;
const assets = rows.map(row => ({
name: row.c[0]?.v || '',
type: row.c[1]?.v || '',
value: row.c[2]?.v || 0,
cost: row.c[3]?.v || 0,
date: row.c[4]?.v || ''
}));
updateDashboard(assets);
} catch (error) {
console.error('Loi ket noi Google Sheets:', error);
}
}
// Tu dong cap nhat moi 30 giay
setInterval(fetchSheetData, 30000);
// Hoac su dung Google Apps Script Web App (khuyen nghi cho private sheets):
// 1. Mo Google Sheet -> Extensions -> Apps Script
// 2. Deploy as Web App (Execute as: Me, Access: Anyone)
// 3. Su dung URL Web App trong fetch thay vi gviz