Edit Your Comment
Newbie - struggling to export community sentiment data
Oct 24 at 09:56
Tham gia từ Dec 18, 2010
1bài viết
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.
Tham gia từ Oct 17, 2024
1bài viết
*Nghiêm cấm sử dụng cho mục đích thương mại và spam, nếu vi phạm có thể dẫn đến việc chấm dứt tài khoản.
Mẹo: Đăng ảnh/url youtube sẽ tự động được nhúng vào bài viết của bạn!
Mẹo: Dùng @ để tự động điền tên người dùng tham gia vào cuộc thảo luận này.