id: 3ac962a1319a491fa80c569a4592b177
parent_id: 
item_type: 1
item_id: b3438179582843149d1a849c63f870c2
item_updated_time: 1764345476119
title_diff: "[{\"diffs\":[[1,\"如何用excel获得股票实时数据？-悠闲奋斗的小强的回答-头条问答\"]],\"start1\":0,\"start2\":0,\"length1\":0,\"length2\":33}]"
body_diff: "[{\"diffs\":[[1,\"<html>\\\r\\\n<head>\\\r\\\n  <title>如何用excel获得股票实时数据？-悠闲奋斗的小强的回答-头条问答</title>\\\r\\\n  <basefont face=\\\"微软雅黑\\\" size=\\\"2\\\" />\\\r\\\n  <meta http-equiv=\\\"Content-Type\\\" content=\\\"text/html;charset=utf-8\\\" />\\\r\\\n  <meta name=\\\"exporter-version\\\" content=\\\"YXBJ Windows/608924 (zh-CN, DDL); Windows/10.0.0 (Win64); EDAMVersion=V2;\\\"/>\\\r\\\n  <style>\\\r\\\n\\tbody, td {\\\r\\\n\\t  font-family: 微软雅黑;\\\r\\\n\\t  font-size: 12pt;\\\r\\\n\\t}\\\r\\\n  </style>\\\r\\\n</head>\\\r\\\n<body>\\\r\\\n<a name=\\\"7879\\\"></a>\\\r\\\n<h1>如何用excel获得股票实时数据？-悠闲奋斗的小强的回答-头条问答</h1>\\\r\\\n\\\r\\\n<div><span>\\\n  <div style=\\\"--en-clipped-content:simplified; --en-clipped-source-url:https://wukong.toutiao.com/answer/7056215928182980875/; --en-clipped-source-title:如何用excel获得股票实时数据？-悠闲奋斗的小强的回答-头条问答;\\\">\\\n<div><br/></div><div style=\\\"min-height: 7545px; font-size: 16px; display: block; min-width: 100%;\\\"> <div style=\\\"background-color:transparent;font:inherit;vertical-align:baseline;\\\"><div style=\\\"background-color:transparent;font:inherit;vertical-align:baseline;font-family:&quot;PT Serif&quot;;font-size:16px;line-height:1.5em;color:rgb(31, 9, 9);text-align:left;\\\"><div style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;\\\"><div style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;width:36em;z-index:200;padding-left:2em;padding-right:2em;margin-left:auto;margin-right:auto;position:relative;\\\"><div style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;position:relative;margin-left:-25px;margin-right:25px;\\\"><div style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;padding-top:0px;padding-bottom:9em;position:relative;\\\"><div style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;margin-bottom:1.5em;\\\"><div style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;position:relative;margin-bottom:0px;\\\"><div style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;margin-bottom:0px;\\\"><div style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;margin-bottom:0px;\\\"><h1 style=\\\"font-family:&quot;PT Serif&quot;;text-align:left;border:0px;font:inherit;vertical-align:baseline;font-size:35px;font-weight:normal;line-height:35px;margin-bottom:20px;padding:0px;margin:0px;\\\">如何用excel获得股票实时数据？-悠闲奋斗的小强的回答-头条问答</h1><div style=\\\"padding:0px;border:0px;font:inherit;vertical-align:baseline;position:relative;height:1em;line-height:1;text-align:center;margin:0px;padding-top:1.5em;padding-bottom:1.5em;margin-bottom:0px;\\\"><div style=\\\"padding:0px;border:0px;font:inherit;vertical-align:baseline;background:-webkit-linear-gradient(0deg, rgb(243, 242, 238) 1%, rgb(31, 9, 9) 50%, rgb(243, 242, 238) 99%);position:absolute;left:-4em;top:50%;z-index:10;width:100%;padding-left:4em;padding-right:4em;height:0.1em;opacity:0.5;margin:0px;margin-bottom:0px;\\\"><span style=\\\"font:inherit;position:absolute;left:-4em;top:50%;z-index:10;width:100%;padding-left:4em;padding-right:4em;height:0.1em;margin:0px;opacity:0.5;background:-webkit-linear-gradient(0deg, rgb(243, 242, 238) 1%, rgb(31, 9, 9) 50%, rgb(243, 242, 238) 99%);\\\"></span></div></div></div>       <p style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;margin-bottom:1.5em;\\\">如何用Excel获取实时股票数据 </p><p style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;margin-bottom:1.5em;\\\">#如何用excel获得股票实时数据# </p><p style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;margin-bottom:1.5em;\\\">首先找一个提供股票数据的网站，各种财经网站都有股票数据，我们以东方财富网为例：</p><div style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;margin-bottom:1.5em;\\\"><div style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;display:block;text-align:center;margin-top:1em;margin-bottom:0px;\\\"><img src=\\\"如何用excel获得股票实时数据？-悠闲奋斗的小强的回答-头条问答_files/25ebf7118c0f442f8c2fbd0eb22ec25a\\\" type=\\\"image/jpeg\\\" data-filename=\\\"25ebf7118c0f442f8c2fbd0eb22ec25a\\\" height=\\\"513\\\" style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;display:block;max-width:100%;\\\" width=\\\"576\\\"/></div></div><p style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;margin-bottom:1.5em;\\\">沪深A股数据，我们在谷歌浏览器中查看真实网址：</p><div style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;margin-bottom:1.5em;\\\"><div style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;display:block;text-align:center;margin-top:1em;margin-bottom:0px;\\\"><img src=\\\"如何用excel获得股票实时数据？-悠闲奋斗的小强的回答-头条问答_files/df776e441cc5496c8884618f31102303\\\" type=\\\"image/jpeg\\\" data-filename=\\\"df776e441cc5496c8884618f31102303\\\" height=\\\"341\\\" style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;display:block;max-width:100%;\\\" width=\\\"576\\\"/></div></div><p style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;margin-bottom:1.5em;\\\">找到jQuery行，对应的就是股票数据，然后看头文件中的网址：</p><div style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;margin-bottom:1.5em;\\\"><div style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;display:block;text-align:center;margin-top:1em;margin-bottom:0px;\\\"><img src=\\\"如何用excel获得股票实时数据？-悠闲奋斗的小强的回答-头条问答_files/4a0710131cf84f2c8982f9e82698814f\\\" type=\\\"image/jpeg\\\" data-filename=\\\"4a0710131cf84f2c8982f9e82698814f\\\" height=\\\"338\\\" style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;display:block;max-width:100%;\\\" width=\\\"576\\\"/></div></div><p style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;margin-bottom:1.5em;\\\">复制这段网址，到Excel中，数据==&gt; 自网站：</p><div style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;margin-bottom:1.5em;\\\"><div style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;display:block;text-align:center;margin-top:1em;margin-bottom:0px;\\\"><img src=\\\"如何用excel获得股票实时数据？-悠闲奋斗的小强的回答-头条问答_files/a412b490864a4f349a175e1956e84b37\\\" type=\\\"image/jpeg\\\" data-filename=\\\"a412b490864a4f349a175e1956e84b37\\\" height=\\\"340\\\" style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;display:block;max-width:100%;\\\" width=\\\"576\\\"/></div></div><p style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;margin-bottom:1.5em;\\\">点击去确定，就会打开Power Query编辑器，如果一切顺利，会直接出现数据：</p><div style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;margin-bottom:1.5em;\\\"><div style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;display:block;text-align:center;margin-top:1em;margin-bottom:0px;\\\"><img src=\\\"如何用excel获得股票实时数据？-悠闲奋斗的小强的回答-头条问答_files/e3a41eb58e8e45b7b4a496dc20f32b12\\\" type=\\\"image/jpeg\\\" data-filename=\\\"e3a41eb58e8e45b7b4a496dc20f32b12\\\" height=\\\"125\\\" style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;display:block;max-width:100%;\\\" width=\\\"576\\\"/></div></div><p style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;margin-bottom:1.5em;\\\">虽然不是表格，但证明是抓取成功了，接下来就是怎么解析这个二进制文件，从谷歌浏览器中看，这是个jsoncallback数据包，比json数据多了一个函数名称，我们只是需要提取两个括号中间的数据就能用json解析。注意total：4440，等下我们会用到这个数值。</p><div style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;margin-bottom:1.5em;\\\"><div style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;display:block;text-align:center;margin-top:1em;margin-bottom:0px;\\\"><img src=\\\"如何用excel获得股票实时数据？-悠闲奋斗的小强的回答-头条问答_files/be156421d8054478b9b2b2c80dbf3051\\\" type=\\\"image/jpeg\\\" data-filename=\\\"be156421d8054478b9b2b2c80dbf3051\\\" height=\\\"158\\\" style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;display:block;max-width:100%;\\\" width=\\\"576\\\"/></div></div><p style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;margin-bottom:1.5em;\\\">=Json.Document(Text.BetweenDelimiters(Text.FromBinary(Web.Contents(url)),&quot;(&quot;,&quot;)&quot;)) </p><div style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;margin-bottom:1.5em;\\\"><div style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;display:block;text-align:center;margin-top:1em;margin-bottom:0px;\\\"><img src=\\\"如何用excel获得股票实时数据？-悠闲奋斗的小强的回答-头条问答_files/d3f44ca17c0b4f8e953afc052bc10c10\\\" type=\\\"image/jpeg\\\" data-filename=\\\"d3f44ca17c0b4f8e953afc052bc10c10\\\" height=\\\"129\\\" style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;display:block;max-width:100%;\\\" width=\\\"576\\\"/></div></div><p style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;margin-bottom:1.5em;\\\">然后展开数据表：</p><div style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;margin-bottom:1.5em;\\\"><div style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;display:block;text-align:center;margin-top:1em;margin-bottom:0px;\\\"><img src=\\\"如何用excel获得股票实时数据？-悠闲奋斗的小强的回答-头条问答_files/850cce64de9a4fe3b2e6e29f859ce8d2\\\" type=\\\"image/jpeg\\\" data-filename=\\\"850cce64de9a4fe3b2e6e29f859ce8d2\\\" height=\\\"229\\\" style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;display:block;max-width:100%;\\\" width=\\\"576\\\"/></div></div><p style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;margin-bottom:1.5em;\\\">目前为止一切到很顺利，但是我们抓取的只是其中一页的数据，我们来看：</p><div style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;margin-bottom:1.5em;\\\"><div style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;display:block;text-align:center;margin-top:1em;margin-bottom:0px;\\\"><img src=\\\"如何用excel获得股票实时数据？-悠闲奋斗的小强的回答-头条问答_files/0465949b7f2249bd8f317833844fd486\\\" type=\\\"image/jpeg\\\" data-filename=\\\"0465949b7f2249bd8f317833844fd486\\\" height=\\\"265\\\" style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;display:block;max-width:100%;\\\" width=\\\"576\\\"/></div></div><p style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;margin-bottom:1.5em;\\\">pn是页码，我们抓取的是第3页，pz是每页20条数据，我们有两种方法来抓取全部数据，一种是沿用这个pz：20，然后定义函数，抓取全部页码，这个我在之前的抓取中反复用到，今天我们来尝试直接修改pz一次抓取全部数据，其实查询参数都可以试着改变一下，如果我们把pn改成4，抓取的就是第4页的20条，同样道理，我们来修改pn为200，看看是不是直接就能抓取200条数据。</p><div style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;margin-bottom:1.5em;\\\"><div style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;display:block;text-align:center;margin-top:1em;margin-bottom:0px;\\\"><img src=\\\"如何用excel获得股票实时数据？-悠闲奋斗的小强的回答-头条问答_files/1e99236f945c4010827e46c5c01577c7\\\" type=\\\"image/jpeg\\\" data-filename=\\\"1e99236f945c4010827e46c5c01577c7\\\" height=\\\"334\\\" style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;display:block;max-width:100%;\\\" width=\\\"576\\\"/></div></div><p style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;margin-bottom:1.5em;\\\">那么我们试一下直接输入5000，可不可以全部抓取：</p><div style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;margin-bottom:1.5em;\\\"><div style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;display:block;text-align:center;margin-top:1em;margin-bottom:0px;\\\"><img src=\\\"如何用excel获得股票实时数据？-悠闲奋斗的小强的回答-头条问答_files/7f58167366b54b709d9c19f46d15ff24\\\" type=\\\"image/jpeg\\\" data-filename=\\\"7f58167366b54b709d9c19f46d15ff24\\\" height=\\\"334\\\" style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;display:block;max-width:100%;\\\" width=\\\"576\\\"/></div></div><p style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;margin-bottom:1.5em;\\\">看起来是可以的。</p><p style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;margin-bottom:1.5em;\\\">还有一个问题，就是数据的标题行全部都是f开头的没有可读性，如何变成网页中的汉字标题行。</p><p style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;margin-bottom:1.5em;\\\">这个问题要稍微复杂一点，我们可能要去查看下代码，看看能不能找到替换的办法，首先看html中的：</p><div style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;margin-bottom:1.5em;\\\"><div style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;display:block;text-align:center;margin-top:1em;margin-bottom:0px;\\\"><img src=\\\"如何用excel获得股票实时数据？-悠闲奋斗的小强的回答-头条问答_files/f2c1bc7158764bcc8fbe7dad33fc8a8f\\\" type=\\\"image/jpeg\\\" data-filename=\\\"f2c1bc7158764bcc8fbe7dad33fc8a8f\\\" height=\\\"203\\\" style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;display:block;max-width:100%;\\\" width=\\\"576\\\"/></div></div><p style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;margin-bottom:1.5em;\\\">但是这个不全，其中有几列是需要自定义的：</p><div style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;margin-bottom:1.5em;\\\"><div style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;display:block;text-align:center;margin-top:1em;margin-bottom:0px;\\\"><img src=\\\"如何用excel获得股票实时数据？-悠闲奋斗的小强的回答-头条问答_files/47696a74fc9c4aada189a79f0d51e2dd\\\" type=\\\"image/jpeg\\\" data-filename=\\\"47696a74fc9c4aada189a79f0d51e2dd\\\" height=\\\"227\\\" style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;display:block;max-width:100%;\\\" width=\\\"576\\\"/></div></div><p style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;margin-bottom:1.5em;\\\">这几个指标没有对应的f编码。</p><p style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;margin-bottom:1.5em;\\\">我们再看看js文件：</p><div style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;margin-bottom:1.5em;\\\"><div style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;display:block;text-align:center;margin-top:1em;margin-bottom:0px;\\\"><img src=\\\"如何用excel获得股票实时数据？-悠闲奋斗的小强的回答-头条问答_files/2dea3338a1ce404ab0a913165a3cd0dd\\\" type=\\\"image/jpeg\\\" data-filename=\\\"2dea3338a1ce404ab0a913165a3cd0dd\\\" height=\\\"340\\\" style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;display:block;max-width:100%;\\\" width=\\\"576\\\"/></div></div><p style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;margin-bottom:1.5em;\\\">这个文件中有对应数据，我们直接复制出来到Power Query中，处理成列表形式备用：</p><div style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;margin-bottom:1.5em;\\\"><div style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;display:block;text-align:center;margin-top:1em;margin-bottom:0px;\\\"><img src=\\\"如何用excel获得股票实时数据？-悠闲奋斗的小强的回答-头条问答_files/afe2a18f3efa41e18ac207253b89a0a8\\\" type=\\\"image/jpeg\\\" data-filename=\\\"afe2a18f3efa41e18ac207253b89a0a8\\\" height=\\\"474\\\" style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;display:block;max-width:100%;\\\" width=\\\"576\\\"/></div></div><p style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;margin-bottom:1.5em;\\\">接下就是匹配表中的key，修改列名称：</p><div style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;margin-bottom:1.5em;\\\"><div style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;display:block;text-align:center;margin-top:1em;margin-bottom:0px;\\\"><img src=\\\"如何用excel获得股票实时数据？-悠闲奋斗的小强的回答-头条问答_files/89fba8cfdda84261bcbae7321cbdb63b\\\" type=\\\"image/jpeg\\\" data-filename=\\\"89fba8cfdda84261bcbae7321cbdb63b\\\" height=\\\"289\\\" style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;display:block;max-width:100%;\\\" width=\\\"576\\\"/></div></div><p style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;margin-bottom:1.5em;\\\">首先我们需要匹配出这样一个列表。</p><p style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;margin-bottom:1.5em;\\\">List.RemoveNulls(List.Zip(List.Transform(Table.ColumnNames(data),(x)=&gt;List.RemoveNulls(List.Transform({1..List.Count(n[key])},(y)=&gt;if x=n[key]{y-1} then {x,n[title]{y-1}} else null)))){0}) </p><p style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;margin-bottom:1.5em;\\\">然后我们直接使用Table.RenameColumns函数就可以批量修改列名称了：</p><div style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;margin-bottom:1.5em;\\\"><div style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;display:block;text-align:center;margin-top:1em;margin-bottom:0px;\\\"><img src=\\\"如何用excel获得股票实时数据？-悠闲奋斗的小强的回答-头条问答_files/50786e7fb137476a8a59b58d8c34bb70\\\" type=\\\"image/jpeg\\\" data-filename=\\\"50786e7fb137476a8a59b58d8c34bb70\\\" height=\\\"209\\\" style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;display:block;max-width:100%;\\\" width=\\\"576\\\"/></div></div><p style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;margin-bottom:1.5em;\\\">Table.RenameColumns(data,List.RemoveNulls(List.Zip(List.Transform(Table.ColumnNames(data),(x)=&gt;List.RemoveNulls(List.Transform({1..List.Count(n[key])},(y)=&gt;if x=n[key]{y-1} then {x,n[title]{y-1}} else null)))){0})) </p><p style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;margin-bottom:1.5em;\\\">我们把数据加载到Excel中就可以了。</p><div style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;margin-bottom:1.5em;\\\"><div style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;display:block;text-align:center;margin-top:1em;margin-bottom:0px;\\\"><img src=\\\"如何用excel获得股票实时数据？-悠闲奋斗的小强的回答-头条问答_files/daca130f38664d1db1eaed015a2a2289\\\" type=\\\"image/jpeg\\\" data-filename=\\\"daca130f38664d1db1eaed015a2a2289\\\" height=\\\"235\\\" style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;display:block;max-width:100%;\\\" width=\\\"576\\\"/></div></div><p style=\\\"margin:0px;padding:0px;border:0px;font:inherit;vertical-align:baseline;margin-bottom:0px;\\\">如果要最新数据，直接刷新就可以了</p></div></div></div></div></div></div></div></div></div></div>\\\n</div>\\\n</span>\\\n</div></body></html>\\u0000\"]],\"start1\":0,\"start2\":0,\"length1\":0,\"length2\":17413}]"
metadata_diff: {"new":{"id":"b3438179582843149d1a849c63f870c2","parent_id":"061de1401cfc4cfaadf6e74e015970e9","latitude":"0.00000000","longitude":"0.00000000","altitude":"0.0000","author":"","source_url":"","is_todo":0,"todo_due":0,"todo_completed":0,"source":"joplin-desktop","source_application":"net.cozic.joplin-desktop","application_data":"","order":1764345864096,"markup_language":2,"is_shared":0,"share_id":"","conflict_original_id":"","master_key_id":"","user_data":"","deleted_time":0},"deleted":[]}
encryption_cipher_text: 
encryption_applied: 0
updated_time: 2025-11-28T16:20:23.231Z
created_time: 2025-11-28T16:20:23.231Z
type_: 13