creating a list of dictionaries from API calls

[AndrewEnglsh101]

Hello,

I am having trouble formulating a list of dictionaries which incorporate information from an API call which will set the KEY:VALUE pairs.

I am trying to get this result:

Output:
MainList[
{'Asset_ID': 012334, 'AAPL': 238.75},
{'Asset_ID': 567890, 'FB': 28.50},
{'Asset_ID': 123345, 'BT': 203.55},
{'Asset_ID': 678901, 'C': 38.25}
etc.............]

and this is my current code:

import requests
import json

BASE_URL = 'https://paper-api.alpaca.markets'
HEADERS = {'APCA-API-KEY-ID': "", 'APCA-API-SECRET-KEY': ""}
ACCOUNT_URL = '{}/v2/account'.format(BASE_URL)
ASSETS_URL = '{}/v2/assets'.format(BASE_URL)
POSITIONS_URL = '{}/v2/positions'.format(BASE_URL)

#asset API provides the stock symbol(AAPL,FB etc.)& the associated asset ID's.
assets_r = requests.get(ASSETS_URL, headers=HEADERS)
get_assets = json.loads(assets_r.content)

#positions API provides the Current_value
positions_r = requests.get(POSITIONS_URL, headers=HEADERS)
get_position = json.loads(positions_r.content)

dictionary = dict

Symbol_items = dictionary(get_assets)['symbol', range(1)]

Asset_ID_items = dictionary(get_assets)['id', range(1)]

price_items = dictionary(get_position)['current_price', range(1)]

dictionary = {'Asset_ID' : Asset_ID_items, Symbol_items: price_items}

print(dictionary)

--- when it runs I get this message,

Error:
Traceback (most recent call last):
  File "C:/Users/engli/PycharmProjects/tester01/rambo/first_Test.py", line 24, in <module>
    Symbol_items = dictionary(get_assets)['symbol', range(1)]
ValueError: dictionary update sequence element #0 has length 10; 2 is required

Any help will be greatly appreciated!

Kind Regards,

Andrew

[buran]

What exactly are you trying to do with this line (and next 2):

Symbol_items = dictionary(get_assets)['symbol', range(1)]

and why you create alias for dict function before that?

[DeaD_EyE]

To get the assets_r as list:

assets_r = requests.get(ASSETS_URL, headers=HEADERS).json()

Then you have to access the symbols with POSITIONS_URL.
The URL is: https://paper-api.alpaca.markets/v2/positions/{symbol}

I guess you have to request each symbol... Very confusing.

[AndrewEnglsh101]

What exactly are you trying to do with this line (and next 2):

Symbol_items = dictionary(get_assets)['symbol', range(1)]

and why you create alias for dict function before that?

Hi Buran,

Without the 'dictionary = dict' PyCharm was asking me to declare what dictionary was.

I am trying to create a function which will place 'symbol', 'id' and 'price' without actually stating what they are manually.

The range(1) was added in an attempt to resolve the Traceback error but nothing changed. The thought process was to take the first value from the api call 'symbol' as it provides a list of stock symbols.
This is the same thought process with 'ID' and 'Price'.

I need to also loop it for every value from the API call but Ia wanted to see if this process works before I attempted to loop it.

I hope this helped.

Kind Regards,

Andrew

---

To get the assets_r as list:

assets_r = requests.get(ASSETS_URL, headers=HEADERS).json()

Then you have to access the symbols with POSITIONS_URL.
The URL is: https://paper-api.alpaca.markets/v2/positions/{symbol}

I guess you have to request each symbol... Very confusing.

Hi Deadeye,

Thank you for your advice, there are over 1000+ symbols so it would be rather impractical to request each symbol. unless it was possible to automate it with loop function?

I am basically trying to build a dictionary which inputs the 'KEY:VALUE' pairs from functions calling data from the API. i have declared the functions and place them into the dictionary itself. It may not be the most efficient way to do it but that is the direction I was heading with it?

I agree, it is confusing..

Kind Regards,

Andrew

[buran]

First of all, why would you requests the assets,
you can just request positions (there is all info you want - AssetID, symbol and price).
You can get what you want from there.

[AndrewEnglsh101]

First of all, why would you requests the assets,
you can just request positions (there is all info you want - AssetID, symbol and price).
You can get what you want from there.

Good question, I have thought about this. The 'Positions' only provide the current price of the asset you buy from Alpaca. The real-time pricing API call would be changed to 'Polygon.io' but his comes at a cost £+100 a month. - I cannot justify this at the moment. it is still early stages but once this code is resolved I will transfer the API call from Alpaca's position to Polygon.io's real-time pricing.

The Asset API call does provide all the AssetID's and Symbol's just not the Real-time pricing.

I have bought a share on this paper-trading platform so once this code is resolved it will show 1 'current_price' value for the time being but once the call is adapted to Polygon.io it will provide all real-time pricing.

I will have to match the stock symbol from Alpaca with Polygon to get the corresponding price. It has to match Alpaca since that is the trading platform.

Kind Regards,

Andrew