• Recent
  • Tags
  • Unsolved
  • Solved
  • MagicMirror² Repository
  • Documentation
  • 3rd-Party-Modules
  • Donate
  • Discord
  • Register
  • Login
MagicMirror Forum
  • Recent
  • Tags
  • Unsolved
  • Solved
  • MagicMirror² Repository
  • Documentation
  • 3rd-Party-Modules
  • Donate
  • Discord
  • Register
  • Login
A New Chapter for MagicMirror: The Community Takes the Lead
Read the statement by Michael Teeuw here.

MMM-AVStock returning empty values

Scheduled Pinned Locked Moved Unsolved Troubleshooting
6 Posts 3 Posters 686 Views 3 Watching
Loading More Posts
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • R Offline
    requiemmg
    last edited by Feb 21, 2020, 1:08 PM

    Hi,

    I use MMM-AVStock to display my portfolios stock and ETF price changes. I look up the symbols on AlphaVantage and so far everything has worked fine.
    But now, some fields stay empty for days, though a direct call returns valid price information.

    Example: 6AQQ.DEX

    https://www.alphavantage.co/query?function=TIME_SERIES_INTRADAY&symbol=6aqq.dex&interval=5min&apikey=xxxx

    {
        "Meta Data": {
            "1. Information": "Intraday (5min) open, high, low, close prices and volume",
            "2. Symbol": "6aqq.dex",
            "3. Last Refreshed": "2020-02-21 07:10:00",
            "4. Interval": "5min",
            "5. Output Size": "Compact",
            "6. Time Zone": "US/Eastern"
        },
        "Time Series (5min)": {
            "2020-02-21 07:10:00": {
                "1. open": "98.2600",
                "2. high": "98.2600",
                "3. low": "98.2600",
                "4. close": "98.2600",
                "5. volume": "0"
            },
            "2020-02-21 06:55:00": {
                "1. open": "98.2200",
                "2. high": "98.2200",
                "3. low": "98.2200",
                "4. close": "98.2200",
                "5. volume": "10"
            },
            "2020-02-21 06:15:00": {
                "1. open": "98.1800",
                "2. high": "98.1800",
                "3. low": "98.1800",
                "4. close": "98.1800",
                "5. volume": "31"
            },
            "2020-02-21 06:05:00": {
                "1. open": "98.2800",
                "2. high": "98.2800",
                "3. low": "98.2800",
                "4. close": "98.2800",
                "5. volume": "200"
            },
            "2020-02-21 05:50:00": {
                "1. open": "98.2400",
                "2. high": "98.2400",
                "3. low": "98.2400",
                "4. close": "98.2400",
                "5. volume": "100"
            },
            "2020-02-21 04:30:00": {
                "1. open": "98.0200",
                "2. high": "98.0200",
                "3. low": "97.9700",
                "4. close": "97.9700",
                "5. volume": "1350"
            },
            "2020-02-21 04:15:00": {
                "1. open": "98.0400",
                "2. high": "98.0500",
                "3. low": "98.0300",
                "4. close": "98.0500",
                "5. volume": "448"
            },
            "2020-02-21 04:10:00": {
                "1. open": "98.0700",
                "2. high": "98.0700",
                "3. low": "98.0300",
                "4. close": "98.0300",
                "5. volume": "145"
            },
            "2020-02-21 03:55:00": {
                "1. open": "97.9700",
                "2. high": "97.9700",
                "3. low": "97.9700",
                "4. close": "97.9700",
                "5. volume": "58"
            },
            "2020-02-21 03:50:00": {
                "1. open": "98.0500",
                "2. high": "98.0500",
                "3. low": "98.0300",
                "4. close": "98.0300",
                "5. volume": "80"
            },
            "2020-02-21 03:35:00": {
                "1. open": "98.2200",
                "2. high": "98.2200",
                "3. low": "98.2200",
                "4. close": "98.2200",
                "5. volume": "102"
            },
            "2020-02-21 03:25:00": {
                "1. open": "97.9800",
                "2. high": "97.9800",
                "3. low": "97.9800",
                "4. close": "97.9800",
                "5. volume": "106"
            },
            "2020-02-21 03:05:00": {
                "1. open": "97.9800",
                "2. high": "97.9800",
                "3. low": "97.9800",
                "4. close": "97.9800",
                "5. volume": "28"
            },
            "2020-02-21 03:00:00": {
                "1. open": "98.0100",
                "2. high": "98.0100",
                "3. low": "98.0100",
                "4. close": "98.0100",
                "5. volume": "0"
            },
            "2020-02-20 11:25:00": {
                "1. open": "98.8900",
                "2. high": "98.8900",
                "3. low": "98.8900",
                "4. close": "98.8900",
                "5. volume": "1033"
            },
            "2020-02-20 11:15:00": {
                "1. open": "98.8700",
                "2. high": "98.8700",
                "3. low": "98.8700",
                "4. close": "98.8700",
                "5. volume": "50"
            },
            "2020-02-20 11:10:00": {
                "1. open": "99.3300",
                "2. high": "99.3300",
                "3. low": "99.2900",
                "4. close": "99.2900",
                "5. volume": "58"
            },
            "2020-02-20 11:00:00": {
                "1. open": "99.4000",
                "2. high": "99.4000",
                "3. low": "99.4000",
                "4. close": "99.4000",
                "5. volume": "45"
            },
            "2020-02-20 10:45:00": {
                "1. open": "99.6300",
                "2. high": "99.6500",
                "3. low": "99.6300",
                "4. close": "99.6500",
                "5. volume": "101"
            },
            "2020-02-20 10:25:00": {
                "1. open": "99.4100",
                "2. high": "99.4100",
                "3. low": "99.4100",
                "4. close": "99.4100",
                "5. volume": "146"
            },
            "2020-02-20 09:35:00": {
                "1. open": "99.4300",
                "2. high": "99.4300",
                "3. low": "99.3700",
                "4. close": "99.3700",
                "5. volume": "133"
            },
            "2020-02-20 09:30:00": {
                "1. open": "99.4600",
                "2. high": "99.4600",
                "3. low": "99.4600",
                "4. close": "99.4600",
                "5. volume": "140"
            },
            "2020-02-20 08:50:00": {
                "1. open": "99.5000",
                "2. high": "99.5000",
                "3. low": "99.4200",
                "4. close": "99.4300",
                "5. volume": "1286"
            },
            "2020-02-20 08:45:00": {
                "1. open": "99.5300",
                "2. high": "99.5300",
                "3. low": "99.5200",
                "4. close": "99.5200",
                "5. volume": "780"
            },
            "2020-02-20 08:25:00": {
                "1. open": "99.6900",
                "2. high": "99.6900",
                "3. low": "99.6500",
                "4. close": "99.6500",
                "5. volume": "97"
            },
            "2020-02-20 08:10:00": {
                "1. open": "99.7900",
                "2. high": "99.7900",
                "3. low": "99.7700",
                "4. close": "99.7700",
                "5. volume": "25"
            },
            "2020-02-20 07:50:00": {
                "1. open": "99.6800",
                "2. high": "99.6800",
                "3. low": "99.6800",
                "4. close": "99.6800",
                "5. volume": "105"
            },
            "2020-02-20 07:25:00": {
                "1. open": "99.6300",
                "2. high": "99.6300",
                "3. low": "99.6300",
                "4. close": "99.6300",
                "5. volume": "45"
            },
            "2020-02-20 07:20:00": {
                "1. open": "99.6600",
                "2. high": "99.6600",
                "3. low": "99.6600",
                "4. close": "99.6600",
                "5. volume": "10"
            },
            "2020-02-20 07:15:00": {
                "1. open": "99.6800",
                "2. high": "99.6800",
                "3. low": "99.6800",
                "4. close": "99.6800",
                "5. volume": "2843"
            },
            "2020-02-20 07:10:00": {
                "1. open": "99.6900",
                "2. high": "99.6900",
                "3. low": "99.6900",
                "4. close": "99.6900",
                "5. volume": "0"
            },
            "2020-02-20 05:45:00": {
                "1. open": "99.7200",
                "2. high": "99.7200",
                "3. low": "99.7200",
                "4. close": "99.7200",
                "5. volume": "488"
            },
            "2020-02-20 05:25:00": {
                "1. open": "99.7700",
                "2. high": "99.7700",
                "3. low": "99.7700",
                "4. close": "99.7700",
                "5. volume": "40"
            },
            "2020-02-20 04:40:00": {
                "1. open": "99.7100",
                "2. high": "99.7100",
                "3. low": "99.7100",
                "4. close": "99.7100",
                "5. volume": "1000"
            },
            "2020-02-20 04:20:00": {
                "1. open": "99.6400",
                "2. high": "99.6400",
                "3. low": "99.6400",
                "4. close": "99.6400",
                "5. volume": "57"
            },
            "2020-02-20 04:15:00": {
                "1. open": "99.7300",
                "2. high": "99.7300",
                "3. low": "99.7300",
                "4. close": "99.7300",
                "5. volume": "100"
            },
            "2020-02-20 03:50:00": {
                "1. open": "99.7300",
                "2. high": "99.7300",
                "3. low": "99.7300",
                "4. close": "99.7300",
                "5. volume": "543"
            },
            "2020-02-20 03:20:00": {
                "1. open": "99.7000",
                "2. high": "99.7000",
                "3. low": "99.7000",
                "4. close": "99.7000",
                "5. volume": "250"
            },
            "2020-02-20 03:05:00": {
                "1. open": "99.8700",
                "2. high": "99.8700",
                "3. low": "99.8700",
                "4. close": "99.8700",
                "5. volume": "27"
            },
            "2020-02-20 03:00:00": {
                "1. open": "99.9000",
                "2. high": "99.9000",
                "3. low": "99.9000",
                "4. close": "99.9000",
                "5. volume": "0"
            },
            "2020-02-19 11:25:00": {
                "1. open": "99.8600",
                "2. high": "99.8600",
                "3. low": "99.8600",
                "4. close": "99.8600",
                "5. volume": "400"
            },
            "2020-02-19 11:10:00": {
                "1. open": "99.9100",
                "2. high": "99.9100",
                "3. low": "99.9100",
                "4. close": "99.9100",
                "5. volume": "58"
            },
            "2020-02-19 11:05:00": {
                "1. open": "99.9300",
                "2. high": "99.9300",
                "3. low": "99.9300",
                "4. close": "99.9300",
                "5. volume": "10"
            },
            "2020-02-19 10:35:00": {
                "1. open": "99.7800",
                "2. high": "99.7800",
                "3. low": "99.7800",
                "4. close": "99.7800",
                "5. volume": "14"
            },
            "2020-02-19 10:25:00": {
                "1. open": "99.8400",
                "2. high": "99.8400",
                "3. low": "99.8400",
                "4. close": "99.8400",
                "5. volume": "485"
            },
            "2020-02-19 09:35:00": {
                "1. open": "99.5700",
                "2. high": "99.6300",
                "3. low": "99.5700",
                "4. close": "99.6100",
                "5. volume": "87"
            },
            "2020-02-19 09:30:00": {
                "1. open": "99.6000",
                "2. high": "99.6000",
                "3. low": "99.6000",
                "4. close": "99.6000",
                "5. volume": "501"
            },
            "2020-02-19 08:30:00": {
                "1. open": "99.2900",
                "2. high": "99.2900",
                "3. low": "99.2900",
                "4. close": "99.2900",
                "5. volume": "3384"
            },
            "2020-02-19 07:10:00": {
                "1. open": "99.2400",
                "2. high": "99.2400",
                "3. low": "99.2400",
                "4. close": "99.2400",
                "5. volume": "0"
            },
            "2020-02-19 06:50:00": {
                "1. open": "99.2500",
                "2. high": "99.2500",
                "3. low": "99.2500",
                "4. close": "99.2500",
                "5. volume": "20"
            },
            "2020-02-19 06:20:00": {
                "1. open": "99.2200",
                "2. high": "99.2200",
                "3. low": "99.2200",
                "4. close": "99.2200",
                "5. volume": "6"
            },
            "2020-02-19 05:45:00": {
                "1. open": "99.1600",
                "2. high": "99.1600",
                "3. low": "99.1300",
                "4. close": "99.1300",
                "5. volume": "969"
            },
            "2020-02-19 05:35:00": {
                "1. open": "99.1800",
                "2. high": "99.1800",
                "3. low": "99.1800",
                "4. close": "99.1800",
                "5. volume": "6"
            },
            "2020-02-19 05:25:00": {
                "1. open": "99.1800",
                "2. high": "99.1800",
                "3. low": "99.1800",
                "4. close": "99.1800",
                "5. volume": "40"
            },
            "2020-02-19 05:05:00": {
                "1. open": "99.1000",
                "2. high": "99.1000",
                "3. low": "99.1000",
                "4. close": "99.1000",
                "5. volume": "13"
            },
            "2020-02-19 04:40:00": {
                "1. open": "99.1300",
                "2. high": "99.1300",
                "3. low": "99.1300",
                "4. close": "99.1300",
                "5. volume": "991"
            },
            "2020-02-19 04:10:00": {
                "1. open": "99.1400",
                "2. high": "99.1400",
                "3. low": "99.0700",
                "4. close": "99.0700",
                "5. volume": "58"
            },
            "2020-02-19 04:05:00": {
                "1. open": "99.0500",
                "2. high": "99.0500",
                "3. low": "99.0500",
                "4. close": "99.0500",
                "5. volume": "313"
            },
            "2020-02-19 04:00:00": {
                "1. open": "99.0300",
                "2. high": "99.0300",
                "3. low": "99.0300",
                "4. close": "99.0300",
                "5. volume": "248"
            },
            "2020-02-19 03:55:00": {
                "1. open": "99.0300",
                "2. high": "99.0300",
                "3. low": "99.0300",
                "4. close": "99.0300",
                "5. volume": "58"
            },
            "2020-02-19 03:50:00": {
                "1. open": "98.9900",
                "2. high": "98.9900",
                "3. low": "98.9900",
                "4. close": "98.9900",
                "5. volume": "29"
            },
            "2020-02-19 03:40:00": {
                "1. open": "99.0700",
                "2. high": "99.0700",
                "3. low": "99.0700",
                "4. close": "99.0700",
                "5. volume": "29"
            },
            "2020-02-19 03:30:00": {
                "1. open": "99.0000",
                "2. high": "99.0000",
                "3. low": "99.0000",
                "4. close": "99.0000",
                "5. volume": "13"
            },
            "2020-02-19 03:20:00": {
                "1. open": "99.0100",
                "2. high": "99.0100",
                "3. low": "99.0100",
                "4. close": "99.0100",
                "5. volume": "1"
            },
            "2020-02-19 03:15:00": {
                "1. open": "99.0500",
                "2. high": "99.0500",
                "3. low": "99.0500",
                "4. close": "99.0500",
                "5. volume": "15"
            },
            "2020-02-19 03:00:00": {
                "1. open": "99.1500",
                "2. high": "99.1500",
                "3. low": "99.1500",
                "4. close": "99.1500",
                "5. volume": "56"
            },
    
    cropped...
    
    

    Any ideas on this?

    S 1 Reply Last reply Feb 21, 2020, 1:25 PM Reply Quote 0
    • S Offline
      sdetweil @requiemmg
      last edited by Feb 21, 2020, 1:25 PM

      @requiemmg said in MMM-AVStock returning empty values:

      https://www.alphavantage.co/query?function=TIME_SERIES_INTRADAY&symbol=6aqq.dex&interval=5min&apikey=xxxx

      the code uses that call, without the interval=5min value…

      Sam

      How to add modules

      learning how to use browser developers window for css changes

      1 Reply Last reply Reply Quote 0
      • R Offline
        requiemmg
        last edited by Feb 21, 2020, 11:13 PM

        …which gives me

        "Thank you for using Alpha Vantage! Our standard API call frequency is 5 calls per minute and 500 calls per day. Please visit https://www.alphavantage.co/premium/ if you would like to target a higher API call frequency."
        

        What it would also do with all other values. But these work! Only 6AQQ.FRK results in not being shown and I have no Idea why. (also all other markets for 6AQQ)

        Any ideas?

        S 1 Reply Last reply Feb 21, 2020, 11:20 PM Reply Quote 0
        • S Offline
          sdetweil @requiemmg
          last edited by Feb 21, 2020, 11:20 PM

          @requiemmg the API returns no data when u exceed the call limit. U just have to wait

          Sam

          How to add modules

          learning how to use browser developers window for css changes

          1 Reply Last reply Reply Quote 0
          • B Offline
            brindlednearly
            last edited by Oct 9, 2023, 4:52 AM

            @sdetweil I’ve been waiting for this until this moment.

            S 1 Reply Last reply Oct 9, 2023, 11:29 AM Reply Quote 0
            • S Offline
              sdetweil @brindlednearly
              last edited by sdetweil Oct 9, 2023, 7:31 PM Oct 9, 2023, 11:29 AM

              @brindlednearly I don’t understand your message

              i consider this api one of the lazy/sloppy kind

              there is a documented error code that can be used
              but they return 200 (good), but have bad data…

              Sam

              How to add modules

              learning how to use browser developers window for css changes

              1 Reply Last reply Reply Quote 0
              • 1 / 1
              • First post
                Last post
              Enjoying MagicMirror? Please consider a donation!
              MagicMirror created by Michael Teeuw.
              Forum managed by Sam, technical setup by Karsten.
              This forum is using NodeBB as its core | Contributors
              Contact | Privacy Policy