\u81ea\u52d5\u5316\u6295\u8cc7\u7d44\u5408\u8ffd\u8e64\u6307\u5357 \/ Automated Portfolio Tracker Guide<\/title>\n <style>\n \/* Scoped styles for the portfolio guide to prevent conflicts with your theme *\/\n body {\n font-family: -apple-system, BlinkMacSystemFont, \"Segoe UI\", Roboto, Helvetica, Arial, sans-serif;\n line-height: 1.7;\n color: #333;\n background-color: #fdfdfd;\n margin: 0;\n padding: 20px;\n }\n .portfolio-tracker-guide {\n max-width: 800px;\n margin: 20px auto;\n background-color: #ffffff;\n padding: 2em 2.5em;\n border-radius: 12px;\n border: 1px solid #e0e0e0;\n box-shadow: 0 6px 20px rgba(0, 0, 0, 0.07);\n }\n .portfolio-tracker-guide h1,\n .portfolio-tracker-guide h2,\n .portfolio-tracker-guide h3 {\n font-weight: 700;\n color: #1a237e; \/* A deep blue for headings *\/\n line-height: 1.3;\n margin-top: 1.5em;\n margin-bottom: 0.7em;\n }\n .portfolio-tracker-guide h1 {\n font-size: 2.2em;\n text-align: center;\n border-bottom: 2px solid #3f51b5; \/* A matching lighter blue *\/\n padding-bottom: 0.5em;\n margin-top: 0;\n }\n .portfolio-tracker-guide .tagline {\n text-align: center;\n font-size: 1.1em;\n color: #555;\n margin-top: -0.5em;\n margin-bottom: 2.5em;\n }\n .portfolio-tracker-guide h2 {\n font-size: 1.8em;\n }\n .portfolio-tracker-guide h3 {\n font-size: 1.4em;\n color: #3f51b5; \/* Lighter blue for subheadings *\/\n }\n .portfolio-tracker-guide p {\n margin-bottom: 1.2em;\n }\n .portfolio-tracker-guide ol, .portfolio-tracker-guide ul {\n padding-left: 25px;\n margin-bottom: 1.5em;\n }\n .portfolio-tracker-guide li {\n margin-bottom: 0.8em;\n }\n .portfolio-tracker-guide code {\n font-family: 'Courier New', Courier, monospace;\n background-color: #e8eaf6; \/* Light indigo background *\/\n color: #1a237e;\n padding: 3px 7px;\n border-radius: 4px;\n font-size: 0.95em;\n }\n .portfolio-tracker-guide pre {\n background-color: #f5f5f5;\n border: 1px solid #ddd;\n border-radius: 6px;\n padding: 15px;\n overflow-x: auto;\n white-space: pre;\n word-wrap: normal;\n }\n .portfolio-tracker-guide pre code {\n background-color: transparent;\n color: #333;\n padding: 0;\n }\n .portfolio-tracker-guide table {\n width: 100%;\n border-collapse: collapse;\n margin: 2em 0;\n box-shadow: 0 2px 4px rgba(0,0,0,0.05);\n font-size: 0.95em;\n }\n .portfolio-tracker-guide th, .portfolio-tracker-guide td {\n border: 1px solid #ddd;\n padding: 12px;\n text-align: left;\n vertical-align: top;\n }\n .portfolio-tracker-guide th {\n background-color: #3f51b5;\n color: white;\n font-weight: 600;\n }\n .portfolio-tracker-guide tbody tr:nth-child(even) {\n background-color: #f9f9f9;\n }\n .portfolio-tracker-guide strong {\n color: #1a237e;\n }\n .portfolio-tracker-guide .disclaimer {\n font-size: 0.9em;\n color: #777;\n border-top: 1px solid #eee;\n padding-top: 1em;\n margin-top: 2em;\n text-align: center;\n }\n \n \/* Language Toggle Styles *\/\n .lang-toggle-container {\n text-align: right;\n margin: -1em 0 1.5em 0;\n }\n .lang-toggle-btn {\n background-color: #f1f1f1;\n color: #333;\n border: 1px solid #ccc;\n padding: 8px 16px;\n border-radius: 20px;\n cursor: pointer;\n font-size: 0.9em;\n font-weight: 500;\n transition: background-color 0.3s, box-shadow 0.3s;\n }\n .lang-toggle-btn:hover {\n background-color: #e8eaf6;\n border-color: #3f51b5;\n }\n\n \/* Language Visibility Logic *\/\n .portfolio-tracker-guide[data-lang=\"zh\"] .lang-en,\n .portfolio-tracker-guide[data-lang=\"en\"] .lang-zh {\n display: none !important; \/* Added !important to override theme styles *\/\n }\n <\/style>\n<\/head>\n<body>\n\n <div class=\"portfolio-tracker-guide\" data-lang=\"zh\">\n <div class=\"lang-toggle-container\">\n <button id=\"langToggleBtn\" class=\"lang-toggle-btn\">Switch to English<\/button>\n <\/div>\n <article>\n <header>\n <h1 class=\"lang-zh\">\u89e3\u653e\u60a8\u7684\u6295\u8cc7\u6f5b\u529b\uff1a\u4f7f\u7528 Google Sheets \u6253\u9020\u5373\u6642\u6295\u8cc7\u8ffd\u8e64\u5668<\/h1>\n <h1 class=\"lang-en\">Unlock Your Portfolio’s Potential: A Live Investment Tracker with Google Sheets<\/h1>\n \n <p class=\"tagline lang-zh\"><strong>\u5c07\u7c21\u55ae\u7684\u8a66\u7b97\u8868\u8f49\u8b8a\u70ba\u5f37\u5927\u3001\u80fd\u81ea\u52d5\u66f4\u65b0\u7684\u8ca1\u52d9\u5100\u8868\u677f\u3002<\/strong><\/p>\n <p class=\"tagline lang-en\"><strong>a simple spreadsheet into a powerful, self-updating financial dashboard.<\/strong> <\/p>\n <\/header>\n \n <section>\n <p class=\"lang-zh\">\u5c0d\u65bc\u73fe\u4ee3\u6295\u8cc7\u8005\u800c\u8a00\uff0c\u96a8\u6642\u638c\u63e1\u6700\u65b0\u8cc7\u8a0a\u662f\u95dc\u9375\u3002\u624b\u52d5\u6aa2\u67e5\u591a\u500b\u8b49\u5238\u5e33\u6236\u3001\u8ffd\u8e64\u80a1\u50f9\u4e26\u66f4\u65b0\u8a66\u7b97\u8868\uff0c\u53ef\u80fd\u662f\u4e00\u500b\u7e41\u7463\u4e14\u8017\u6642\u7684\u904e\u7a0b\u3002Google Sheets\u80fd\u5c07\u60a8\u7684\u6574\u500b\u6295\u8cc7\u7d44\u5408\u96c6\u4e2d\u5230\u4e00\u500b\u80fd\u8fd1\u4e4e\u5373\u6642\u66f4\u65b0\u7684\u52d5\u614b\u5100\u8868\u677f\u4e2d\u3002 \u544a\u5225\u975c\u614b\u3001\u904e\u6642\u7684\u6578\u64da\u3002\u900f\u904e\u5229\u7528\u4e00\u500b\u5f37\u5927\u7684\u5167\u5efa\u51fd\u5f0f\uff0c\u60a8\u53ef\u4ee5\u5c07\u7c21\u55ae\u7684\u8a66\u7b97\u8868\u8f49\u8b8a\u70ba\u4e00\u500b\u81ea\u52d5\u5316\u7684\u6295\u8cc7\u7d44\u5408\u8ffd\u8e64\u5668\uff0c\u4e00\u76ee\u4e86\u7136\u5730\u63d0\u4f9b\u95dc\u9375\u6d1e\u5bdf\u3002\u672c\u6307\u5357\u5c07\u5f15\u5c0e\u60a8\u4e00\u6b65\u6b65\u5efa\u7acb\u5b83\u3002<\/p>\n <p class=\"lang-en\">For the modern investor, staying updated is key. Manually checking multiple brokerage accounts, tracking stock prices, and updating spreadsheets can be a tedious, time-consuming process. Google Sheets could centralize your entire portfolio into a single, dynamic dashboard that updates itself in near real-time. you can forget static, outdated data. By leveraging a powerful, built-in function, you can transform a simple spreadsheet into an automated portfolio tracker that provides critical insights at a glance. This guide will walk you through how to build it, step by step.<\/p>\n <\/section>\n \n <section>\n <h2 class=\"lang-zh\">\u6838\u5fc3\u5f15\u64ce\uff1a\u4e86\u89e3 <code>GOOGLEFINANCE<\/code> \u51fd\u5f0f<\/h2>\n <h2 class=\"lang-en\">The Core Engine: Understanding the <code>GOOGLEFINANCE<\/code> Function<\/h2>\n\n <p class=\"lang-zh\">\u9019\u9805\u81ea\u52d5\u5316\u529f\u80fd\u80cc\u5f8c\u7684\u79d8\u5bc6\u5c31\u662f <code>GOOGLEFINANCE<\/code> \u51fd\u5f0f\u3002\u9019\u500b\u5de5\u5177\u53ef\u4ee5\u76f4\u63a5\u5f9e Google \u8ca1\u7d93\u7372\u53d6\u7576\u524d\u548c\u6b77\u53f2\u7684\u8b49\u5238\u6578\u64da\u5230\u60a8\u7684\u8a66\u7b97\u8868\u4e2d\u3002<\/p>\n <p class=\"lang-en\">The magic behind this automation is the <code>GOOGLEFINANCE<\/code> function. This tool can fetch current and historical securities data directly from Google Finance into your spreadsheet.<\/p>\n\n <p class=\"lang-zh\">\u57fa\u672c\u8a9e\u6cd5\u5f88\u7c21\u55ae\uff1a<\/p>\n <p class=\"lang-en\">The basic syntax is simple:<\/p>\n <pre><code>=GOOGLEFINANCE(ticker, [attribute])<\/code><\/pre>\n <ul>\n <li><span class=\"lang-zh\"><strong><code>ticker<\/code><\/strong>\uff1a\u80a1\u7968\u6216 ETF \u7684\u4ee3\u78bc\u3002<strong>\u6700\u95dc\u9375\u7684\u662f<\/strong>\uff0c\u5c0d\u65bc\u570b\u969b\u80a1\u7968\uff0c\u60a8\u5fc5\u9808\u5305\u542b\u4ea4\u6613\u6240\u524d\u7db4\u3002\u4f8b\u5982\uff1a<code>TPE:00878<\/code> (\u53f0\u7063)\u3001<code>NASDAQ:AAPL<\/code> (\u7f8e\u570b)\u3002<\/span><span class=\"lang-en\"><strong><code>ticker<\/code><\/strong>: The stock or ETF symbol. <strong>Crucially<\/strong>, for international stocks, you must include the exchange prefix. For example: <code>TPE:00878<\/code> (Taiwan), <code>NASDAQ:AAPL<\/code> (USA).<\/span><\/li>\n <li><span class=\"lang-zh\"><strong><code>[attribute]<\/code><\/strong>\uff1a\u60a8\u60f3\u8981\u7372\u53d6\u7684\u7279\u5b9a\u6578\u64da\uff0c\u4f8b\u5982 <code>\"price\"<\/code> (\u50f9\u683c)\u3001<code>\"change\"<\/code> (\u6f32\u8dcc) \u6216 <code>\"marketcap\"<\/code> (\u5e02\u503c)\u3002<\/span><span class=\"lang-en\"><strong><code>[attribute]<\/code><\/strong>: The specific piece of data you want, such as <code>\"price\"<\/code>, <code>\"change\"<\/code>, or <code>\"marketcap\"<\/code>.<\/span><\/li>\n <\/ul>\n <\/section>\n \n <section>\n <h2 class=\"lang-zh\">\u9010\u6b65\u6307\u5357\uff1a\u5efa\u7acb\u60a8\u7684\u81ea\u52d5\u5316\u5100\u8868\u677f<\/h2>\n <h2 class=\"lang-en\">Step-by-Step Guide: Building Your Automated Dashboard<\/h2>\n \n <h3 class=\"lang-zh\">\u6b65\u9a5f 1\uff1a\u5efa\u7acb\u60a8\u7684\u8a66\u7b97\u8868\u7d50\u69cb<\/h3>\n <h3 class=\"lang-en\">Step 1: Structure Your Spreadsheet<\/h3>\n <p class=\"lang-zh\">\u958b\u555f\u4e00\u4efd\u65b0\u7684 Google \u8a66\u7b97\u8868\u4e26\u8a2d\u5b9a\u60a8\u7684\u6b04\u4f4d\u3002\u4e00\u500b\u7a69\u56fa\u7684\u57fa\u790e\u662f\u95dc\u9375\u3002\u6211\u5011\u5c07\u5305\u542b\u975c\u614b\u6578\u64da\uff08\u60a8\u53ea\u9700\u8f38\u5165\u4e00\u6b21\uff09\u548c\u52d5\u614b\u6578\u64da\uff08Google \u6703\u81ea\u52d5\u66f4\u65b0\uff09\u3002<\/p>\n <p class=\"lang-en\">Open a new Google Sheet and set up your columns. A strong foundation is key. We’ll include both static data (what you enter once) and dynamic data (what Google will update).<\/p>\n <table>\n <thead>\n <tr>\n <th><span class=\"lang-zh\">\u80a1\u7968\u4ee3\u78bc<\/span><span class=\"lang-en\">Ticker<\/span><\/th>\n <th><span class=\"lang-zh\">\u516c\u53f8\u540d\u7a31<\/span><span class=\"lang-en\">Company Name<\/span><\/th>\n <th><span class=\"lang-zh\">\u6301\u6709\u80a1\u6578<\/span><span class=\"lang-en\">Shares Owned<\/span><\/th>\n <th><span class=\"lang-zh\">\u8cb7\u5165\u50f9\u683c<\/span><span class=\"lang-en\">Purchase Price<\/span><\/th>\n <th><span class=\"lang-zh\"><strong>\u76ee\u524d\u50f9\u683c<\/strong><\/span><span class=\"lang-en\"><strong>Current Price<\/strong><\/span><\/th>\n <th><span class=\"lang-zh\"><strong>\u76ee\u524d\u5e02\u503c<\/strong><\/span><span class=\"lang-en\"><strong>Market Value<\/strong><\/span><\/th>\n <th><span class=\"lang-zh\"><strong>\u640d\u76ca<\/strong><\/span><span class=\"lang-en\"><strong>Profit \/ Loss<\/strong><\/span><\/th>\n <\/tr>\n <\/thead>\n <\/table>\n \n <h3 class=\"lang-zh\">\u6b65\u9a5f 2\uff1a\u4f7f\u7528\u6b63\u78ba\u7684\u4ee3\u78bc\u5217\u51fa\u60a8\u7684\u6301\u80a1<\/h3>\n <h3 class=\"lang-en\">Step 2: List Your Holdings with Correct Tickers<\/h3>\n <p class=\"lang-zh\">\u5728\u300c\u80a1\u7968\u4ee3\u78bc\u300d\u6b04\uff08\u4f8b\u5982\uff0c\u5132\u5b58\u683c A2\uff09\u4e2d\uff0c\u8f38\u5165\u60a8\u6bcf\u9805\u6301\u80a1\u7684\u5b8c\u6574\u4ee3\u78bc\uff0c\u5305\u542b\u4ea4\u6613\u6240\u524d\u7db4\u3002\u9019\u662f\u78ba\u4fdd\u516c\u5f0f\u80fd\u6b63\u78ba\u904b\u4f5c\u6700\u91cd\u8981\u7684\u4e00\u6b65\u3002<\/p>\n <p class=\"lang-en\">In the “Ticker” column (e.g., cell A2), enter the full ticker symbol for each of your holdings, including the exchange prefix. This is the most important step for ensuring the formulas work correctly.<\/p>\n \n <h3 class=\"lang-zh\">\u6b65\u9a5f 3\uff1a\u7528\u516c\u5f0f\u6293\u53d6\u5373\u6642\u5e02\u5834\u6578\u64da<\/h3>\n <h3 class=\"lang-en\">Step 3: Pull Live Market Data with Formulas<\/h3>\n <p class=\"lang-zh\">\u73fe\u5728\uff0c\u8b93\u6211\u5011\u70ba\u60a8\u7684\u8a66\u7b97\u8868\u6ce8\u5165\u751f\u547d\u529b\u3002\u6211\u5011\u5c07\u4f7f\u7528 A \u6b04\u4e2d\u7684\u4ee3\u78bc\u4f86\u70ba\u6bcf\u4e00\u884c\u6293\u53d6\u5c0d\u61c9\u7684\u6578\u64da\u3002<\/p>\n <p class=\"lang-en\">Now, let’s bring your sheet to life. We will use the ticker in column A to pull data for each corresponding row.<\/p>\n <ul>\n <li><span class=\"lang-zh\"><strong>\u516c\u53f8\u540d\u7a31 (\u5132\u5b58\u683c B2)\uff1a<\/strong><\/span><span class=\"lang-en\"><strong>Company Name (Cell B2):<\/strong><\/span> <pre><code>=GOOGLEFINANCE(A2, \"name\")<\/code><\/pre><\/li>\n <li><span class=\"lang-zh\"><strong>\u76ee\u524d\u50f9\u683c (\u5132\u5b58\u683c E2)\uff1a<\/strong><\/span><span class=\"lang-en\"><strong>Current Price (Cell E2):<\/strong><\/span> <pre><code>=GOOGLEFINANCE(A2, \"price\")<\/code><\/pre><\/li>\n <\/ul>\n <p class=\"lang-zh\">\u7576\u60a8\u5728\u7b2c\u4e00\u500b\u8cc7\u6599\u5217\u8f38\u5165\u5b8c\u516c\u5f0f\u5f8c\uff0c\u53ea\u9700\u9ede\u64ca\u5132\u5b58\u683c\u53f3\u4e0b\u89d2\u7684\u5c0f\u85cd\u8272\u65b9\u584a\uff0c\u7136\u5f8c\u5411\u4e0b\u62c9\u52d5\uff0c\u5373\u53ef\u5c07\u516c\u5f0f\u61c9\u7528\u5230\u60a8\u6240\u6709\u7684\u6301\u80a1\u4e0a\u3002<\/p>\n <p class=\"lang-en\">Once you’ve entered the formulas in the first data row, simply click the small blue square in the corner of the cell and drag it down to apply the formulas to all your holdings.<\/p>\n \n <h3 class=\"lang-zh\">\u6b65\u9a5f 4\uff1a\u8a08\u7b97\u60a8\u7684\u6295\u8cc7\u7d44\u5408\u8868\u73fe<\/h3>\n <h3 class=\"lang-en\">Step 4: Calculate Your Portfolio’s Performance<\/h3>\n <p class=\"lang-zh\">\u96a8\u8457\u5373\u6642\u6578\u64da\u7684\u6d41\u5165\uff0c\u60a8\u73fe\u5728\u53ef\u4ee5\u7528\u7c21\u55ae\u7684\u7b97\u8853\u4f86\u8a08\u7b97\u60a8\u7684\u95dc\u9375\u7e3e\u6548\u6307\u6a19\u3002<\/p>\n <p class=\"lang-en\">With live data flowing in, you can now calculate your key performance metrics using simple arithmetic.<\/p>\n <ul>\n <li><span class=\"lang-zh\"><strong>\u76ee\u524d\u5e02\u503c (\u5132\u5b58\u683c F2)\uff1a<\/strong> <pre><code>=C2 * E2<\/code><\/pre> (\u6301\u6709\u80a1\u6578 * \u76ee\u524d\u50f9\u683c)<\/span><span class=\"lang-en\"><strong>Market Value (Cell F2):<\/strong> <pre><code>=C2 * E2<\/code><\/pre> (Shares Owned * Current Price)<\/span><\/li>\n <li><span class=\"lang-zh\"><strong>\u640d\u76ca (\u5132\u5b58\u683c G2)\uff1a<\/strong> <pre><code>=(E2 - D2) * C2<\/code><\/pre> ((\u76ee\u524d\u50f9\u683c – \u8cb7\u5165\u50f9\u683c) * \u6301\u6709\u80a1\u6578)<\/span><span class=\"lang-en\"><strong>Profit \/ Loss (Cell G2):<\/strong> <pre><code>=(E2 - D2) * C2<\/code><\/pre> ((Current Price – Purchase Price) * Shares Owned)<\/span><\/li>\n <\/ul>\n \n <h3 class=\"lang-zh\">\u6b65\u9a5f 5\uff1a\u8996\u89ba\u5316\u8207\u529f\u80fd\u589e\u5f37<\/h3>\n <h3 class=\"lang-en\">Step 5: Visualize and Enhance<\/h3>\n <p class=\"lang-zh\">\u70ba\u4e86\u8b93\u60a8\u7684\u8ffd\u8e64\u5668\u66f4\u52a0\u5c08\u696d\uff0c\u53ef\u4ee5\u6dfb\u52a0\u4e00\u4e9b\u8996\u89ba\u5316\u5143\u7d20\uff1a<\/p>\n <p class=\"lang-en\">To make your tracker even more professional, add visual elements:<\/p>\n <ul>\n <li><span class=\"lang-zh\"><strong>\u689d\u4ef6\u5f0f\u683c\u5f0f\u8a2d\u5b9a\uff1a<\/strong> \u81ea\u52d5\u70ba\u60a8\u7684\u300c\u640d\u76ca\u300d\u6b04\u4f4d\u4e0a\u8272\u3002\u7da0\u8272\u4ee3\u8868\u7372\u5229\uff0c\u7d05\u8272\u4ee3\u8868\u8667\u640d\u3002(\u524d\u5f80 <code>\u683c\u5f0f > \u689d\u4ef6\u5f0f\u683c\u5f0f\u8a2d\u5b9a<\/code>)\u3002<\/span><span class=\"lang-en\"><strong>Conditional Formatting:<\/strong> Automatically color-code your “Profit \/ Loss” column. Green for gains, red for losses. (Go to <code>Format > Conditional formatting<\/code>).<\/span><\/li>\n <li><span class=\"lang-zh\"><strong>\u6295\u8cc7\u7d44\u5408\u7e3d\u89bd\uff1a<\/strong> \u4f7f\u7528 <code>SUM()<\/code> \u51fd\u5f0f\u4f86\u8a08\u7b97\u60a8\u6574\u500b\u6295\u8cc7\u7d44\u5408\u7684\u7e3d\u5e02\u503c\u548c\u7e3d\u640d\u76ca\u3002<\/span><span class=\"lang-en\"><strong>Portfolio Summary:<\/strong> Use the <code>SUM()<\/code> function to calculate the total market value and total profit\/loss of your entire portfolio.<\/span><\/li>\n <li><span class=\"lang-zh\"><strong>\u5713\u9905\u5716\uff1a<\/strong> \u5efa\u7acb\u5716\u8868\u4f86\u8996\u89ba\u5316\u60a8\u6309\u80a1\u7968\u4ee3\u78bc\u5206\u914d\u7684\u6295\u8cc7\u7d44\u5408\uff0c\u5e6b\u52a9\u60a8\u4e86\u89e3\u662f\u5426\u904e\u5ea6\u96c6\u4e2d\u5728\u67d0\u4e00\u8cc7\u7522\u4e0a\u3002<\/span><span class=\"lang-en\"><strong>Pie Charts:<\/strong> Create a chart to visualize your portfolio allocation by ticker, helping you see if you are overly concentrated in one asset.<\/span><\/li>\n <\/ul>\n <\/section>\n \n \n <section id=\"appendix\">\n <h2 class=\"lang-zh\">\u9644\u9304\uff1a<code>GOOGLEFINANCE<\/code> \u5373\u6642\u6578\u64da\u5c6c\u6027<\/h2>\n <h2 class=\"lang-en\">Appendix: <code>GOOGLEFINANCE<\/code> Real-Time Data Attributes<\/h2>\n <table>\n <thead>\n <tr>\n <th><span class=\"lang-zh\">\u5c6c\u6027<\/span><span class=\"lang-en\">Attribute<\/span><\/th>\n <th><span class=\"lang-zh\">\u529f\u80fd\u8aaa\u660e<\/span><span class=\"lang-en\">What It Does<\/span><\/th>\n <th><span class=\"lang-zh\">\u7bc4\u4f8b\u516c\u5f0f (\u4f7f\u7528 A2)<\/span><span class=\"lang-en\">Example Formula (using A2)<\/span><\/th>\n <\/tr>\n <\/thead>\n <tbody>\n <tr>\n <td><code>\"price\"<\/code><\/td>\n <td><span class=\"lang-zh\">\u76ee\u524d\u6216\u6700\u8fd1\u7684\u50f9\u683c\u3002<\/span><span class=\"lang-en\">Current or most recent price.<\/span><\/td>\n <td><code>=GOOGLEFINANCE(A2, \"price\")<\/code><\/td>\n <\/tr>\n <tr>\n <td><code>\"priceopen\"<\/code><\/td>\n <td><span class=\"lang-zh\">\u5e02\u5834\u958b\u76e4\u6642\u7684\u50f9\u683c\u3002<\/span><span class=\"lang-en\">The price at the opening of the market.<\/span><\/td>\n <td><code>=GOOGLEFINANCE(A2, \"priceopen\")<\/code><\/td>\n <\/tr>\n <tr>\n <td><code>\"high\"<\/code><\/td>\n <td><span class=\"lang-zh\">\u7576\u65e5\u6700\u9ad8\u50f9\u3002<\/span><span class=\"lang-en\">The current day’s high price.<\/span><\/td>\n <td><code>=GOOGLEFINANCE(A2, \"high\")<\/code><\/td>\n <\/tr>\n <tr>\n <td><code>\"low\"<\/code><\/td>\n <td><span class=\"lang-zh\">\u7576\u65e5\u6700\u4f4e\u50f9\u3002<\/span><span class=\"lang-en\">The current day’s low price.<\/span><\/td>\n <td><code>=GOOGLEFINANCE(A2, \"low\")<\/code><\/td>\n <\/tr>\n <tr>\n <td><code>\"volume\"<\/code><\/td>\n <td><span class=\"lang-zh\">\u7576\u65e5\u6210\u4ea4\u91cf\u3002<\/span><span class=\"lang-en\">The current day’s trading volume.<\/span><\/td>\n <td><code>=GOOGLEFINANCE(A2, \"volume\")<\/code><\/td>\n <\/tr>\n <tr>\n <td><code>\"marketcap\"<\/code><\/td>\n <td><span class=\"lang-zh\">\u80a1\u7968\u7684\u5e02\u503c\u3002<\/span><span class=\"lang-en\">The market capitalization of the stock.<\/span><\/td>\n <td><code>=GOOGLEFINANCE(A2, \"marketcap\")<\/code><\/td>\n <\/tr>\n <tr>\n <td><code>\"tradetime\"<\/code><\/td>\n <td><span class=\"lang-zh\">\u6700\u5f8c\u4e00\u7b46\u4ea4\u6613\u7684\u6642\u9593\u3002<\/span><span class=\"lang-en\">The time of the last trade.<\/span><\/td>\n <td><code>=GOOGLEFINANCE(A2, \"tradetime\")<\/code><\/td>\n <\/tr>\n <tr>\n <td><code>\"datadelay\"<\/code><\/td>\n <td><span class=\"lang-zh\">\u6578\u64da\u5ef6\u9072\u7684\u5206\u9418\u6578\u3002<\/span><span class=\"lang-en\">How delayed the data is in minutes.<\/span><\/td>\n <td><code>=GOOGLEFINANCE(A2, \"datadelay\")<\/code><\/td>\n <\/tr>\n <tr>\n <td><code>\"volumeavg\"<\/code><\/td>\n <td><span class=\"lang-zh\">\u5e73\u5747\u6bcf\u65e5\u6210\u4ea4\u91cf\u3002<\/span><span class=\"lang-en\">The average daily trading volume.<\/span><\/td>\n <td><code>=GOOGLEFINANCE(A2, \"volumeavg\")<\/code><\/td>\n <\/tr>\n <tr>\n <td><code>\"pe\"<\/code><\/td>\n <td><span class=\"lang-zh\">\u672c\u76ca\u6bd4 (P\/E ratio)\u3002<\/span><span class=\"lang-en\">The Price-to-Earnings (P\/E) ratio.<\/span><\/td>\n <td><code>=GOOGLEFINANCE(A2, \"pe\")<\/code><\/td>\n <\/tr>\n <tr>\n <td><code>\"eps\"<\/code><\/td>\n <td><span class=\"lang-zh\">\u6bcf\u80a1\u76c8\u9918 (EPS)\u3002<\/span><span class=\"lang-en\">The Earnings Per Share.<\/span><\/td>\n <td><code>=GOOGLEFINANCE(A2, \"eps\")<\/code><\/td>\n <\/tr>\n <tr>\n <td><code>\"high52\"<\/code><\/td>\n <td><span class=\"lang-zh\">52\u9031\u6700\u9ad8\u50f9\u3002<\/span><span class=\"lang-en\">The 52-week high price.<\/span><\/td>\n <td><code>=GOOGLEFINANCE(A2, \"high52\")<\/code><\/td>\n <\/tr>\n <tr>\n <td><code>\"low52\"<\/code><\/td>\n <td><span class=\"lang-zh\">52\u9031\u6700\u4f4e\u50f9\u3002<\/span><span class=\"lang-en\">The 52-week low price.<\/span><\/td>\n <td><code>=GOOGLEFINANCE(A2, \"low52\")<\/code><\/td>\n <\/tr>\n <tr>\n <td><code>\"change\"<\/code><\/td>\n <td><span class=\"lang-zh\">\u76f8\u8f03\u65bc\u524d\u4e00\u4ea4\u6613\u65e5\u6536\u76e4\u50f9\u7684\u50f9\u683c\u8b8a\u52d5\u3002<\/span><span class=\"lang-en\">The change in price since the previous day’s close.<\/span><\/td>\n <td><code>=GOOGLEFINANCE(A2, \"change\")<\/code><\/td>\n <\/tr>\n <tr>\n <td><code>\"changepct\"<\/code><\/td>\n <td><span class=\"lang-zh\">\u50f9\u683c\u8b8a\u52d5\u7684\u767e\u5206\u6bd4\u3002<\/span><span class=\"lang-en\">The percentage change in price.<\/span><\/td>\n <td><code>=GOOGLEFINANCE(A2, \"changepct\")<\/code><\/td>\n <\/tr>\n <tr>\n <td><code>\"closeyest\"<\/code><\/td>\n <td><span class=\"lang-zh\">\u524d\u4e00\u4ea4\u6613\u65e5\u7684\u6536\u76e4\u50f9\u3002<\/span><span class=\"lang-en\">The previous day’s closing price.<\/span><\/td>\n <td><code>=GOOGLEFINANCE(A2, \"closeyest\")<\/code><\/td>\n <\/tr>\n <tr>\n <td><code>\"name\"<\/code><\/td>\n <td><span class=\"lang-zh\">\u8b49\u5238\u7684\u5b8c\u6574\u540d\u7a31\u3002<\/span><span class=\"lang-en\">The full name of the security.<\/span><\/td>\n <td><code>=GOOGLEFINANCE(A2, \"name\")<\/code><\/td>\n <\/tr>\n <tr>\n <td><code>\"ticker\"<\/code><\/td>\n <td><span class=\"lang-zh\">\u80a1\u7968\u4ee3\u78bc (\u53ef\u7528\u65bc\u9a57\u8b49)\u3002<\/span><span class=\"lang-en\">The ticker symbol (useful for validation).<\/span><\/td>\n <td><code>=GOOGLEFINANCE(A2, \"ticker\")<\/code><\/td>\n <\/tr>\n <tr>\n <td><code>\"currency\"<\/code><\/td>\n <td><span class=\"lang-zh\">\u8b49\u5238\u8a08\u50f9\u7684\u8ca8\u5e63\u3002<\/span><span class=\"lang-en\">The currency in which the security is priced.<\/span><\/td>\n <td><code>=GOOGLEFINANCE(A2, \"currency\")<\/code><\/td>\n <\/tr>\n <\/tbody>\n <\/table>\n <\/section>\n \n <footer>\n <p class=\"disclaimer\">\n <em class=\"lang-zh\"><strong>\u514d\u8cac\u8072\u660e\uff1a<\/strong> \u672c\u6307\u5357\u50c5\u4f9b\u53c3\u8003\uff0c\u4e0d\u69cb\u6210\u4efb\u4f55\u8ca1\u52d9\u5efa\u8b70\u3002<code>GOOGLEFINANCE<\/code> \u51fd\u5f0f\u7684\u6578\u64da\u53ef\u80fd\u6709\u6700\u591a20\u5206\u9418\u7684\u5ef6\u9072\uff0c\u4e14\u53ef\u80fd\u7121\u6cd5\u63d0\u4f9b\u6240\u6709\u80a1\u7968\u4ee3\u78bc\u6216\u5c6c\u6027\u7684\u6578\u64da\u3002\u5728\u505a\u51fa\u4efb\u4f55\u6295\u8cc7\u6c7a\u7b56\u524d\uff0c\u8acb\u52d9\u5fc5\u9032\u884c\u60a8\u81ea\u5df1\u7684\u7814\u7a76\u3002<\/em>\n <em class=\"lang-en\"><strong>Disclaimer:<\/strong> This guide is for informational purposes only and does not constitute financial advice. The <code>GOOGLEFINANCE<\/code> function may have data delays of up to 20 minutes and may not have data for all tickers or attributes. Always conduct your own research before making any investment decisions.<\/em>\n <\/p>\n <\/footer>\n <\/article>\n <\/div>\n\n<script>\n \/\/ JavaScript for language toggle functionality\n document.addEventListener('DOMContentLoaded', function() {\n const toggleBtn = document.getElementById('langToggleBtn');\n const guideContainer = document.querySelector('.portfolio-tracker-guide');\n \n if (toggleBtn && guideContainer) {\n toggleBtn.addEventListener('click', () => {\n const currentLang = guideContainer.getAttribute('data-lang');\n if (currentLang === 'zh') {\n guideContainer.setAttribute('data-lang', 'en');\n document.documentElement.lang = 'en';\n toggleBtn.textContent = '\u5207\u63db\u81f3\u4e2d\u6587'; \/\/ Switch to Chinese\n } else {\n guideContainer.setAttribute('data-lang', 'zh');\n document.documentElement.lang = 'zh-Hant';\n toggleBtn.textContent = 'Switch to English';\n }\n });\n }\n });\n<\/script>\n\n<\/body>\n<\/html>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Google Sheets\u80fd\u5c07\u60a8\u7684\u6574\u500b\u6295\u8cc7\u7d44\u5408\u96c6\u4e2d\u5230\u4e00\u500b\u80fd\u8fd1\u4e4e\u5373\u6642\u66f4\u65b0\u7684\u52d5\u614b\u5100\u8868\u677f\u4e2d\u3002 \u544a\u5225\u975c\u614b\u3001\u904e\u6642\u7684\u6578\u64da<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[],"class_list":["post-391","post","type-post","status-publish","format-standard","hentry","category-itai"],"_links":{"self":[{"href":"https:\/\/yinyang.taichi.us.kg\/index.php?rest_route=\/wp\/v2\/posts\/391","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/yinyang.taichi.us.kg\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/yinyang.taichi.us.kg\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/yinyang.taichi.us.kg\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/yinyang.taichi.us.kg\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=391"}],"version-history":[{"count":2,"href":"https:\/\/yinyang.taichi.us.kg\/index.php?rest_route=\/wp\/v2\/posts\/391\/revisions"}],"predecessor-version":[{"id":393,"href":"https:\/\/yinyang.taichi.us.kg\/index.php?rest_route=\/wp\/v2\/posts\/391\/revisions\/393"}],"wp:attachment":[{"href":"https:\/\/yinyang.taichi.us.kg\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=391"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/yinyang.taichi.us.kg\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=391"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/yinyang.taichi.us.kg\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=391"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}

{"id":391,"date":"2025-09-19T19:42:59","date_gmt":"2025-09-19T11:42:59","guid":{"rendered":"https:\/\/yinyang.taichi.us.kg\/?p=391"},"modified":"2025-09-19T19:44:18","modified_gmt":"2025-09-19T11:44:18","slug":"%e4%bd%bf%e7%94%a8-google-sheets-%e6%89%93%e9%80%a0%e5%8d%b3%e6%99%82%e6%8a%95%e8%b3%87%e8%bf%bd%e8%b9%a4%e5%99%a8","status":"publish","type":"post","link":"https:\/\/yinyang.taichi.us.kg\/?k=9686c237c19903e1","title":{"rendered":"\u4f7f\u7528 Google Sheets \u6253\u9020\u5373\u6642\u6295\u8cc7\u8ffd\u8e64\u5668"},"content":{"rendered":"\n\n\n\n \n \n \u81ea\u52d5\u5316\u6295\u8cc7\u7d44\u5408\u8ffd\u8e64\u6307\u5357 \/ Automated Portfolio Tracker Guide<\/title>\n <style>\n \/* Scoped styles for the portfolio guide to prevent conflicts with your theme *\/\n body {\n font-family: -apple-system, BlinkMacSystemFont, \"Segoe UI\", Roboto, Helvetica, Arial, sans-serif;\n line-height: 1.7;\n color: #333;\n background-color: #fdfdfd;\n margin: 0;\n padding: 20px;\n }\n .portfolio-tracker-guide {\n max-width: 800px;\n margin: 20px auto;\n background-color: #ffffff;\n padding: 2em 2.5em;\n border-radius: 12px;\n border: 1px solid #e0e0e0;\n box-shadow: 0 6px 20px rgba(0, 0, 0, 0.07);\n }\n .portfolio-tracker-guide h1,\n .portfolio-tracker-guide h2,\n .portfolio-tracker-guide h3 {\n font-weight: 700;\n color: #1a237e; \/* A deep blue for headings *\/\n line-height: 1.3;\n margin-top: 1.5em;\n margin-bottom: 0.7em;\n }\n .portfolio-tracker-guide h1 {\n font-size: 2.2em;\n text-align: center;\n border-bottom: 2px solid #3f51b5; \/* A matching lighter blue *\/\n padding-bottom: 0.5em;\n margin-top: 0;\n }\n .portfolio-tracker-guide .tagline {\n text-align: center;\n font-size: 1.1em;\n color: #555;\n margin-top: -0.5em;\n margin-bottom: 2.5em;\n }\n .portfolio-tracker-guide h2 {\n font-size: 1.8em;\n }\n .portfolio-tracker-guide h3 {\n font-size: 1.4em;\n color: #3f51b5; \/* Lighter blue for subheadings *\/\n }\n .portfolio-tracker-guide p {\n margin-bottom: 1.2em;\n }\n .portfolio-tracker-guide ol, .portfolio-tracker-guide ul {\n padding-left: 25px;\n margin-bottom: 1.5em;\n }\n .portfolio-tracker-guide li {\n margin-bottom: 0.8em;\n }\n .portfolio-tracker-guide code {\n font-family: 'Courier New', Courier, monospace;\n background-color: #e8eaf6; \/* Light indigo background *\/\n color: #1a237e;\n padding: 3px 7px;\n border-radius: 4px;\n font-size: 0.95em;\n }\n .portfolio-tracker-guide pre {\n background-color: #f5f5f5;\n border: 1px solid #ddd;\n border-radius: 6px;\n padding: 15px;\n overflow-x: auto;\n white-space: pre;\n word-wrap: normal;\n }\n .portfolio-tracker-guide pre code {\n background-color: transparent;\n color: #333;\n padding: 0;\n }\n .portfolio-tracker-guide table {\n width: 100%;\n border-collapse: collapse;\n margin: 2em 0;\n box-shadow: 0 2px 4px rgba(0,0,0,0.05);\n font-size: 0.95em;\n }\n .portfolio-tracker-guide th, .portfolio-tracker-guide td {\n border: 1px solid #ddd;\n padding: 12px;\n text-align: left;\n vertical-align: top;\n }\n .portfolio-tracker-guide th {\n background-color: #3f51b5;\n color: white;\n font-weight: 600;\n }\n .portfolio-tracker-guide tbody tr:nth-child(even) {\n background-color: #f9f9f9;\n }\n .portfolio-tracker-guide strong {\n color: #1a237e;\n }\n .portfolio-tracker-guide .disclaimer {\n font-size: 0.9em;\n color: #777;\n border-top: 1px solid #eee;\n padding-top: 1em;\n margin-top: 2em;\n text-align: center;\n }\n \n \/* Language Toggle Styles *\/\n .lang-toggle-container {\n text-align: right;\n margin: -1em 0 1.5em 0;\n }\n .lang-toggle-btn {\n background-color: #f1f1f1;\n color: #333;\n border: 1px solid #ccc;\n padding: 8px 16px;\n border-radius: 20px;\n cursor: pointer;\n font-size: 0.9em;\n font-weight: 500;\n transition: background-color 0.3s, box-shadow 0.3s;\n }\n .lang-toggle-btn:hover {\n background-color: #e8eaf6;\n border-color: #3f51b5;\n }\n\n \/* Language Visibility Logic *\/\n .portfolio-tracker-guide[data-lang=\"zh\"] .lang-en,\n .portfolio-tracker-guide[data-lang=\"en\"] .lang-zh {\n display: none !important; \/* Added !important to override theme styles *\/\n }\n <\/style>\n<\/head>\n<body>\n\n <div class=\"portfolio-tracker-guide\" data-lang=\"zh\">\n <div class=\"lang-toggle-container\">\n <button id=\"langToggleBtn\" class=\"lang-toggle-btn\">Switch to English<\/button>\n <\/div>\n <article>\n <header>\n <h1 class=\"lang-zh\">\u89e3\u653e\u60a8\u7684\u6295\u8cc7\u6f5b\u529b\uff1a\u4f7f\u7528 Google Sheets \u6253\u9020\u5373\u6642\u6295\u8cc7\u8ffd\u8e64\u5668<\/h1>\n <h1 class=\"lang-en\">Unlock Your Portfolio’s Potential: A Live Investment Tracker with Google Sheets<\/h1>\n \n <p class=\"tagline lang-zh\"><strong>\u5c07\u7c21\u55ae\u7684\u8a66\u7b97\u8868\u8f49\u8b8a\u70ba\u5f37\u5927\u3001\u80fd\u81ea\u52d5\u66f4\u65b0\u7684\u8ca1\u52d9\u5100\u8868\u677f\u3002<\/strong><\/p>\n <p class=\"tagline lang-en\"><strong>a simple spreadsheet into a powerful, self-updating financial dashboard.<\/strong> <\/p>\n <\/header>\n \n <section>\n <p class=\"lang-zh\">\u5c0d\u65bc\u73fe\u4ee3\u6295\u8cc7\u8005\u800c\u8a00\uff0c\u96a8\u6642\u638c\u63e1\u6700\u65b0\u8cc7\u8a0a\u662f\u95dc\u9375\u3002\u624b\u52d5\u6aa2\u67e5\u591a\u500b\u8b49\u5238\u5e33\u6236\u3001\u8ffd\u8e64\u80a1\u50f9\u4e26\u66f4\u65b0\u8a66\u7b97\u8868\uff0c\u53ef\u80fd\u662f\u4e00\u500b\u7e41\u7463\u4e14\u8017\u6642\u7684\u904e\u7a0b\u3002Google Sheets\u80fd\u5c07\u60a8\u7684\u6574\u500b\u6295\u8cc7\u7d44\u5408\u96c6\u4e2d\u5230\u4e00\u500b\u80fd\u8fd1\u4e4e\u5373\u6642\u66f4\u65b0\u7684\u52d5\u614b\u5100\u8868\u677f\u4e2d\u3002 \u544a\u5225\u975c\u614b\u3001\u904e\u6642\u7684\u6578\u64da\u3002\u900f\u904e\u5229\u7528\u4e00\u500b\u5f37\u5927\u7684\u5167\u5efa\u51fd\u5f0f\uff0c\u60a8\u53ef\u4ee5\u5c07\u7c21\u55ae\u7684\u8a66\u7b97\u8868\u8f49\u8b8a\u70ba\u4e00\u500b\u81ea\u52d5\u5316\u7684\u6295\u8cc7\u7d44\u5408\u8ffd\u8e64\u5668\uff0c\u4e00\u76ee\u4e86\u7136\u5730\u63d0\u4f9b\u95dc\u9375\u6d1e\u5bdf\u3002\u672c\u6307\u5357\u5c07\u5f15\u5c0e\u60a8\u4e00\u6b65\u6b65\u5efa\u7acb\u5b83\u3002<\/p>\n <p class=\"lang-en\">For the modern investor, staying updated is key. Manually checking multiple brokerage accounts, tracking stock prices, and updating spreadsheets can be a tedious, time-consuming process. Google Sheets could centralize your entire portfolio into a single, dynamic dashboard that updates itself in near real-time. you can forget static, outdated data. By leveraging a powerful, built-in function, you can transform a simple spreadsheet into an automated portfolio tracker that provides critical insights at a glance. This guide will walk you through how to build it, step by step.<\/p>\n <\/section>\n \n <section>\n <h2 class=\"lang-zh\">\u6838\u5fc3\u5f15\u64ce\uff1a\u4e86\u89e3 <code>GOOGLEFINANCE<\/code> \u51fd\u5f0f<\/h2>\n <h2 class=\"lang-en\">The Core Engine: Understanding the <code>GOOGLEFINANCE<\/code> Function<\/h2>\n\n <p class=\"lang-zh\">\u9019\u9805\u81ea\u52d5\u5316\u529f\u80fd\u80cc\u5f8c\u7684\u79d8\u5bc6\u5c31\u662f <code>GOOGLEFINANCE<\/code> \u51fd\u5f0f\u3002\u9019\u500b\u5de5\u5177\u53ef\u4ee5\u76f4\u63a5\u5f9e Google \u8ca1\u7d93\u7372\u53d6\u7576\u524d\u548c\u6b77\u53f2\u7684\u8b49\u5238\u6578\u64da\u5230\u60a8\u7684\u8a66\u7b97\u8868\u4e2d\u3002<\/p>\n <p class=\"lang-en\">The magic behind this automation is the <code>GOOGLEFINANCE<\/code> function. This tool can fetch current and historical securities data directly from Google Finance into your spreadsheet.<\/p>\n\n <p class=\"lang-zh\">\u57fa\u672c\u8a9e\u6cd5\u5f88\u7c21\u55ae\uff1a<\/p>\n <p class=\"lang-en\">The basic syntax is simple:<\/p>\n <pre><code>=GOOGLEFINANCE(ticker, [attribute])<\/code><\/pre>\n <ul>\n <li><span class=\"lang-zh\"><strong><code>ticker<\/code><\/strong>\uff1a\u80a1\u7968\u6216 ETF \u7684\u4ee3\u78bc\u3002<strong>\u6700\u95dc\u9375\u7684\u662f<\/strong>\uff0c\u5c0d\u65bc\u570b\u969b\u80a1\u7968\uff0c\u60a8\u5fc5\u9808\u5305\u542b\u4ea4\u6613\u6240\u524d\u7db4\u3002\u4f8b\u5982\uff1a<code>TPE:00878<\/code> (\u53f0\u7063)\u3001<code>NASDAQ:AAPL<\/code> (\u7f8e\u570b)\u3002<\/span><span class=\"lang-en\"><strong><code>ticker<\/code><\/strong>: The stock or ETF symbol. <strong>Crucially<\/strong>, for international stocks, you must include the exchange prefix. For example: <code>TPE:00878<\/code> (Taiwan), <code>NASDAQ:AAPL<\/code> (USA).<\/span><\/li>\n <li><span class=\"lang-zh\"><strong><code>[attribute]<\/code><\/strong>\uff1a\u60a8\u60f3\u8981\u7372\u53d6\u7684\u7279\u5b9a\u6578\u64da\uff0c\u4f8b\u5982 <code>\"price\"<\/code> (\u50f9\u683c)\u3001<code>\"change\"<\/code> (\u6f32\u8dcc) \u6216 <code>\"marketcap\"<\/code> (\u5e02\u503c)\u3002<\/span><span class=\"lang-en\"><strong><code>[attribute]<\/code><\/strong>: The specific piece of data you want, such as <code>\"price\"<\/code>, <code>\"change\"<\/code>, or <code>\"marketcap\"<\/code>.<\/span><\/li>\n <\/ul>\n <\/section>\n \n <section>\n <h2 class=\"lang-zh\">\u9010\u6b65\u6307\u5357\uff1a\u5efa\u7acb\u60a8\u7684\u81ea\u52d5\u5316\u5100\u8868\u677f<\/h2>\n <h2 class=\"lang-en\">Step-by-Step Guide: Building Your Automated Dashboard<\/h2>\n \n <h3 class=\"lang-zh\">\u6b65\u9a5f 1\uff1a\u5efa\u7acb\u60a8\u7684\u8a66\u7b97\u8868\u7d50\u69cb<\/h3>\n <h3 class=\"lang-en\">Step 1: Structure Your Spreadsheet<\/h3>\n <p class=\"lang-zh\">\u958b\u555f\u4e00\u4efd\u65b0\u7684 Google \u8a66\u7b97\u8868\u4e26\u8a2d\u5b9a\u60a8\u7684\u6b04\u4f4d\u3002\u4e00\u500b\u7a69\u56fa\u7684\u57fa\u790e\u662f\u95dc\u9375\u3002\u6211\u5011\u5c07\u5305\u542b\u975c\u614b\u6578\u64da\uff08\u60a8\u53ea\u9700\u8f38\u5165\u4e00\u6b21\uff09\u548c\u52d5\u614b\u6578\u64da\uff08Google \u6703\u81ea\u52d5\u66f4\u65b0\uff09\u3002<\/p>\n <p class=\"lang-en\">Open a new Google Sheet and set up your columns. A strong foundation is key. We’ll include both static data (what you enter once) and dynamic data (what Google will update).<\/p>\n <table>\n <thead>\n <tr>\n <th><span class=\"lang-zh\">\u80a1\u7968\u4ee3\u78bc<\/span><span class=\"lang-en\">Ticker<\/span><\/th>\n <th><span class=\"lang-zh\">\u516c\u53f8\u540d\u7a31<\/span><span class=\"lang-en\">Company Name<\/span><\/th>\n <th><span class=\"lang-zh\">\u6301\u6709\u80a1\u6578<\/span><span class=\"lang-en\">Shares Owned<\/span><\/th>\n <th><span class=\"lang-zh\">\u8cb7\u5165\u50f9\u683c<\/span><span class=\"lang-en\">Purchase Price<\/span><\/th>\n <th><span class=\"lang-zh\"><strong>\u76ee\u524d\u50f9\u683c<\/strong><\/span><span class=\"lang-en\"><strong>Current Price<\/strong><\/span><\/th>\n <th><span class=\"lang-zh\"><strong>\u76ee\u524d\u5e02\u503c<\/strong><\/span><span class=\"lang-en\"><strong>Market Value<\/strong><\/span><\/th>\n <th><span class=\"lang-zh\"><strong>\u640d\u76ca<\/strong><\/span><span class=\"lang-en\"><strong>Profit \/ Loss<\/strong><\/span><\/th>\n <\/tr>\n <\/thead>\n <\/table>\n \n <h3 class=\"lang-zh\">\u6b65\u9a5f 2\uff1a\u4f7f\u7528\u6b63\u78ba\u7684\u4ee3\u78bc\u5217\u51fa\u60a8\u7684\u6301\u80a1<\/h3>\n <h3 class=\"lang-en\">Step 2: List Your Holdings with Correct Tickers<\/h3>\n <p class=\"lang-zh\">\u5728\u300c\u80a1\u7968\u4ee3\u78bc\u300d\u6b04\uff08\u4f8b\u5982\uff0c\u5132\u5b58\u683c A2\uff09\u4e2d\uff0c\u8f38\u5165\u60a8\u6bcf\u9805\u6301\u80a1\u7684\u5b8c\u6574\u4ee3\u78bc\uff0c\u5305\u542b\u4ea4\u6613\u6240\u524d\u7db4\u3002\u9019\u662f\u78ba\u4fdd\u516c\u5f0f\u80fd\u6b63\u78ba\u904b\u4f5c\u6700\u91cd\u8981\u7684\u4e00\u6b65\u3002<\/p>\n <p class=\"lang-en\">In the “Ticker” column (e.g., cell A2), enter the full ticker symbol for each of your holdings, including the exchange prefix. This is the most important step for ensuring the formulas work correctly.<\/p>\n \n <h3 class=\"lang-zh\">\u6b65\u9a5f 3\uff1a\u7528\u516c\u5f0f\u6293\u53d6\u5373\u6642\u5e02\u5834\u6578\u64da<\/h3>\n <h3 class=\"lang-en\">Step 3: Pull Live Market Data with Formulas<\/h3>\n <p class=\"lang-zh\">\u73fe\u5728\uff0c\u8b93\u6211\u5011\u70ba\u60a8\u7684\u8a66\u7b97\u8868\u6ce8\u5165\u751f\u547d\u529b\u3002\u6211\u5011\u5c07\u4f7f\u7528 A \u6b04\u4e2d\u7684\u4ee3\u78bc\u4f86\u70ba\u6bcf\u4e00\u884c\u6293\u53d6\u5c0d\u61c9\u7684\u6578\u64da\u3002<\/p>\n <p class=\"lang-en\">Now, let’s bring your sheet to life. We will use the ticker in column A to pull data for each corresponding row.<\/p>\n <ul>\n <li><span class=\"lang-zh\"><strong>\u516c\u53f8\u540d\u7a31 (\u5132\u5b58\u683c B2)\uff1a<\/strong><\/span><span class=\"lang-en\"><strong>Company Name (Cell B2):<\/strong><\/span> <pre><code>=GOOGLEFINANCE(A2, \"name\")<\/code><\/pre><\/li>\n <li><span class=\"lang-zh\"><strong>\u76ee\u524d\u50f9\u683c (\u5132\u5b58\u683c E2)\uff1a<\/strong><\/span><span class=\"lang-en\"><strong>Current Price (Cell E2):<\/strong><\/span> <pre><code>=GOOGLEFINANCE(A2, \"price\")<\/code><\/pre><\/li>\n <\/ul>\n <p class=\"lang-zh\">\u7576\u60a8\u5728\u7b2c\u4e00\u500b\u8cc7\u6599\u5217\u8f38\u5165\u5b8c\u516c\u5f0f\u5f8c\uff0c\u53ea\u9700\u9ede\u64ca\u5132\u5b58\u683c\u53f3\u4e0b\u89d2\u7684\u5c0f\u85cd\u8272\u65b9\u584a\uff0c\u7136\u5f8c\u5411\u4e0b\u62c9\u52d5\uff0c\u5373\u53ef\u5c07\u516c\u5f0f\u61c9\u7528\u5230\u60a8\u6240\u6709\u7684\u6301\u80a1\u4e0a\u3002<\/p>\n <p class=\"lang-en\">Once you’ve entered the formulas in the first data row, simply click the small blue square in the corner of the cell and drag it down to apply the formulas to all your holdings.<\/p>\n \n <h3 class=\"lang-zh\">\u6b65\u9a5f 4\uff1a\u8a08\u7b97\u60a8\u7684\u6295\u8cc7\u7d44\u5408\u8868\u73fe<\/h3>\n <h3 class=\"lang-en\">Step 4: Calculate Your Portfolio’s Performance<\/h3>\n <p class=\"lang-zh\">\u96a8\u8457\u5373\u6642\u6578\u64da\u7684\u6d41\u5165\uff0c\u60a8\u73fe\u5728\u53ef\u4ee5\u7528\u7c21\u55ae\u7684\u7b97\u8853\u4f86\u8a08\u7b97\u60a8\u7684\u95dc\u9375\u7e3e\u6548\u6307\u6a19\u3002<\/p>\n <p class=\"lang-en\">With live data flowing in, you can now calculate your key performance metrics using simple arithmetic.<\/p>\n <ul>\n <li><span class=\"lang-zh\"><strong>\u76ee\u524d\u5e02\u503c (\u5132\u5b58\u683c F2)\uff1a<\/strong> <pre><code>=C2 * E2<\/code><\/pre> (\u6301\u6709\u80a1\u6578 * \u76ee\u524d\u50f9\u683c)<\/span><span class=\"lang-en\"><strong>Market Value (Cell F2):<\/strong> <pre><code>=C2 * E2<\/code><\/pre> (Shares Owned * Current Price)<\/span><\/li>\n <li><span class=\"lang-zh\"><strong>\u640d\u76ca (\u5132\u5b58\u683c G2)\uff1a<\/strong> <pre><code>=(E2 - D2) * C2<\/code><\/pre> ((\u76ee\u524d\u50f9\u683c – \u8cb7\u5165\u50f9\u683c) * \u6301\u6709\u80a1\u6578)<\/span><span class=\"lang-en\"><strong>Profit \/ Loss (Cell G2):<\/strong> <pre><code>=(E2 - D2) * C2<\/code><\/pre> ((Current Price – Purchase Price) * Shares Owned)<\/span><\/li>\n <\/ul>\n \n <h3 class=\"lang-zh\">\u6b65\u9a5f 5\uff1a\u8996\u89ba\u5316\u8207\u529f\u80fd\u589e\u5f37<\/h3>\n <h3 class=\"lang-en\">Step 5: Visualize and Enhance<\/h3>\n <p class=\"lang-zh\">\u70ba\u4e86\u8b93\u60a8\u7684\u8ffd\u8e64\u5668\u66f4\u52a0\u5c08\u696d\uff0c\u53ef\u4ee5\u6dfb\u52a0\u4e00\u4e9b\u8996\u89ba\u5316\u5143\u7d20\uff1a<\/p>\n <p class=\"lang-en\">To make your tracker even more professional, add visual elements:<\/p>\n <ul>\n <li><span class=\"lang-zh\"><strong>\u689d\u4ef6\u5f0f\u683c\u5f0f\u8a2d\u5b9a\uff1a<\/strong> \u81ea\u52d5\u70ba\u60a8\u7684\u300c\u640d\u76ca\u300d\u6b04\u4f4d\u4e0a\u8272\u3002\u7da0\u8272\u4ee3\u8868\u7372\u5229\uff0c\u7d05\u8272\u4ee3\u8868\u8667\u640d\u3002(\u524d\u5f80 <code>\u683c\u5f0f > \u689d\u4ef6\u5f0f\u683c\u5f0f\u8a2d\u5b9a<\/code>)\u3002<\/span><span class=\"lang-en\"><strong>Conditional Formatting:<\/strong> Automatically color-code your “Profit \/ Loss” column. Green for gains, red for losses. (Go to <code>Format > Conditional formatting<\/code>).<\/span><\/li>\n <li><span class=\"lang-zh\"><strong>\u6295\u8cc7\u7d44\u5408\u7e3d\u89bd\uff1a<\/strong> \u4f7f\u7528 <code>SUM()<\/code> \u51fd\u5f0f\u4f86\u8a08\u7b97\u60a8\u6574\u500b\u6295\u8cc7\u7d44\u5408\u7684\u7e3d\u5e02\u503c\u548c\u7e3d\u640d\u76ca\u3002<\/span><span class=\"lang-en\"><strong>Portfolio Summary:<\/strong> Use the <code>SUM()<\/code> function to calculate the total market value and total profit\/loss of your entire portfolio.<\/span><\/li>\n <li><span class=\"lang-zh\"><strong>\u5713\u9905\u5716\uff1a<\/strong> \u5efa\u7acb\u5716\u8868\u4f86\u8996\u89ba\u5316\u60a8\u6309\u80a1\u7968\u4ee3\u78bc\u5206\u914d\u7684\u6295\u8cc7\u7d44\u5408\uff0c\u5e6b\u52a9\u60a8\u4e86\u89e3\u662f\u5426\u904e\u5ea6\u96c6\u4e2d\u5728\u67d0\u4e00\u8cc7\u7522\u4e0a\u3002<\/span><span class=\"lang-en\"><strong>Pie Charts:<\/strong> Create a chart to visualize your portfolio allocation by ticker, helping you see if you are overly concentrated in one asset.<\/span><\/li>\n <\/ul>\n <\/section>\n \n \n <section id=\"appendix\">\n <h2 class=\"lang-zh\">\u9644\u9304\uff1a<code>GOOGLEFINANCE<\/code> \u5373\u6642\u6578\u64da\u5c6c\u6027<\/h2>\n <h2 class=\"lang-en\">Appendix: <code>GOOGLEFINANCE<\/code> Real-Time Data Attributes<\/h2>\n <table>\n <thead>\n <tr>\n <th><span class=\"lang-zh\">\u5c6c\u6027<\/span><span class=\"lang-en\">Attribute<\/span><\/th>\n <th><span class=\"lang-zh\">\u529f\u80fd\u8aaa\u660e<\/span><span class=\"lang-en\">What It Does<\/span><\/th>\n <th><span class=\"lang-zh\">\u7bc4\u4f8b\u516c\u5f0f (\u4f7f\u7528 A2)<\/span><span class=\"lang-en\">Example Formula (using A2)<\/span><\/th>\n <\/tr>\n <\/thead>\n <tbody>\n <tr>\n <td><code>\"price\"<\/code><\/td>\n <td><span class=\"lang-zh\">\u76ee\u524d\u6216\u6700\u8fd1\u7684\u50f9\u683c\u3002<\/span><span class=\"lang-en\">Current or most recent price.<\/span><\/td>\n <td><code>=GOOGLEFINANCE(A2, \"price\")<\/code><\/td>\n <\/tr>\n <tr>\n <td><code>\"priceopen\"<\/code><\/td>\n <td><span class=\"lang-zh\">\u5e02\u5834\u958b\u76e4\u6642\u7684\u50f9\u683c\u3002<\/span><span class=\"lang-en\">The price at the opening of the market.<\/span><\/td>\n <td><code>=GOOGLEFINANCE(A2, \"priceopen\")<\/code><\/td>\n <\/tr>\n <tr>\n <td><code>\"high\"<\/code><\/td>\n <td><span class=\"lang-zh\">\u7576\u65e5\u6700\u9ad8\u50f9\u3002<\/span><span class=\"lang-en\">The current day’s high price.<\/span><\/td>\n <td><code>=GOOGLEFINANCE(A2, \"high\")<\/code><\/td>\n <\/tr>\n <tr>\n <td><code>\"low\"<\/code><\/td>\n <td><span class=\"lang-zh\">\u7576\u65e5\u6700\u4f4e\u50f9\u3002<\/span><span class=\"lang-en\">The current day’s low price.<\/span><\/td>\n <td><code>=GOOGLEFINANCE(A2, \"low\")<\/code><\/td>\n <\/tr>\n <tr>\n <td><code>\"volume\"<\/code><\/td>\n <td><span class=\"lang-zh\">\u7576\u65e5\u6210\u4ea4\u91cf\u3002<\/span><span class=\"lang-en\">The current day’s trading volume.<\/span><\/td>\n <td><code>=GOOGLEFINANCE(A2, \"volume\")<\/code><\/td>\n <\/tr>\n <tr>\n <td><code>\"marketcap\"<\/code><\/td>\n <td><span class=\"lang-zh\">\u80a1\u7968\u7684\u5e02\u503c\u3002<\/span><span class=\"lang-en\">The market capitalization of the stock.<\/span><\/td>\n <td><code>=GOOGLEFINANCE(A2, \"marketcap\")<\/code><\/td>\n <\/tr>\n <tr>\n <td><code>\"tradetime\"<\/code><\/td>\n <td><span class=\"lang-zh\">\u6700\u5f8c\u4e00\u7b46\u4ea4\u6613\u7684\u6642\u9593\u3002<\/span><span class=\"lang-en\">The time of the last trade.<\/span><\/td>\n <td><code>=GOOGLEFINANCE(A2, \"tradetime\")<\/code><\/td>\n <\/tr>\n <tr>\n <td><code>\"datadelay\"<\/code><\/td>\n <td><span class=\"lang-zh\">\u6578\u64da\u5ef6\u9072\u7684\u5206\u9418\u6578\u3002<\/span><span class=\"lang-en\">How delayed the data is in minutes.<\/span><\/td>\n <td><code>=GOOGLEFINANCE(A2, \"datadelay\")<\/code><\/td>\n <\/tr>\n <tr>\n <td><code>\"volumeavg\"<\/code><\/td>\n <td><span class=\"lang-zh\">\u5e73\u5747\u6bcf\u65e5\u6210\u4ea4\u91cf\u3002<\/span><span class=\"lang-en\">The average daily trading volume.<\/span><\/td>\n <td><code>=GOOGLEFINANCE(A2, \"volumeavg\")<\/code><\/td>\n <\/tr>\n <tr>\n <td><code>\"pe\"<\/code><\/td>\n <td><span class=\"lang-zh\">\u672c\u76ca\u6bd4 (P\/E ratio)\u3002<\/span><span class=\"lang-en\">The Price-to-Earnings (P\/E) ratio.<\/span><\/td>\n <td><code>=GOOGLEFINANCE(A2, \"pe\")<\/code><\/td>\n <\/tr>\n <tr>\n <td><code>\"eps\"<\/code><\/td>\n <td><span class=\"lang-zh\">\u6bcf\u80a1\u76c8\u9918 (EPS)\u3002<\/span><span class=\"lang-en\">The Earnings Per Share.<\/span><\/td>\n <td><code>=GOOGLEFINANCE(A2, \"eps\")<\/code><\/td>\n <\/tr>\n <tr>\n <td><code>\"high52\"<\/code><\/td>\n <td><span class=\"lang-zh\">52\u9031\u6700\u9ad8\u50f9\u3002<\/span><span class=\"lang-en\">The 52-week high price.<\/span><\/td>\n <td><code>=GOOGLEFINANCE(A2, \"high52\")<\/code><\/td>\n <\/tr>\n <tr>\n <td><code>\"low52\"<\/code><\/td>\n <td><span class=\"lang-zh\">52\u9031\u6700\u4f4e\u50f9\u3002<\/span><span class=\"lang-en\">The 52-week low price.<\/span><\/td>\n <td><code>=GOOGLEFINANCE(A2, \"low52\")<\/code><\/td>\n <\/tr>\n <tr>\n <td><code>\"change\"<\/code><\/td>\n <td><span class=\"lang-zh\">\u76f8\u8f03\u65bc\u524d\u4e00\u4ea4\u6613\u65e5\u6536\u76e4\u50f9\u7684\u50f9\u683c\u8b8a\u52d5\u3002<\/span><span class=\"lang-en\">The change in price since the previous day’s close.<\/span><\/td>\n <td><code>=GOOGLEFINANCE(A2, \"change\")<\/code><\/td>\n <\/tr>\n <tr>\n <td><code>\"changepct\"<\/code><\/td>\n <td><span class=\"lang-zh\">\u50f9\u683c\u8b8a\u52d5\u7684\u767e\u5206\u6bd4\u3002<\/span><span class=\"lang-en\">The percentage change in price.<\/span><\/td>\n <td><code>=GOOGLEFINANCE(A2, \"changepct\")<\/code><\/td>\n <\/tr>\n <tr>\n <td><code>\"closeyest\"<\/code><\/td>\n <td><span class=\"lang-zh\">\u524d\u4e00\u4ea4\u6613\u65e5\u7684\u6536\u76e4\u50f9\u3002<\/span><span class=\"lang-en\">The previous day’s closing price.<\/span><\/td>\n <td><code>=GOOGLEFINANCE(A2, \"closeyest\")<\/code><\/td>\n <\/tr>\n <tr>\n <td><code>\"name\"<\/code><\/td>\n <td><span class=\"lang-zh\">\u8b49\u5238\u7684\u5b8c\u6574\u540d\u7a31\u3002<\/span><span class=\"lang-en\">The full name of the security.<\/span><\/td>\n <td><code>=GOOGLEFINANCE(A2, \"name\")<\/code><\/td>\n <\/tr>\n <tr>\n <td><code>\"ticker\"<\/code><\/td>\n <td><span class=\"lang-zh\">\u80a1\u7968\u4ee3\u78bc (\u53ef\u7528\u65bc\u9a57\u8b49)\u3002<\/span><span class=\"lang-en\">The ticker symbol (useful for validation).<\/span><\/td>\n <td><code>=GOOGLEFINANCE(A2, \"ticker\")<\/code><\/td>\n <\/tr>\n <tr>\n <td><code>\"currency\"<\/code><\/td>\n <td><span class=\"lang-zh\">\u8b49\u5238\u8a08\u50f9\u7684\u8ca8\u5e63\u3002<\/span><span class=\"lang-en\">The currency in which the security is priced.<\/span><\/td>\n <td><code>=GOOGLEFINANCE(A2, \"currency\")<\/code><\/td>\n <\/tr>\n <\/tbody>\n <\/table>\n <\/section>\n \n <footer>\n <p class=\"disclaimer\">\n <em class=\"lang-zh\"><strong>\u514d\u8cac\u8072\u660e\uff1a<\/strong> \u672c\u6307\u5357\u50c5\u4f9b\u53c3\u8003\uff0c\u4e0d\u69cb\u6210\u4efb\u4f55\u8ca1\u52d9\u5efa\u8b70\u3002<code>GOOGLEFINANCE<\/code> \u51fd\u5f0f\u7684\u6578\u64da\u53ef\u80fd\u6709\u6700\u591a20\u5206\u9418\u7684\u5ef6\u9072\uff0c\u4e14\u53ef\u80fd\u7121\u6cd5\u63d0\u4f9b\u6240\u6709\u80a1\u7968\u4ee3\u78bc\u6216\u5c6c\u6027\u7684\u6578\u64da\u3002\u5728\u505a\u51fa\u4efb\u4f55\u6295\u8cc7\u6c7a\u7b56\u524d\uff0c\u8acb\u52d9\u5fc5\u9032\u884c\u60a8\u81ea\u5df1\u7684\u7814\u7a76\u3002<\/em>\n <em class=\"lang-en\"><strong>Disclaimer:<\/strong> This guide is for informational purposes only and does not constitute financial advice. The <code>GOOGLEFINANCE<\/code> function may have data delays of up to 20 minutes and may not have data for all tickers or attributes. Always conduct your own research before making any investment decisions.<\/em>\n <\/p>\n <\/footer>\n <\/article>\n <\/div>\n\n<script>\n \/\/ JavaScript for language toggle functionality\n document.addEventListener('DOMContentLoaded', function() {\n const toggleBtn = document.getElementById('langToggleBtn');\n const guideContainer = document.querySelector('.portfolio-tracker-guide');\n \n if (toggleBtn && guideContainer) {\n toggleBtn.addEventListener('click', () => {\n const currentLang = guideContainer.getAttribute('data-lang');\n if (currentLang === 'zh') {\n guideContainer.setAttribute('data-lang', 'en');\n document.documentElement.lang = 'en';\n toggleBtn.textContent = '\u5207\u63db\u81f3\u4e2d\u6587'; \/\/ Switch to Chinese\n } else {\n guideContainer.setAttribute('data-lang', 'zh');\n document.documentElement.lang = 'zh-Hant';\n toggleBtn.textContent = 'Switch to English';\n }\n });\n }\n });\n<\/script>\n\n<\/body>\n<\/html>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Google Sheets\u80fd\u5c07\u60a8\u7684\u6574\u500b\u6295\u8cc7\u7d44\u5408\u96c6\u4e2d\u5230\u4e00\u500b\u80fd\u8fd1\u4e4e\u5373\u6642\u66f4\u65b0\u7684\u52d5\u614b\u5100\u8868\u677f\u4e2d\u3002 \u544a\u5225\u975c\u614b\u3001\u904e\u6642\u7684\u6578\u64da<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[],"class_list":["post-391","post","type-post","status-publish","format-standard","hentry","category-itai"],"_links":{"self":[{"href":"https:\/\/yinyang.taichi.us.kg\/index.php?rest_route=\/wp\/v2\/posts\/391","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/yinyang.taichi.us.kg\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/yinyang.taichi.us.kg\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/yinyang.taichi.us.kg\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/yinyang.taichi.us.kg\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=391"}],"version-history":[{"count":2,"href":"https:\/\/yinyang.taichi.us.kg\/index.php?rest_route=\/wp\/v2\/posts\/391\/revisions"}],"predecessor-version":[{"id":393,"href":"https:\/\/yinyang.taichi.us.kg\/index.php?rest_route=\/wp\/v2\/posts\/391\/revisions\/393"}],"wp:attachment":[{"href":"https:\/\/yinyang.taichi.us.kg\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=391"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/yinyang.taichi.us.kg\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=391"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/yinyang.taichi.us.kg\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=391"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}