Stock Events cho Google Sheets cho phep ban keo du lieu danh muc dau tu truc tiep vao bang tinh bang cac ham tuy chinh. Can co tai khoan Stock Events de su dung tien ich bo sung nay.

Sau khi dang nhap, ban co the su dung cac ham sau:

Du lieu thi truong
- STOCKEVENTS_STOCK_PRICE(ma) — Gia thi truong hien tai
- STOCKEVENTS_STOCK_CHANGE(ma) — Phan tram thay doi gia trong 24 gio
- STOCKEVENTS_STOCK_DIVIDEND_YIELD(ma) — Ty suat co tuc hang nam
- STOCKEVENTS_STOCK_NAME(ma) — Ten cong ty

Co tuc
- STOCKEVENTS_DIVIDENDS_INCOME(danh_muc) — Thu nhap co tuc hang nam du kien
- STOCKEVENTS_DIVIDENDS_YIELD_ON_COST(danh_muc) — Ty suat co tuc tren gia von
- STOCKEVENTS_DIVIDENDS_YIELD(danh_muc) — Ty suat co tuc binh quan gia quyen hien tai

Danh muc nam giu
- STOCKEVENTS_HOLDINGS_VALUE(danh_muc) — Tong gia tri thi truong cua danh muc
- STOCKEVENTS_HOLDINGS_GAIN(danh_muc) — Tong lai/lo chua thuc hien
- STOCKEVENTS_HOLDINGS_LIST(danh_muc) — Danh sach tat ca ma co phieu

Vi the
- STOCKEVENTS_POSITION_VALUE(ma; danh_muc) — Gia tri thi truong cua vi the
- STOCKEVENTS_POSITION_SHARES(ma; danh_muc) — So luong co phieu nam giu
- STOCKEVENTS_POSITION_GAIN(ma; danh_muc) — Lai/lo chua thuc hien cua vi the
- STOCKEVENTS_POSITION_AVG_COST(ma; danh_muc) — Gia mua trung binh

Tat ca gia tri duoc cap nhat tu dong moi 10 giay. Cac so duoc tra ve duoi dang gia tri tho de ban co the ap dung dinh dang rieng.