Edit Your Comment
Newbie - struggling to export community sentiment data
Oct 24, 2024 at 09:56
会员从Dec 18, 2010开始
2帖子
Hi all,
Please can you help me to confirm the correct API Key / token to use to pull sentiment data.
When I have the correct key, will this basic script do the job?
..................................
import requests
import csv
import datetime
import time
# Your Myfxbook API credentials
API_KEY = '?' # Replace with actual API key
def get_sentiment_data():
endpoint = "https://www.myfxbook.com/api/get-community-outlook.json"
params = {'session': API_KEY}
response = requests.get(endpoint, params=params)
if response.status_code == 200:
data = response.json()
if data['error'] == 0:
return data['outlook']
else:
print(f"Error: {data['message']}")
return None
else:
print(f"Failed to retrieve data. Status code: {response.status_code}")
return None
def save_to_csv(data):
filename = 'sentiment_data.csv'
with open(filename, mode='a', newline='') as file:
writer = csv.writer(file)
# Write the header if the file is new
if file.tell() == 0:
writer.writerow(['Date', 'Symbol', 'Short Percentage', 'Long Percentage', 'Short Volume', 'Long Volume'])
for symbol in data['symbols']:
writer.writerow([
datetime.datetime.now().strftime("%Y-%m-%d"),
symbol['name'],
symbol['shortPercentage'],
symbol['longPercentage'],
symbol['shortVolume'],
symbol['longVolume']
])
def main():
while True:
sentiment_data = get_sentiment_data()
if sentiment_data:
save_to_csv(sentiment_data)
time.sleep(86400) # Sleep for 24 hours
if __name__ == "__main__":
main()
......................
Thanks in advance
Jason
Please can you help me to confirm the correct API Key / token to use to pull sentiment data.
When I have the correct key, will this basic script do the job?
..................................
import requests
import csv
import datetime
import time
# Your Myfxbook API credentials
API_KEY = '?' # Replace with actual API key
def get_sentiment_data():
endpoint = "https://www.myfxbook.com/api/get-community-outlook.json"
params = {'session': API_KEY}
response = requests.get(endpoint, params=params)
if response.status_code == 200:
data = response.json()
if data['error'] == 0:
return data['outlook']
else:
print(f"Error: {data['message']}")
return None
else:
print(f"Failed to retrieve data. Status code: {response.status_code}")
return None
def save_to_csv(data):
filename = 'sentiment_data.csv'
with open(filename, mode='a', newline='') as file:
writer = csv.writer(file)
# Write the header if the file is new
if file.tell() == 0:
writer.writerow(['Date', 'Symbol', 'Short Percentage', 'Long Percentage', 'Short Volume', 'Long Volume'])
for symbol in data['symbols']:
writer.writerow([
datetime.datetime.now().strftime("%Y-%m-%d"),
symbol['name'],
symbol['shortPercentage'],
symbol['longPercentage'],
symbol['shortVolume'],
symbol['longVolume']
])
def main():
while True:
sentiment_data = get_sentiment_data()
if sentiment_data:
save_to_csv(sentiment_data)
time.sleep(86400) # Sleep for 24 hours
if __name__ == "__main__":
main()
......................
Thanks in advance
Jason
The trader is as big as the things that make him angry.
会员从Oct 17, 2024开始
2帖子

*商业用途和垃圾邮件将不被容忍,并可能导致账户终止。
提示:发布图片/YouTube网址会自动嵌入到您的帖子中!
提示:键入@符号,自动完成参与此讨论的用户名。