prediqtiv / alpha-vantage-cookbook

JavaScript examples to help you with accessing market data from https://www.alphavantage.co/
https://prediqtiv.github.io/alpha-vantage-cookbook
117 stars 29 forks source link

ForeignExchange.get_currency_exchange_weekly() is not returning all the data #4

Open furutajp opened 3 years ago

furutajp commented 3 years ago

How to reproduce:

ForeignExchange(key='').get_currency_exchange_weekly(
            from_symbol='BRL',
            to_symbol='CAD'
)

Output (There's a gap between 2017 and 2021)

{
    "2021-03-25":
    {
        "1. open": "0.4319",
        "2. high": "0.4319",
        "3. low": "0.2235",
        "4. close": "0.2237"
    },
    "2017-04-21":
    {
        "1. open": "0.4241",
        "2. high": "0.4314",
        "3. low": "0.4216",
        "4. close": "0.4285"
    },
    "2017-04-07":
    {
        "1. open": "0.4288",
        "2. high": "0.4332",
        "3. low": "0.4281",
        "4. close": "0.4281"
    },
    "2017-03-31":
    {
        "1. open": "0.4281",
        "2. high": "0.4285",
        "3. low": "0.4207",
        "4. close": "0.4207"
    },
    "2017-03-24":
    {
        "1. open": "0.4331",
        "2. high": "0.4331",
        "3. low": "0.4249",
        "4. close": "0.4290"
    },
    "2017-03-17":
    {
        "1. open": "0.4263",
        "2. high": "0.4299",
        "3. low": "0.4254",
        "4. close": "0.4299"
    },
    "2017-03-10":
    {
        "1. open": "0.4290",
        "2. high": "0.4291",
        "3. low": "0.4258",
        "4. close": "0.4264"
    },
    "2017-03-03":
    {
        "1. open": "0.4210",
        "2. high": "0.4296",
        "3. low": "0.4210",
        "4. close": "0.4271"
    },
    "2017-02-24":
    {
        "1. open": "0.4197",
        "2. high": "0.4281",
        "3. low": "0.4197",
        "4. close": "0.4204"
    },
    "2017-02-10":
    {
        "1. open": "0.4202",
        "2. high": "0.4214",
        "3. low": "0.4195",
        "4. close": "0.4200"
    },
    "2017-02-03":
    {
        "1. open": "0.4198",
        "2. high": "0.4198",
        "3. low": "0.4135",
        "4. close": "0.4169"
    },
    "2017-01-27":
    {
        "1. open": "0.4188",
        "2. high": "0.4188",
        "3. low": "0.4105",
        "4. close": "0.4152"
    },
    "2017-01-20":
    {
        "1. open": "0.4072",
        "2. high": "0.4179",
        "3. low": "0.4068",
        "4. close": "0.4179"
    },
    "2017-01-13":
    {
        "1. open": "0.4138",
        "2. high": "0.4138",
        "3. low": "0.4090",
        "4. close": "0.4090"
    },
    "2017-01-06":
    {
        "1. open": "0.3965",
        "2. high": "0.4152",
        "3. low": "0.3965",
        "4. close": "0.4108"
    },
    "2016-12-16":
    {
        "1. open": "0.3918",
        "2. high": "0.3938",
        "3. low": "0.3918",
        "4. close": "0.3935"
    },
    "2016-12-09":
    {
        "1. open": "0.3864",
        "2. high": "0.3910",
        "3. low": "0.3864",
        "4. close": "0.3910"
    },
    "2016-12-02":
    {
        "1. open": "0.3952",
        "2. high": "0.3962",
        "3. low": "0.3835",
        "4. close": "0.3842"
    },
    "2016-11-25":
    {
        "1. open": "0.3996",
        "2. high": "0.3996",
        "3. low": "0.3943",
        "4. close": "0.3943"
    },
    "2016-11-18":
    {
        "1. open": "0.4181",
        "2. high": "0.4189",
        "3. low": "0.3913",
        "4. close": "0.3983"
    },
    "2016-11-04":
    {
        "1. open": "0.4229",
        "2. high": "0.4229",
        "3. low": "0.4129",
        "4. close": "0.4135"
    },
    "2016-10-28":
    {
        "1. open": "0.4278",
        "2. high": "0.4278",
        "3. low": "0.4202",
        "4. close": "0.4202"
    },
    "2016-10-21":
    {
        "1. open": "0.4103",
        "2. high": "0.4213",
        "3. low": "0.4103",
        "4. close": "0.4213"
    },
    "2016-10-14":
    {
        "1. open": "0.4058",
        "2. high": "0.4148",
        "3. low": "0.4058",
        "4. close": "0.4114"
    },
    "2016-09-30":
    {
        "1. open": "0.4075",
        "2. high": "0.4087",
        "3. low": "0.4039",
        "4. close": "0.4039"
    },
    "2016-09-23":
    {
        "1. open": "0.4043",
        "2. high": "0.4076",
        "3. low": "0.4043",
        "4. close": "0.4076"
    },
    "2016-09-16":
    {
        "1. open": "0.3986",
        "2. high": "0.4007",
        "3. low": "0.3945",
        "4. close": "0.4007"
    },
    "2016-09-09":
    {
        "1. open": "0.4008",
        "2. high": "0.4038",
        "3. low": "0.3982",
        "4. close": "0.3982"
    },
    "2016-08-26":
    {
        "1. open": "0.4014",
        "2. high": "0.4031",
        "3. low": "0.3994",
        "4. close": "0.4031"
    },
    "2016-08-19":
    {
        "1. open": "0.4070",
        "2. high": "0.4070",
        "3. low": "0.3952",
        "4. close": "0.3992"
    },
    "2016-08-12":
    {
        "1. open": "0.4135",
        "2. high": "0.4182",
        "3. low": "0.4086",
        "4. close": "0.4086"
    },
    "2016-08-05":
    {
        "1. open": "0.4019",
        "2. high": "0.4130",
        "3. low": "0.4007",
        "4. close": "0.4130"
    },
    "2016-07-22":
    {
        "1. open": "0.3988",
        "2. high": "0.4010",
        "3. low": "0.3973",
        "4. close": "0.4006"
    },
    "2016-07-15":
    {
        "1. open": "0.3962",
        "2. high": "0.3986",
        "3. low": "0.3937",
        "4. close": "0.3960"
    },
    "2016-07-08":
    {
        "1. open": "0.3838",
        "2. high": "0.4061",
        "3. low": "0.3838",
        "4. close": "0.3976"
    },
    "2016-06-24":
    {
        "1. open": "0.3770",
        "2. high": "0.3818",
        "3. low": "0.3760",
        "4. close": "0.3818"
    },
    "2016-06-17":
    {
        "1. open": "0.3693",
        "2. high": "0.3750",
        "3. low": "0.3668",
        "4. close": "0.3750"
    },
    "2016-06-10":
    {
        "1. open": "0.3659",
        "2. high": "0.3755",
        "3. low": "0.3659",
        "4. close": "0.3712"
    },
    "2016-06-03":
    {
        "1. open": "0.3630",
        "2. high": "0.3661",
        "3. low": "0.3626",
        "4. close": "0.3661"
    },
    "2016-05-27":
    {
        "1. open": "0.3674",
        "2. high": "0.3708",
        "3. low": "0.3593",
        "4. close": "0.3593"
    },
    "2016-05-13":
    {
        "1. open": "0.3649",
        "2. high": "0.3725",
        "3. low": "0.3649",
        "4. close": "0.3684"
    },
    "2016-05-06":
    {
        "1. open": "0.3577",
        "2. high": "0.3661",
        "3. low": "0.3555",
        "4. close": "0.3661"
    },
    "2016-04-29":
    {
        "1. open": "0.3569",
        "2. high": "0.3627",
        "3. low": "0.3567",
        "4. close": "0.3627"
    },
    "2016-04-22":
    {
        "1. open": "0.3668",
        "2. high": "0.3668",
        "3. low": "0.3529",
        "4. close": "0.3529"
    },
    "2016-04-08":
    {
        "1. open": "0.3617",
        "2. high": "0.3617",
        "3. low": "0.3543",
        "4. close": "0.3576"
    },
    "2016-04-01":
    {
        "1. open": "0.3618",
        "2. high": "0.3680",
        "3. low": "0.3577",
        "4. close": "0.3680"
    },
    "2016-03-18":
    {
        "1. open": "0.3662",
        "2. high": "0.3662",
        "3. low": "0.3510",
        "4. close": "0.3595"
    },
    "2016-03-11":
    {
        "1. open": "0.3519",
        "2. high": "0.3649",
        "3. low": "0.3519",
        "4. close": "0.3649"
    },
    "2016-03-04":
    {
        "1. open": "0.3394",
        "2. high": "0.3572",
        "3. low": "0.3392",
        "4. close": "0.3572"
    },
    "2016-02-26":
    {
        "1. open": "0.3476",
        "2. high": "0.3476",
        "3. low": "0.3372",
        "4. close": "0.3372"
    },
    "2016-02-19":
    {
        "1. open": "0.3566",
        "2. high": "0.3566",
        "3. low": "0.3410",
        "4. close": "0.3410"
    },
    "2016-02-05":
    {
        "1. open": "0.3508",
        "2. high": "0.3546",
        "3. low": "0.3502",
        "4. close": "0.3546"
    },
    "2016-01-29":
    {
        "1. open": "0.3480",
        "2. high": "0.3486",
        "3. low": "0.3429",
        "4. close": "0.3486"
    },
    "2016-01-22":
    {
        "1. open": "0.3592",
        "2. high": "0.3592",
        "3. low": "0.3440",
        "4. close": "0.3440"
    },
    "2016-01-15":
    {
        "1. open": "0.3505",
        "2. high": "0.3585",
        "3. low": "0.3505",
        "4. close": "0.3585"
    },
    "2016-01-08":
    {
        "1. open": "0.3473",
        "2. high": "0.3554",
        "3. low": "0.3434",
        "4. close": "0.3492"
    },
    "2015-12-18":
    {
        "1. open": "0.3524",
        "2. high": "0.3573",
        "3. low": "0.3497",
        "4. close": "0.3524"
    },
    "2015-12-11":
    {
        "1. open": "0.3587",
        "2. high": "0.3645",
        "3. low": "0.3526",
        "4. close": "0.3526"
    },
    "2015-12-04":
    {
        "1. open": "0.3415",
        "2. high": "0.3565",
        "3. low": "0.3415",
        "4. close": "0.3565"
    },
    "2015-11-27":
    {
        "1. open": "0.3583",
        "2. high": "0.3586",
        "3. low": "0.3536",
        "4. close": "0.3536"
    },
    "2015-11-20":
    {
        "1. open": "0.3469",
        "2. high": "0.3595",
        "3. low": "0.3469",
        "4. close": "0.3595"
    },
    "2015-11-13":
    {
        "1. open": "0.3501",
        "2. high": "0.3506",
        "3. low": "0.3482",
        "4. close": "0.3482"
    },
    "2015-11-06":
    {
        "1. open": "0.3396",
        "2. high": "0.3492",
        "3. low": "0.3396",
        "4. close": "0.3492"
    },
    "2015-10-30":
    {
        "1. open": "0.3379",
        "2. high": "0.3402",
        "3. low": "0.3376",
        "4. close": "0.3399"
    },
    "2015-10-23":
    {
        "1. open": "0.3328",
        "2. high": "0.3377",
        "3. low": "0.3315",
        "4. close": "0.3377"
    },
    "2015-10-16":
    {
        "1. open": "0.3357",
        "2. high": "0.3463",
        "3. low": "0.3352",
        "4. close": "0.3352"
    },
    "2015-10-02":
    {
        "1. open": "0.3330",
        "2. high": "0.3381",
        "3. low": "0.3272",
        "4. close": "0.3322"
    },
    "2015-09-25":
    {
        "1. open": "0.3315",
        "2. high": "0.3370",
        "3. low": "0.3201",
        "4. close": "0.3370"
    },
    "2015-09-18":
    {
        "1. open": "0.3452",
        "2. high": "0.3452",
        "3. low": "0.3348",
        "4. close": "0.3348"
    },
    "2015-09-11":
    {
        "1. open": "0.3648",
        "2. high": "0.3648",
        "3. low": "0.3421",
        "4. close": "0.3421"
    },
    "2015-08-28":
    {
        "1. open": "0.3714",
        "2. high": "0.3746",
        "3. low": "0.3657",
        "4. close": "0.3688"
    },
    "2015-08-21":
    {
        "1. open": "0.3766",
        "2. high": "0.3775",
        "3. low": "0.3754",
        "4. close": "0.3758"
    },
    "2015-08-14":
    {
        "1. open": "0.3758",
        "2. high": "0.3772",
        "3. low": "0.3716",
        "4. close": "0.3772"
    },
    "2015-08-07":
    {
        "1. open": "0.3872",
        "2. high": "0.3872",
        "3. low": "0.3681",
        "4. close": "0.3716"
    },
    "2015-07-24":
    {
        "1. open": "0.4037",
        "2. high": "0.4079",
        "3. low": "0.3916",
        "4. close": "0.3916"
    },
    "2015-07-17":
    {
        "1. open": "0.4046",
        "2. high": "0.4124",
        "3. low": "0.4046",
        "4. close": "0.4067"
    },
    "2015-07-10":
    {
        "1. open": "0.4009",
        "2. high": "0.4009",
        "3. low": "0.3931",
        "4. close": "0.3990"
    },
    "2015-07-03":
    {
        "1. open": "0.3937",
        "2. high": "0.4035",
        "3. low": "0.3937",
        "4. close": "0.4006"
    },
    "2015-06-26":
    {
        "1. open": "0.3982",
        "2. high": "0.4015",
        "3. low": "0.3953",
        "4. close": "0.3953"
    },
    "2015-06-19":
    {
        "1. open": "0.3977",
        "2. high": "0.4008",
        "3. low": "0.3964",
        "4. close": "0.3971"
    },
    "2015-06-12":
    {
        "1. open": "0.3978",
        "2. high": "0.3978",
        "3. low": "0.3915",
        "4. close": "0.3962"
    },
    "2015-06-05":
    {
        "1. open": "0.3960",
        "2. high": "0.3994",
        "3. low": "0.3945",
        "4. close": "0.3945"
    },
    "2015-05-29":
    {
        "1. open": "0.3950",
        "2. high": "0.3950",
        "3. low": "0.3908",
        "4. close": "0.3908"
    },
    "2015-05-22":
    {
        "1. open": "0.3978",
        "2. high": "0.4042",
        "3. low": "0.3942",
        "4. close": "0.3995"
    },
    "2015-05-08":
    {
        "1. open": "0.3934",
        "2. high": "0.4051",
        "3. low": "0.3929",
        "4. close": "0.4051"
    },
    "2015-05-01":
    {
        "1. open": "0.4163",
        "2. high": "0.4163",
        "3. low": "0.4019",
        "4. close": "0.4040"
    },
    "2015-04-24":
    {
        "1. open": "0.4004",
        "2. high": "0.4102",
        "3. low": "0.4004",
        "4. close": "0.4102"
    },
    "2015-04-17":
    {
        "1. open": "0.4040",
        "2. high": "0.4050",
        "3. low": "0.3986",
        "4. close": "0.3986"
    },
    "2015-04-10":
    {
        "1. open": "0.3899",
        "2. high": "0.4140",
        "3. low": "0.3899",
        "4. close": "0.4086"
    },
    "2015-03-27":
    {
        "1. open": "0.3957",
        "2. high": "0.3963",
        "3. low": "0.3877",
        "4. close": "0.3877"
    },
    "2015-03-20":
    {
        "1. open": "0.3957",
        "2. high": "0.3957",
        "3. low": "0.3865",
        "4. close": "0.3906"
    },
    "2015-03-13":
    {
        "1. open": "0.4057",
        "2. high": "0.4128",
        "3. low": "0.3923",
        "4. close": "0.3923"
    },
    "2015-03-06":
    {
        "1. open": "0.4353",
        "2. high": "0.4353",
        "3. low": "0.4117",
        "4. close": "0.4117"
    },
    "2015-02-27":
    {
        "1. open": "0.4380",
        "2. high": "0.4423",
        "3. low": "0.4329",
        "4. close": "0.4366"
    },
    "2015-02-20":
    {
        "1. open": "0.4462",
        "2. high": "0.4462",
        "3. low": "0.4342",
        "4. close": "0.4342"
    },
    "2015-02-06":
    {
        "1. open": "0.4638",
        "2. high": "0.4638",
        "3. low": "0.4518",
        "4. close": "0.4518"
    },
    "2015-01-30":
    {
        "1. open": "0.4801",
        "2. high": "0.4836",
        "3. low": "0.4732",
        "4. close": "0.4732"
    },
    "2015-01-23":
    {
        "1. open": "0.4539",
        "2. high": "0.4819",
        "3. low": "0.4539",
        "4. close": "0.4801"
    },
    "2015-01-16":
    {
        "1. open": "0.4468",
        "2. high": "0.4568",
        "3. low": "0.4468",
        "4. close": "0.4566"
    },
    "2015-01-09":
    {
        "1. open": "0.4315",
        "2. high": "0.4490",
        "3. low": "0.4315",
        "4. close": "0.4490"
    },
    "2015-01-02":
    {
        "1. open": "0.4384",
        "2. high": "0.4384",
        "3. low": "0.4302",
        "4. close": "0.4344"
    },
    "2014-12-19":
    {
        "1. open": "0.4316",
        "2. high": "0.4377",
        "3. low": "0.4252",
        "4. close": "0.4377"
    },
    "2014-12-12":
    {
        "1. open": "0.4383",
        "2. high": "0.4398",
        "3. low": "0.4313",
        "4. close": "0.4313"
    },
    "2014-12-05":
    {
        "1. open": "0.4422",
        "2. high": "0.4441",
        "3. low": "0.4386",
        "4. close": "0.4386"
    },
    "2014-11-28":
    {
        "1. open": "0.4423",
        "2. high": "0.4507",
        "3. low": "0.4423",
        "4. close": "0.4438"
    },
    "2014-11-21":
    {
        "1. open": "0.4342",
        "2. high": "0.4447",
        "3. low": "0.4342",
        "4. close": "0.4447"
    },
    "2014-11-14":
    {
        "1. open": "0.4462",
        "2. high": "0.4462",
        "3. low": "0.4335",
        "4. close": "0.4335"
    }
}

If you query CAD -> BRL it works fine.