{"id":1852,"date":"2025-03-27T13:31:35","date_gmt":"2025-03-27T05:31:35","guid":{"rendered":"http:\/\/askuncleapple.ddns.net\/wordpress\/?p=1852"},"modified":"2025-03-27T13:31:35","modified_gmt":"2025-03-27T05:31:35","slug":"%e7%b5%82%e8%ba%ab%e5%ad%b8%e7%bf%92%e3%80%81%e6%b0%b8%e4%b8%8d%e8%a8%80%e4%bc%91","status":"publish","type":"post","link":"http:\/\/askuncleapple.ddns.net\/wordpress\/?p=1852","title":{"rendered":"\u7d42\u8eab\u5b78\u7fd2\u3001\u6c38\u4e0d\u8a00\u4f11"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">During the peak and worst period of the Pandemic between Feb 2020 and mid of 2021, and due to the complete lockdown in this city, I had no choice but just stayed home without any consultancy work, so I decided to learn something new, which was to target building a home LAMP ( Linux, Apache, MySql and PHP ) mini server to manage my Hang Seng stock portfolio myself.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">I spent nearly 12 months time on this by building and learning the following:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Bought 2 Raspberry pi 3b model and installed Raspbian OS<\/li>\n\n\n\n<li>Viewed tons of youtube videos on how-to install LAMP<\/li>\n\n\n\n<li>Trial and Error million times and finally got my Pi running LAMP successfully<\/li>\n\n\n\n<li>Also installed No-IP to build my free domain<\/li>\n\n\n\n<li>Learn to configure my home internet routers doing port forwarding on port 80, 3336, etc.<\/li>\n\n\n\n<li>Installed Plex media server at the same time to stream my home\u2019s mp3 songs and mp4 videos<\/li>\n\n\n\n<li>I started to program in MySQL scripts and design my portfolio Database to store my portfolio records<\/li>\n\n\n\n<li>Then I moved forward to start learning RapidAPIs on simple APIs like Yahoo Finance so that I could write crontab scripts to get via API calls my portfolio stock closing prices at 4:45pm after each trading day closed<\/li>\n\n\n\n<li>I developed all those Linux auto scripts to update my portfolio and calculate the 10th, 20th, 50th and 100th daily averages<br>-Then I downloaded PowerBI desktop from Microsoft to start building my BI dashboards\u2026took me 3-4 months<\/li>\n\n\n\n<li>all the above took me 12 months to develop, design, re-design, develop and debug, test and deploy<\/li>\n\n\n\n<li>And it was a lot of funs, with days and nights spent on Youtube, GITHUB, googling\u2026<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Finally since mid 2021 up to now for nearly 4 years, I\u2019d gathered around 5 years of valuable stats of my portfolio, which is a great digital assets I built with hard efforts\u2026with no buddy AI involved at all\u2026<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Cause I still only believe human intelligence HI \ud83d\ude03And I am so proud of myself being able to do all these at the age of 60+<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Thank god of being able to lifetime learning \u7d42\u8eab\u5b78\u7fd2\ud83d\ude4f<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"640\" height=\"360\" src=\"https:\/\/i0.wp.com\/askuncleapple.ddns.net\/wordpress\/wp-content\/uploads\/2025\/03\/img_2581-1.jpg?resize=640%2C360\" class=\"wp-image-1847\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"640\" height=\"360\" src=\"https:\/\/i0.wp.com\/askuncleapple.ddns.net\/wordpress\/wp-content\/uploads\/2025\/03\/img_2582-1.jpg?resize=640%2C360\" class=\"wp-image-1848\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"640\" height=\"360\" src=\"https:\/\/i0.wp.com\/askuncleapple.ddns.net\/wordpress\/wp-content\/uploads\/2025\/03\/img_2583-1.jpg?resize=640%2C360\" class=\"wp-image-1849\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"640\" height=\"360\" src=\"https:\/\/i0.wp.com\/askuncleapple.ddns.net\/wordpress\/wp-content\/uploads\/2025\/03\/img_2584-1.jpg?resize=640%2C360\" class=\"wp-image-1850\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"640\" height=\"360\" src=\"https:\/\/i0.wp.com\/askuncleapple.ddns.net\/wordpress\/wp-content\/uploads\/2025\/03\/img_2585-1.jpg?resize=640%2C360\" class=\"wp-image-1851\"\/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>During the peak and worst period of the Pandemic between Feb 2020 and mid of&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[2],"tags":[],"class_list":["post-1852","post","type-post","status-publish","format-standard","hentry","category-samgor-teach-room-feeds"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"http:\/\/askuncleapple.ddns.net\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1852","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/askuncleapple.ddns.net\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/askuncleapple.ddns.net\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/askuncleapple.ddns.net\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/askuncleapple.ddns.net\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1852"}],"version-history":[{"count":0,"href":"http:\/\/askuncleapple.ddns.net\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1852\/revisions"}],"wp:attachment":[{"href":"http:\/\/askuncleapple.ddns.net\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1852"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/askuncleapple.ddns.net\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1852"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/askuncleapple.ddns.net\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1852"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}