Files
abc2022d/meta.md
louiscklaw b4c097f71d update,
2025-02-01 01:59:07 +08:00

62 lines
2.4 KiB
Markdown
Raw Permalink Blame History

This file contains ambiguous Unicode characters

This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.

---
tags: "hkjc", "vba", "excel","selenium"
---
# abc2022d
Tim206207@gmail.com
### balance history
5 layouts quote HKD2400
| --- | --- | --- |
| --------- | ---------------- | ------------------------------------------------------------------------------------------------------------------------ |
| webpage 1 | 排位表 | https://racing.hkjc.com/racing/information/Chinese/racing/Racecard.aspx?RaceDate=2024/04/20&Racecourse=ST&RaceNo=1 |
| webpage 2 | 個別馬匹資料頁面 | i.e. 魅力一心 https://racing.hkjc.com/racing/information/Chinese/Horse/Horse.aspx?HorseId=HK_2022_H195 |
| (H195) |
| webpage 3 | 賽馬結果 | https://racing.hkjc.com/racing/information/Chinese/racing/LocalResults.aspx |
| webpage 4 | 分段時間 | https://racing.hkjc.com/racing/information/Chinese/Racing/DisplaySectionalTime.aspx?RaceDate=20/04/2024&RaceNo=1 |
| webpage 5 | 操練 | https://racing.hkjc.com/racing/information/Chinese/Racing/LocalTrackwork.aspx?RaceDate=2024/04/20&Racecourse=ST&RaceNo=1 |
### chat history
Q:
1. 見到 vba 行 ge 途中, 佢拎個別馬 ge 資料係馬會 ge 英文版面
2. 見到賽果個邊 columns, "HKJC not ready" , 21/4 賽果已出
3. 到實際用 ge 時間應該有個制比我揀日期, 可以 generate 返之前 d 賽果?
A:
1. VBA 本身 support 中文冇咁好,有 D 位要用英文對一對佢 i.e. Gallop -> 踱步
但係到最後都係會用中文網頁內容嘅,只係比較果陣時會用英文
2. 如果咁的話,咁左手邊果 D 行 (藍+灰) 會同右手邊果 D 行 (黃+粉紅) 唔對/匹配
i.e. 20/04/2024 沙田日馬跑左 10 場,但係黎緊 24/04/2024 跑馬地 得 9 場,會變左左手邊突左場出黎
係咪想咁?
3. 呢個可以呀,比個格你入日期落去
Q:
如果之後有問題都可以繼續揾你?
如果馬會啲 field/ webpage link 轉左,
揾你修改要額外比錢嗎
A:
一般計,轉 field/link 的話你搵番我我可以幫手改
但係如果佢係成個版面轉左花款的話(成個版面個樣轉左)
咁果個 update 就收番個 update 錢
### materials
#### 安裝 dotnetfx35 and selenium basic
ttps://youtu.be/3mTbo63exHE
#### 點用
ttps://filetransfer.io/data-package/gES49XH7#link
https://youtu.be/Kft1vWFmDrE