how to get currency crosses in investiny

[andresrogers]

Hello, anyone knows how to use this tool to get currency exchange pairs, I'm interested in getting USD to CLP

[alvarobartt]

Hi, @andresrogers thanks for opening this discussion, here's the code you're looking for:

from investiny import historical_data, search_assets

search_results = search_assets(query="USD/CLP", limit=1, type="FX")
investing_id = int(search_results[0]["ticker"])

data = historical_data(investing_id=investing_id)
print(data)

[seongyeop-jeong-poey]

This code isn't blocked? I got 403 error.

[alvarobartt]

Hi @seongyeop-jeong-poey, soooo I've just tested it and it seems to be working on my side... Can you please check again? Thanks

[alvarobartt]

See the output below, tested it right now:

(investiny-py3.9) alvarobartt@Alvaros-MacBook-Air investiny % poetry run python
Python 3.9.6 (default, Aug  5 2022, 15:21:02) 
[Clang 14.0.0 (clang-1400.0.29.102)] on darwin
Type "help", "copyright", "credits" or "license" for more information.
>>> from investiny import historical_data, search_assets
>>> search_results = search_assets(query="USD/CLP", limit=1, type="FX")
>>> investing_id = int(search_results[0]["ticker"])
>>> data = historical_data(investing_id=investing_id)
>>> print(data)
{'date': ['09/26/2022', '09/27/2022', '09/28/2022', '09/29/2022', '09/30/2022', '10/03/2022', '10/04/2022', '10/05/2022', '10/06/2022', '10/07/2022', '10/10/2022', '10/11/2022', '10/12/2022', '10/13/2022', '10/14/2022', '10/17/2022', '10/18/2022', '10/19/2022', '10/20/2022', '10/21/2022'], 'open': [0.00103100005072, 0.00100599997677, 0.0010150000453, 0.00104550004471, 0.00103749998379, 0.00103349995334, 0.00106349994894, 0.00107350002509, 0.00106349994894, 0.0010595000349, 0.00106549996417, 0.00106549996417, 0.00107849994674, 0.00105850002728, 0.00106649997178, 0.00103949999902, 0.00102850003168, 0.00102750002407, 0.00102650001645, 0.00102199998219], 'high': [0.00103150005452, 0.00102550000884, 0.00105199997779, 0.00104799994733, 0.00105449999683, 0.00106649997178, 0.00108199997339, 0.00107400002889, 0.0010674999794, 0.00106899999082, 0.00106649997178, 0.00108399998862, 0.00108600000385, 0.00107100000605, 0.00106699997559, 0.00104600004852, 0.00103949999902, 0.00102900003549, 0.00103899999522, 0.00103449996095], 'low': [0.00100249995012, 0.00100599997677, 0.00100749998819, 0.00102199998219, 0.00102750002407, 0.00102700002026, 0.00106299994513, 0.00105500000063, 0.00105099997018, 0.00104350002948, 0.00106499996036, 0.00105900003109, 0.00105700001586, 0.00104300002567, 0.00103299994953, 0.00102399999741, 0.00101999996696, 0.0010150000453, 0.00101849995553, 0.00100699998438], 'close': [0.00100499996915, 0.00101400003769, 0.00104400003329, 0.00103599997237, 0.00103199994192, 0.00106200005393, 0.00107300002128, 0.00106299994513, 0.00105800002348, 0.00106399995275, 0.00106399995275, 0.00107700005174, 0.00105700001586, 0.00106599996798, 0.0010379999876, 0.00102800002787, 0.00102700002026, 0.00102600001264, 0.00102199998219, 0.00102800002787]}

[seongyeop-jeong-poey]

from investiny import historical_data, search_assets
search_results = search_assets(query="USD/CLP", limit=1, type="FX")
investing_id = int(search_results[0]["ticker"])
data = historical_data(investing_id=investing_id)
print(data)

---

ConnectionError Traceback (most recent call last)
C:\Users\ADMINI~1\AppData\Local\Temp/ipykernel_29356/258927356.py in
1 from investiny import historical_data, search_assets
----> 2 search_results = search_assets(query="USD/CLP", limit=1, type="FX")
3 investing_id = int(search_results[0]["ticker"])
4 data = historical_data(investing_id=investing_id)
5 print(data)

C:\ProgramData\Anaconda3\lib\site-packages\investiny\search.py in search_assets(query, limit, type, exchange)
40 "exchange": exchange if exchange else "",
41 }
---> 42 return request_to_investing(endpoint="search", params=params) # type: ignore

C:\ProgramData\Anaconda3\lib\site-packages\investiny\utils.py in request_to_investing(endpoint, params)
34 r = httpx.get(url, params=params, headers=headers)
35 if r.status_code != 200:
---> 36 raise ConnectionError(
37 f"Request to Investing.com API failed with error code: {r.status_code}."
38 )

ConnectionError: Request to Investing.com API failed with error code: 403.

Unfortunately, It seems doesn't work on my side. what's the problem?