Fear and greed index

फ़्री
द्वारा Clark J | अपडेट किया गया 10 दिन पहले | Finance
लोकप्रियता

9.9 / 10

लेटेंसी

386ms

सेवा का स्तर

100%

Health Check

N/A

सभी चर्चाओं पर वापस जाएं

Seems to be down

Rapid account: Christophgeisel
christophgeisel
एक वर्ष पहले

Hello, I’m trying to learn how to use this api but it might be down as the example responses are all 0 and “”.

Thank you 😃

Rapid account: Dgianno
dgianno Commented 9 महीने पहले

Here is how you can pull from a Google Sheets AppScript:

Just call =FearGreed() from a cell

function FearGreed() {

var url = “https://fear-and-greed-index.p.rapidapi.com/v1/fgi”;
var headers = {
“contentType”: “application/json”,
“headers”:{“X-RapidAPI-Host”: “fear-and-greed-index.p.rapidapi.com”,
“X-RapidAPI-Key”: “XXXXXXXXXXXXXXXXXXXXXXXX”},
muteHttpExceptions: true,
request: “GET”};

var response = UrlFetchApp.fetch(url, headers);
var data = JSON.parse(response.getContentText());

Logger.log(data);

var PullDate = new Date ();
var PullTime= PullDate.toLocaleTimeString();

const object = {
Date: PullDate,
Time: PullTime,
Current_Score: data.fgi.now.value,
Rating: data.fgi.now.valueText,
One_Week_Ago: data.fgi.oneWeekAgo.value,
Week_Rating: data.fgi.oneWeekAgo.valueText,
One_Month_Ago: data.fgi.oneMonthAgo.value,
Month_Rating: data.fgi.oneMonthAgo.valueText,
One_Year_Ago: data.fgi.oneYearAgo.value,
YearRating: data.fgi.oneYearAgo.valueText
}

return Object.entries(object);
}

Rapid account: Msharingan 708
msharingan708 Commented 9 महीने पहले

Hi,

I’m working on a Google Sheets project and need help with coding. The goal is to retrieve data from an API, store it in Google Sheets, and perform analyses.

If anyone has experience with Google Sheets and programming and can assist, I would appreciate it.

Thanks in advance!

Best regards,

Rapid account: Rpi 4 Gx
rpi4gx Commented एक वर्ष पहले

Hello,

Yeah, this API has no examples. It’s a free API so just try using the API to get real values.

Regards.

चर्चा में शामिल हों - नीचे टिप्पणी जोड़ें:

नई टिप्पणियाँ पोस्ट करने के लिए लॉग इन / साइनअप करें