Related questions

quandl anonymous user limit exceeded

2018-08-15 02:02 Marcus Scipio imported from Stackoverflow

I'm getting the following error out of my php script when executed from my Digital Ocean Droplet

Error - QELx01 : You have exceeded the anonymous user limit of 50 calls per day. To make more calls today, please register for a free Quandl account and then include your API key with your requests.

However the call works fine when ran from local host.

I am using the api_key allocated by quandl

here is the my code snippet:

            // Silver 
            // Get newest date
            $api_key = "SBPYxUYb_hz32nKxtqGU"; 
            $params = new \stdClass();            
            $params->start_date = "2018-08-14";
            $params->end_date = "2018-08-14";            
            $params->access_key = $api_key;
            $json = CallAPI('GET', 'https://www.quandl.com/api/v3/datasets/LBMA/SILVER', $params , false);
            echo($json);
            $silver_data = json_decode($json, TRUE);

            // Gte Current Price                
            $params->start_date = $silver_data["dataset"]["newest_available_date"];
            $params->end_date   = $silver_data["dataset"]["newest_available_date"];            
            $params->access_key = $api_key;
            $json = CallAPI('GET', 'https://www.quandl.com/api/v3/datasets/LBMA/SILVER', $params , false);
            $silver_data = json_decode($json, TRUE);
            $silver_aud = $silver_data["dataset"]["data"][0][1] / $usdaud;

            function CallAPI($method, $url, $data = false, $key = false)
            // method: html request method
            // url: the web address
            // data: dat to append to url
            // key: the access key to the web site
            {
                $curl = curl_init();

                switch ($method)
                {
                    case 'POST':
                        curl_setopt($curl, CURLOPT_POST, 1);

                        if ($data)
                            curl_setopt($curl, CURLOPT_POSTFIELDS, $data);
                        break;

                    case 'PUT':
                        curl_setopt($curl, CURLOPT_PUT, 1);
                        break;

                    default:
                        if ($data)
                        {
                            $info = http_build_query($data);
                            $url = sprintf('%s?%s', $url, $info);
                        }
                }

                if ($key)
                {
                    $key_header = array('content-type: application/x-www-form-urlencoded', 'x-api-key: ' . $key);
                    curl_setopt($curl, CURLOPT_HTTPHEADER, $key_header);
                }

                // Optional Authentication:
                curl_setopt($curl, CURLOPT_HTTPAUTH, CURLAUTH_BASIC);
                curl_setopt($curl, CURLOPT_USERPWD, '');

                curl_setopt($curl, CURLOPT_URL, $url);
                curl_setopt($curl, CURLOPT_RETURNTRANSFER, 1);                

                $result = curl_exec($curl);

                $err = curl_error($curl);
                curl_close($curl);
                if ($err) 
                {
                    echo "curl Error :" . $err;
                }               

                return $result;
            }

See also questions close to this topic

  • remove sales offer label from a string

    I have a task to remove specific sentence from a description field. I suppose to use preg_replace, but can't find out how to do this at all.

    input: Here we have some text and then offer 25% and then some more text

    Output should be: Here we have some text and then and then some more text

    So I need to remove offer xx% and any occurences of double space.

    Anyone have a good expression for this?

    Thanks in advance!

  • ORACLE + PHP oci_execute() got freeze and not return anything

    I am trying to execute oracle SQL statement using below code.

    $ofe_id = '123';    
$stmt = oci_parse($this->db->conn_id, "DECLARE
l_retval     VARCHAR2(255);
l_message    VARCHAR2(2000);
BEGIN
l_retval := offerte.fill_temp_fields(:ofe_id,l_message);
END;") or die("Cannot parse query");

oci_bind_by_name($stmt, ':ofe_id', $ofe_id);
//        $err = oci_error($stmt); //It return 'false';
$respose = oci_execute($stmt, OCI_DEFAULT);

    I am using PHP 5.6 with Ubuntu 14.0x. When I tried to execute above statement. It freeze and return nothing.

    When I tried to debug the code I found that It executes till oci_execute() , After that it will not execute for the next code. I was waiting till 30 minutes but seems that it not returned any response.

  • Check the value of all variables inside an php file

    index.php file: 

    <?php
 include 'phpinfoip.php';
 if (in_array($_SERVER['REMOTE_ADDR'], $ip))
 if (in_array('1', $ip, true))
?>

    phpinfoip.php file:

    <?php
 $ip = array('127.0.0.1', '1');
?>

    I would like to check one value in all variables inside the file, without having to call them by name ($ip1, $ip2... etc) to apply the following logic:

    if xxx variables has the array value = 1
    Run the code

    In other words, I would like to get something like:

    <?php
 include 'phpinfoip.php';
 if (in_array($_SERVER['REMOTE_ADDR'], $ip))
 if (in_array('1', $allvariables, true))
?>

    I think this question is crazy, and maybe impossible? sorry if it's a bother. (complementary alternatives with javascript are acceptable)

  • My R plots with the first 2 rows being equal begin from different start points. How do I rectify this?

    I have pulled some normalised stock price data from Quandl into R. When I check the first row for the close price of both stocks, they are both 100. However, my plot shows me a different picture.

    My formula is:

    plot(STC[,1],STC[,2], "l", main = "Lupin & Dr.Reddy", xlab = "Time", 
ylab = "Price", col = "green" )
par(new = TRUE)
plot(STC[,1],STC[,3], "l", xaxt = "n", yaxt = "n", xlab = "", ylab = 
"", col = "blue")
legend("topleft", c("Lupin", "Dr.Reddy"),
col = c("green","blue"), lty = c(1, 1))

    The first Close price for both stocks is 100.

    And my plot looks like this: The line chart from Dr.Reddy begins around 120

  • Calculating 5 year rolling returns

    I have the below code which has returns for U.S. stocks over the period Jan 1995 to Dec 2000. I wish to calculate the return for Jan 2001 using a 60-month rolling return in Python. As there is 5 years of returns, how is this possible?

    I would like to calculate this for each stock over the time period Jan 2001 to Dec 2010. Any assistance would be awesome!

    import quandl
import pandas as pd
import numpy as np
import matplotlib.pyplot as plt

# Use Quandl to get adjusted close price
quandl.ApiConfig.api_key = 'Enter Your Key'
stocks = ['MSFT', 'AAPL', 'WMT', 'GE', 'KO', 'F', 'JNJ', 'BA', 'XOM']
stockdata = quandl.get_table('WIKI/PRICES', ticker = stocks, paginate=True,
                    qopts = { 'columns': ['date', 'ticker', 'adj_close'] },
                    date = { 'gte': '1995-1-1', 'lte': '2000-12-31' })

# Setting date as index with columns of tickers and adjusted closing 
# price
data1 = stockdata.set_index('date')
table = data1.pivot(columns='ticker')
table.head()

# Daily and annual returns of the stocks
returns_daily = table.pct_change()
returns_daily.head()
  • Access QuandL "subcode" of a datefeed

    Let's consider this datafeed: https://www.quandl.com/data/CFTC/001602_CITS_ALL. QuandL Api Code is CFTC/001602_CITS_ALL. Below there is a table with "Latest Values" for other fields. How do I find Api Codes for these fields? For example NONCOMMERCIAL POSITIONS-SHORT ALL NOCIT.