{"id":212,"date":"2019-11-10T01:02:27","date_gmt":"2019-11-10T00:02:27","guid":{"rendered":"http:\/\/market-and-us.com\/blog\/?p=212"},"modified":"2021-04-08T12:27:54","modified_gmt":"2021-04-08T10:27:54","slug":"how-to-get-historical-stock-data","status":"publish","type":"post","link":"https:\/\/market-and-us.com\/blog\/how-to-get-historical-stock-data-212\/","title":{"rendered":"How to get historical stock data"},"content":{"rendered":"\n

In the first three articles about coding with financial data (How to code a backtest<\/a>, How to code a basic stock scanner<\/a> and How to code the first indicators<\/a>) I did not mention how to get historical stock data.<\/p>\n\n\n\n

You will know about it after reading this article! \ud83d\ude42<\/p>\n\n\n\n

Historical stock data<\/h2>\n\n\n\n

<\/mark>To create a candlestick chart you need four prices for each candle<\/strong>:
The price when market opened and closed, the high of the time period the candle represents and the low. In addition to that the volume is useful. It’s the number of shares traded<\/strong> in the time period (= 1 day, 1 week, 1 month, 1 minute, … per candle).<\/p>\n\n\n\n

For our example we use daily candles, so we need the date\/day, open, close, high, low and volume.<\/p>\n\n\n\n

You know from the other articles that the best module for data sets is pandas<\/code>. You can simply import it in your code with<\/p>\n\n\n\n

import pandas<\/code><\/pre>\n\n\n\n
The 6 best sources for stock data<\/h2>\n\n\n\n
For collecting the data we have several possibilities<\/strong>:<\/p>\n\n\n\n
  1. Yahoo Data<\/li>
  2. IEX Cloud<\/li>
  3. Alpha Vantage<\/li>
  4. Quandl<\/li>
  5. Quantopian<\/li>
  6. IB API<\/li><\/ol>\n\n\n\n
    To be honest, I tried all of them but I do not like all of them.<\/p>\n\n\n\n
    In the beginning of my first financial applications in Python<\/strong> I used the Yahoo API but then they stopped this service and I searched for an alternative.
    Alpha Vantage<\/a> should be one of the easiest but I didn’t get it run except some errors and the Quandl<\/a> system, website and data feeds seemed too complicated for me (but maybe one of them is perfect for you<\/em>).
    Quantopian has a very high quality and a helpful community but you have to use their own environment. I coded many backtests there but<\/s> I like to have my own data and my own code to know that every mistake is mine and not one of another system.<\/p>\n\n\n\n
    Why I finally ended up with <\/strong>Yahoo<\/strong><\/a> and why I am also working with the most complicated API <\/strong>(Interactive Brokers API<\/a>), you will learn in the next sections.<\/p>\n\n\n\n
    What about Yahoo Finance?<\/h2>\n\n\n\n
    Yes, you got it right. Yahoo stopped it’s API service but I am using Yahoo data again.<\/p>\n\n\n\n
    You can enter a ticker symbol on the Yahoo Finance page and then after choosing the tab “Historical Data<\/strong>” you can select time period and frequency and download a csv<\/code>-file like the ones we used for our last examples by clicking the little link called “Download Data”.<\/p>\n\n\n\n
    And whenever data is displayed online or can be downloaded there are ways to do the steps automatically<\/strong> and “collect” the data in a variable.<\/p>\n\n\n\n
    This isn’t legal in every context but because there are modules created for and Yahoo didn’t block anything like that, we can use it for some stocks. I wouldn’t recommend to load huge amounts of data because it isn’t an official API but you can use it for your own single charts<\/strong>, some calculations or our examples<\/strong>.<\/p>\n\n\n\n
    But now enough words about the theory.<\/p>\n\n\n\n
    Get your candles from Yahoo<\/h3>\n\n\n\n
    As I wrote above, there’s already a module (library) written for this purpose. It changed from fix-yahoo-finance<\/code> (because it fixed the old API-library pandas_datareader<\/code>) to yfinance<\/a><\/code>. <\/p>\n\n\n\n
    Like every module you can add it (and same for pandas<\/code>) simply by<\/p>\n\n\n\n
    pip3 install yfinance\npip3 install pandas<\/code><\/pre>\n\n\n\n
    In our example we want to fill in the Yahoo data for <\/span>XOM<\/span><\/strong> into a pandas DataFrame<\/code>:<\/p>\n\n\n\n
    import yfinance as yf\n\nticker  = \"XOM\"\ndata    = yf.download(ticker, start=\"2018-11-08\", end=\"2019-11-08\")<\/code><\/pre>\n\n\n\n
    To show the last 5 or more rows<\/span> of our data and to check if the returned variable data<\/code> is really a DataFrame, we can add these lines: <\/p>\n\n\n\n
    print(\"Last 5 rows:\")\nprint(data.tail())\nprint(\"And the data type:\", type(data))<\/code><\/pre>\n\n\n\n
    Because we always need to handle dates in our codes, I will now change the example to a version without the (disturbing) progress bar and some date functions<\/span> but with exactly the same result:<\/p>\n\n\n\n
    import yfinance as yf\nfrom datetime import datetime, timedelta\n\nticker      = \"XOM\"\n\ndate_format = \"%Y-%m-%d\"\ntoday       = datetime.now().strftime(date_format)\nfrom_date   = (datetime.now() - timedelta(days=365)).strftime(date_format)\n\ndata        = yf.download(ticker, start=from_date, end=today, progress=False)\n\nprint(\"Last 5 rows:\")\nprint(data.tail())\nprint(\"And the data type:\", type(data))<\/code><\/pre>\n\n\n\n
    More stock data…<\/h3>\n\n\n\n
    If you need more than one stock<\/span> for your calculations you can just enter several tickers like \"XOM PG EDIT\"<\/code>. Here you have to work with 2 levels of columns<\/span>:<\/p>\n\n\n\n
    import yfinance as yf\nfrom datetime import datetime, timedelta\n\nticker      = \"XOM PG EDIT\"\ndata        = yf.download(ticker, start=\"2018-11-08\", end=\"2019-11-08\", progress=False)\n\nprint(\"Last 5 rows:\")\nprint(data.tail())\nprint(\"And the data type:\", type(data))\n\nprint(data.Close.EDIT.tail())\nprint(data.Volume.XOM.tail())\nprint(data.columns)<\/code><\/pre>\n\n\n\n
    Personally, I do not like this style of DataFrame<\/code>. I prefer to use yf.download()<\/code> several times. It’s a little bit slower but much easier to handle<\/span> in my opinion.<\/p>\n\n\n\n
    It’s simple and easy, isn’t it? That’s why I like Yahoo<\/span> as a source for historical stock data when I need just some ticker symbols<\/span>.<\/p><\/blockquote>\n\n\n\n
    With the DataFrame<\/code> full of price data you can do all the calculations<\/strong> you want and those you find here on Market and Us<\/strong>. Many of them will follow!<\/p>\n\n\n\n
    No limits? IB API!<\/h2>\n\n\n\n
    Why do we need more<\/strong>? Isn’t it enough?<\/p>\n\n\n\n
    No. You already read that Yahoo isn’t for bigger amounts of stock data. And what about the trading itself? Wouldn’t it be marvelous to scan for good setups and to set the calculated orders directly?<\/strong><\/p>\n\n\n\n
    Of course! And that is what’s possible with the API of Interactive Brokers<\/strong> (IB).
    To be correct I must mention that the IEX Cloud and Quantopian can both be used also to trade live. But you know: I do not like them. And I already use IB as my broker (= cheap, all in one place and an ugly antiquated trading software \ud83d\ude09 ; the app is getting better and better).<\/em><\/p>\n\n\n\n
    I will just focus on handling historical data<\/strong> because that’s the title of this article. But because it isn’t easy to install the official API and to handle the objects, more articles<\/strong> about IB and its API will follow.<\/p>\n\n\n\n
    Tricks for the IB API<\/h3>\n\n\n\n
    Nevertheless, a few important things:<\/p>\n\n\n\n
    • Activate the Read-Only-Mode<\/strong> in your Setup. Then it isn’t possible to set orders or do anything what would change your portfolio.<\/li>
    • TWS or the Gateway must be open<\/strong> for getting access to the API.<\/li>
    • The official API (unlike the easier but less powerful module ibPy<\/code>) is object-oriented<\/strong>. You cannot write the code from top to bottom. There are “Threads” running catching the data you want.<\/li>
    • It’s much easier at the beginning to use a frame of code<\/strong> and add some features step by step than building everything for your own.<\/li><\/ul>\n\n\n\n
      The module importing section<\/h3>\n\n\n\n
      For the IB API we need more modules<\/span>:<\/p>\n\n\n\n
      from ibapi.wrapper import EWrapper\nfrom ibapi.client import EClient\nfrom ibapi.contract import Contract\nfrom ibapi.common import BarData, TickerId\n\nimport pandas as pd\nfrom datetime import datetime<\/code><\/pre>\n\n\n\n
      The EWrapper<\/code> and EClient<\/code> are the main classes<\/span> (you will learn more about classes later in a separate article<\/em>) of the API. Contract<\/code> is a data type (also a class) for contracts like stocks, currencies, futures and options. And BarData<\/code> and TickerId<\/code> are used for functions within our code.
      To make it easier for later projects you can import all parts of a module with from ibapi.common import *<\/code>.
      The last two modules are well-known from above.<\/p>\n\n\n\n
      The main class for API projects<\/h3>\n\n\n\n
      When you do not need the individual classes you can combine EWrapper<\/code> and EClient<\/code> to one class. Here is the basic class<\/span> with the __init__<\/code> function:<\/p>\n\n\n\n
      class ibApp(EWrapper, EClient):\n    def __init__(self, ipaddress, portid, clientid):\n        EWrapper.__init__(self)\n        EClient.__init__(self, wrapper=self)\n\n        self.connect(ipaddress, portid, clientid)\n\n        self.data = pd.DataFrame(columns=['Open', 'High', 'Low', 'Close', 'Volume'])<\/code><\/pre>\n\n\n\n
      Whenever a variable is declared as ibApp<\/code> (you can use another name if you want), the __init__<\/code> function is called. Here both basic classes (it’s called inheritance<\/span>) are initialized, the function connect<\/code> of the class ibApp<\/code> is called (it’s in the library, so we do not need it here but we have to set three parameters: the IP address, the port and the client ID) and I already added the initialization of our DataFrame<\/code> we want to get filled.<\/p>\n\n\n\n
      By using inherited classes you can add your own lines of code to the functions but you do not have to.<\/strong><\/p>\n\n\n\n
      And the main code<\/h3>\n\n\n\n
      Yes, I call it the main code but it’s only the outer frame<\/span> of the code:<\/p>\n\n\n\n
      def main():\n    try:\n        app         = ibApp(\"127.0.0.1\", 7496, 999)\n\n        tickerId    = 4000\n        stock       = setContract(\"XOM\")\n        date_format = \"%Y%m%d %H:%M:%S\"\n        endDateTime = datetime.now().strftime(date_format)\n        duration    = \"1 Y\"\n        candleSize  = \"1 day\"\n\n        app.reqHistoricalData(tickerId, stock, endDateTime, duration, candleSize, \"TRADES\", 1, 1, False, []) \n\n        app.run()\n    except Exception as e:\n        print(\"It's a mistake, I am sorry ({}).\".format(str(e)))\n    finally:\n        app.disconnect()\n\nif __name__ == '__main__':\n    main()<\/code><\/pre>\n\n\n\n
      To shorten the explanation:
      Our main class is initialized with the parameters (the port must be the same as entered in TWS\/Gateway setup!<\/em>), a contract and the start and end of our data stream are set, the request as well as the app is started<\/span> and we catch some errors.<\/p>\n\n\n\n
      For a better overview I outsourced to set the contract<\/span>:<\/p>\n\n\n\n
      def setContract(CSymbol, CSecType=\"STK\", CExchange=\"ISLAND\", CCurrency=\"USD\"):\n    stock = Contract()\n    stock.symbol = CSymbol\n    stock.secType = CSecType\n    stock.exchange = CExchange\n    stock.currency = CCurrency\n\n    return stock<\/code><\/pre>\n\n\n\n
      An interesting point is the exchange of the contract. Instead of selecting the right exchange (like NYSE or NASDAQ) you simply set \"ISLAND\"<\/span><\/code> for US stocks<\/span>. For German stocks it’s \"IBIS\"<\/code> (the former name for XETRA) most of the time. <\/p>\n\n\n\n
      But what about IB’s historical stock data?<\/h3>\n\n\n\n
      The code can already be started, but nothing would happen. Okay, you’ll see some lines with the results of checking the market data. But what about the results of our request in the __init__<\/code> function?<\/p>\n\n\n\n
      Two functions (part of the ibApp<\/code>-class) are called as a result of our request<\/span> and we have to include them and add our own code elements:<\/p>\n\n\n\n
          def historicalData(self, reqId:int, bar: BarData):\n        row = [ bar.open, bar.high, bar.low, bar.close, bar.volume ]\n        self.data.loc[ datetime.strptime(bar.date, \"%Y%m%d\").strftime(\"%Y-%m-%d\") ] = row\n\n    def historicalDataEnd(self, reqId: int, start: str, end: str):\n        super().historicalDataEnd(reqId, start, end)\n\n        print(self.data.tail())\n        print(type(self.data))\n\n        self.done = True<\/code><\/pre>\n\n\n\n
      Every moment one data package of a candle is received by our code the function historicalData<\/code> is called. We can find the historical stock data for one candle in the variable bar<\/code>.
      So we sort this candle data as a row<\/code> and add it to our DataFrame<\/code> with the new formatted date as index.<\/p>\n\n\n\n
      When this process is finished and all candles are received historicalDataEnd<\/code> is called. And because in this moment we do not need anything anymore we can show the last 5 candles, the type of the variable as above and then tell the class that we’re done<\/span> with everything and finish our program.<\/p>\n\n\n\n
      Complicated?<\/strong> Yes!<\/p>\n\n\n\n
      But you know already what’s possible with the IB API. It’s hard to understand the complex object-oriented and thread-controlled API system<\/strong>. For some challenges you have to change the source code of the module for yourself.
      The complexity is based on almost direct access to the interactions with the IB servers<\/strong>. Therefore, the scope of all functions is enormous. Everything is possible!<\/strong><\/p><\/blockquote>\n\n\n\n
      Of course, I will write more detailed articles about the parts of coding with the IB API. And more features will follow: Requesting fundamental data<\/span>, details about your current running trades<\/span> and order setting<\/span>.
      And to be informed about every new article and theme you should enter your email address in the form on the right and subscribe to our newsletter<\/strong>. We would be happy to send you the news!<\/p>\n\n\n\n
      Happy coding with the two methods of this article!<\/p>\n","protected":false},"excerpt":{"rendered":"
      In the first three articles about coding with financial data (How to code a backtest, How to code a basic stock scanner and How to code the first indicators) I did not mention how to get historical stock data. You will know about it after reading this article! \ud83d\ude42 Historical stock data To create a […]<\/p>\n","protected":false},"author":1,"featured_media":231,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"yasr_overall_rating":0,"yasr_post_is_review":"","yasr_auto_insert_disabled":"","yasr_review_type":""},"categories":[7],"tags":[49,50,20,55,48,25,52,53,54,21,29,51],"yoast_head":"\nHow to get historical stock data - The Market and Us<\/title>\n<meta name=\"description\" content=\"Here you can learn how to get historical stock data. Read about your possiblities like Yahoo, Interactive Brokers (IB) and others with concrete code\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/market-and-us.com\/blog\/how-to-get-historical-stock-data-212\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to get historical stock data - The Market and Us\" \/>\n<meta property=\"og:description\" content=\"Here you can learn how to get historical stock data. Read about your possiblities like Yahoo, Interactive Brokers (IB) and others with concrete code\" \/>\n<meta property=\"og:url\" content=\"https:\/\/market-and-us.com\/blog\/how-to-get-historical-stock-data-212\/\" \/>\n<meta property=\"og:site_name\" content=\"The Market and Us\" \/>\n<meta property=\"article:published_time\" content=\"2019-11-10T00:02:27+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-04-08T10:27:54+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/market-and-us.com\/blog\/wp-content\/uploads\/2019\/11\/robot-playing-piano.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"967\" \/>\n\t<meta property=\"og:image:height\" content=\"725\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\">\n\t<meta name=\"twitter:data1\" content=\"9 minutes\">\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebSite\",\"@id\":\"https:\/\/market-and-us.com\/blog\/#website\",\"url\":\"https:\/\/market-and-us.com\/blog\/\",\"name\":\"The Market and Us\",\"description\":\"Weekly Analysis of the Stock Market, Financial Coding and Online-Tools\",\"publisher\":{\"@id\":\"https:\/\/market-and-us.com\/blog\/#\/schema\/person\/f32a93c5a88a9ec9a9595fff6179b097\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":\"https:\/\/market-and-us.com\/blog\/?s={search_term_string}\",\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/market-and-us.com\/blog\/how-to-get-historical-stock-data-212\/#primaryimage\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/market-and-us.com\/blog\/wp-content\/uploads\/2019\/11\/robot-playing-piano.jpg\",\"contentUrl\":\"https:\/\/market-and-us.com\/blog\/wp-content\/uploads\/2019\/11\/robot-playing-piano.jpg\",\"width\":967,\"height\":725,\"caption\":\"We can control our historical data like the robot the piano.\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/market-and-us.com\/blog\/how-to-get-historical-stock-data-212\/#webpage\",\"url\":\"https:\/\/market-and-us.com\/blog\/how-to-get-historical-stock-data-212\/\",\"name\":\"How to get historical stock data - The Market and Us\",\"isPartOf\":{\"@id\":\"https:\/\/market-and-us.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/market-and-us.com\/blog\/how-to-get-historical-stock-data-212\/#primaryimage\"},\"datePublished\":\"2019-11-10T00:02:27+00:00\",\"dateModified\":\"2021-04-08T10:27:54+00:00\",\"description\":\"Here you can learn how to get historical stock data. Read about your possiblities like Yahoo, Interactive Brokers (IB) and others with concrete code\",\"breadcrumb\":{\"@id\":\"https:\/\/market-and-us.com\/blog\/how-to-get-historical-stock-data-212\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/market-and-us.com\/blog\/how-to-get-historical-stock-data-212\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/market-and-us.com\/blog\/how-to-get-historical-stock-data-212\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"item\":{\"@type\":\"WebPage\",\"@id\":\"https:\/\/market-and-us.com\/blog\/\",\"url\":\"https:\/\/market-and-us.com\/blog\/\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"position\":2,\"item\":{\"@id\":\"https:\/\/market-and-us.com\/blog\/how-to-get-historical-stock-data-212\/#webpage\"}}]},{\"@type\":\"Article\",\"@id\":\"https:\/\/market-and-us.com\/blog\/how-to-get-historical-stock-data-212\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/market-and-us.com\/blog\/how-to-get-historical-stock-data-212\/#webpage\"},\"author\":{\"@id\":\"https:\/\/market-and-us.com\/blog\/#\/schema\/person\/f32a93c5a88a9ec9a9595fff6179b097\"},\"headline\":\"How to get historical stock data\",\"datePublished\":\"2019-11-10T00:02:27+00:00\",\"dateModified\":\"2021-04-08T10:27:54+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/market-and-us.com\/blog\/how-to-get-historical-stock-data-212\/#webpage\"},\"commentCount\":9,\"publisher\":{\"@id\":\"https:\/\/market-and-us.com\/blog\/#\/schema\/person\/f32a93c5a88a9ec9a9595fff6179b097\"},\"image\":{\"@id\":\"https:\/\/market-and-us.com\/blog\/how-to-get-historical-stock-data-212\/#primaryimage\"},\"keywords\":[\"candles\",\"candlesticks\",\"code\",\"explanation\",\"historical data\",\"how to code\",\"IB\",\"Interactive Brokers\",\"pandas\",\"Python\",\"stock\",\"Yahoo\"],\"articleSection\":[\"Knowledge\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/market-and-us.com\/blog\/how-to-get-historical-stock-data-212\/#respond\"]}]},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/market-and-us.com\/blog\/#\/schema\/person\/f32a93c5a88a9ec9a9595fff6179b097\",\"name\":\"Alexander\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/market-and-us.com\/blog\/#personlogo\",\"inLanguage\":\"en-US\",\"url\":\"http:\/\/market-and-us.com\/blog\/wp-content\/uploads\/2019\/10\/redakteur-96x96.png\",\"contentUrl\":\"http:\/\/market-and-us.com\/blog\/wp-content\/uploads\/2019\/10\/redakteur-96x96.png\",\"caption\":\"Alexander\"},\"logo\":{\"@id\":\"https:\/\/market-and-us.com\/blog\/#personlogo\"},\"description\":\"Alexander bought his first stock in October 2009 without knowing about the luck for this point of time. In 2016 he started to trade, since 2017 he notes down watchlists and statistics every day and because he knows how to code since he was a child, he uses Python, PHP, HTML5 and JS for making the daily to-dos easier. Because many of his friends wanted him not to stop writing about the markets he started this blog to share his ideas and tools.\",\"sameAs\":[\"https:\/\/market-and-us.com\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yasr_visitor_votes":{"number_of_votes":0,"sum_votes":0,"stars_attributes":{"read_only":false,"span_bottom":false}},"_links":{"self":[{"href":"https:\/\/market-and-us.com\/blog\/wp-json\/wp\/v2\/posts\/212"}],"collection":[{"href":"https:\/\/market-and-us.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/market-and-us.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/market-and-us.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/market-and-us.com\/blog\/wp-json\/wp\/v2\/comments?post=212"}],"version-history":[{"count":19,"href":"https:\/\/market-and-us.com\/blog\/wp-json\/wp\/v2\/posts\/212\/revisions"}],"predecessor-version":[{"id":737,"href":"https:\/\/market-and-us.com\/blog\/wp-json\/wp\/v2\/posts\/212\/revisions\/737"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/market-and-us.com\/blog\/wp-json\/wp\/v2\/media\/231"}],"wp:attachment":[{"href":"https:\/\/market-and-us.com\/blog\/wp-json\/wp\/v2\/media?parent=212"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/market-and-us.com\/blog\/wp-json\/wp\/v2\/categories?post=212"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/market-and-us.com\/blog\/wp-json\/wp\/v2\/tags?post=212"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}