Google表格中的免费API莫斯科证券交易所（MOEX）

This means that almost 2 million newbies without any actual trading experience and lacking any specialized software for trading/position analysis have entered the market.

这意味着几乎有200万没有任何实际交易经验并且缺乏任何用于交易/头寸分析的专业软件的新手进入了市场。

While the broker’s mobile applications designed for trading are continuously updated and, in general, quite user-friendly, the position analysis, particularly when several brokers are used, could raise issues. Google Sheets using free MOEX API may become a free solution equipped with automatically downloaded asset prices and parameters.

尽管经纪人为交易而设计的移动应用程序会不断更新，并且通常来说非常友好，但头寸分析(尤其是在使用多个经纪人时)可能会引起问题。 使用免费的MOEX API的Google表格可以成为具有自动下载的资产价格和参数的免费解决方案。

Google Spreadsheets中的MOEX API (MOEX API in Google Spreadsheets)

There are two options to be used with MOEX API:

MOEX API可以使用两个选项：

• Formulas
  公式
• Google Apps Script
  Google Apps脚本

However, it appears that scripts used in free documents usually confuse people, especially if these people have some investments. People are even more confused if they do not understand the script language. That’s why I would like to focus on formulas only.

但是，似乎免费文档中使用的脚本通常会使人们感到困惑，尤其是当这些人有一些投资的时候。 如果不懂脚本语言，人们会更加困惑。 这就是为什么我只想关注公式。

General description and explanation of all the requests that you can send to MOEX API is provided in the guidebook. However, I, for one, did not find this guidebook that easy to understand, so I had to spend quite a lot of time to cope with it. For that reason, I made a simple Google Sheet with examples I use myself.

指南中提供了可发送到MOEX API的所有请求的一般说明和解释。 但是，我暂时并没有发现该指南那么容易理解，因此我不得不花很多时间来解决它。 因此，我用自己的示例制作了一个简单的Google表格 。

交易模式标识符 (Trading Mode Identifier)

In MOEX API a lot of things depend on Trading Mode Identifier parameter (primary_boardID). You can look up this parameter at their website using the search function.

在MOEX API中，很多事情取决于交易模式标识符参数(primary_boardID)。 您可以使用搜索功能在其网站上查找此参数。

Trading Mode ID 交易模式编号

You can also find this identifier using HTTP request to API:

您还可以使用对API的HTTP请求找到此标识符：

https://iss.moex.com/iss/securities.xml?q=WRITE THE FULL INSTUMENT NAME OR ITS PART HERE https://iss.moex.com/iss/securities.xml?q=WRITE THE FULL INSTUMENT NAME OR ITS PART HERE

Trading Mode ID 交易模式编号

在MOEX检索股票/债券名称 (Retrieve stock / bonds names at MOEX)

It is really convenient that you can get the full security name. You can also get the short security name automatically.

获得完整的安全名称真的很方便。 您还可以自动获取简短的安全名称。

Google SpreadsheetsGoogle试算表

以MOEX检索股票/债券价格 (Retrieve stock / bonds prices at MOEX)

You can use numerous websites to receive prices for Russian assets, but when it comes to MOEX API relevant examples are introduced on this tab.

您可以使用许多网站来获取俄罗斯资产的价格，但是当涉及MOEX API时，此选项卡上会介绍相关示例。

Google SpreadsheetsGoogle试算表

在MOEX检索下次优惠券付款 (Retrieve next coupon payment at MOEX)

You can receive coupon date and its value (either corporate or Federal Loan Bonds (OFZ) and Eurobonds) automatically.

您可以自动接收息票日期及其价值(公司或联邦贷款债券(OFZ)和Eurobonds)。

Google SpreadsheetsGoogle试算表

在MOEX处获取收益 (Retrieve yield at MOEX)

Unfortunately, you can obtain the dividend yield as of a specific date represented in a single formula only for OFZ, as they are very shortlisted. For corporate bonds, you’ll have to pick them out in the script or choose the initial search position manually.

不幸的是，您只能在OFZ的单个公式中获得截至特定日期的股息收益，因为它们的入围非常多。 对于公司债券，您必须在脚本中选择它们或手动选择初始搜索位置。

Google SpreadsheetsGoogle试算表

在MOEX检索报价日期 (Retrieve offer dates at MOEX)

Planning your own funds becomes much easier, when you receive offer dates automatically.

当您自动收到要约日期时，计划自有资金变得容易得多。

Google SpreadsheetsGoogle试算表

结论 (Conclusion)

MOEX API gives you powerful capabilities. In this article I described only those tools that I use as a long-term private investor.

MOEX API为您提供强大的功能。 在本文中，我仅描述了用作长期私人投资者的那些工具。

Please note that I have no relations with Moscow Exchange and I use MOEX API only for personal needs.

请注意，我与Moscow Exchange没有关系，我仅出于个人需要使用MOEX API。

Author: Mikhail Shardin,

作者： Mikhail Shardin ，

February 6, 2020

2020年2月6日

翻译自: https://habr.com/en/post/487436/