Daily automatic update of stock quotes via REST API and Cronjob. Or is there a more sophisticated way?

I would recommend you to separate your data from wp-data. To realize your idea, setup a new data table for time series data. Write a php script to request your data from desired source and create a cronjob. If your hoster does not provide cronjob creation, use a cronjob service. Depending on the amount of data you request, you probably have to create approx. 10 cronjobs.

Then, create a new table for YTD performance values and create a new php script to calculate YTD performance. This should work very quickly, so you will probably need only one cronjob (I suppose, maximum 4 cronjobs).

Now you will have the time series data and the performance data in two separate tables. To show YTD data in your WordPress, create a shortcode in your functions.php like I did here.

Related Posts:

  1. WP REST API only returning partial list of users
  2. WordPress JSON output
  3. Sending POST Request from server
  4. get WP-API by page id
  5. utf8 encoding in json rest api
  6. Implementing the wp json-rest api
  7. Displaying Content with WP Rest API
  8. How to Increase WordPress JSON API Speed?
  9. Most performant way of fetching remote API data?
  10. How can I cache WordPress Rest API Response
  11. Why aren’t tags and categories added in post request to WP Rest API
  12. body_class REST field in WP-API
  13. Submit comment via JSON from Android device
  14. How to convert and use JSON data from a remote WordPress server?
  15. JSON API and notification about registration
  16. Jetpack JSON API configure button not showing [closed]
  17. WordPress Theme/Plugin Information API Response to Text and Button
  18. Implementing URL JSON API Data into Website
  19. Intergrate JSON into wordpress
  20. How do I filter Child Posts by Parent Post ID for Custom Post types in WordPress REST API response?
  21. Rest WP_Error always return null
  22. Why does “if statement” has to “die()”, otherwise wont work?
  23. Best way to make a JSON API from WordPress?
  24. Querying Posts Using JSON API
  25. How get JSON from external API on every page load if not existing in transient?
  26. Send PUT remote request with BuddyPress checkbox
  27. Yahoo! Finance CSV file will not return Dow Jones (^DJI)
  28. Is there a developers api for craigslist.org
  29. Access WordPress API Outside of WordPress (command-line PHP)
  30. What is the best way to get directory path for wp-config.php?
  31. Retrieving pages with multiple tags using REST API
  32. Trying to get custom post meta through Jetpack JSON API [closed]
  33. How do I use the WP REST API plugin and the OAuth Server plugin to allow for registration and login?
  34. Should I store external API data in my WP database or keep it as a transient?
  35. List Table API – Safe to use?
  36. Custom route for WP-API gives “rest_no_route” value
  37. How to get all posts (in chunks) via XML-RPC?
  38. Get more than 10 posts in a specific category with the wordpress api
  39. “rest_no_route” – Debug error
  40. How to Securely and remotely Create new user in wordpress using Rest API
  41. What is the official way to consume the WordPress API? (api.wordpress.org)
  42. How to get title tag of an external page with http api?
  43. How to Hit External REST POST API in WordPress? [closed]
  44. How do I perform a “get” call to an external API, and then display the JSON results on a page in my WordPress site?
  45. WordPress JSON API Extend to Create Users [closed]
  46. External API to WP
  47. Can’t get POST data in API endpoint callback
  48. node-wpapi: how to handle authentication?
  49. Post body not working with wp_remote_post()
  50. Possible to use wordpress as publishing platform but programmatically inject content?
  51. Adding rest api endpoints to an old theme
  52. Develop REST API using WordPress for Android app [closed]
  53. wp_remote_get adding backslashes
  54. CMB2 Repeatable Group & JSON API
  55. are there any initiatives to work wordpress as microservices?
  56. WordPress REST API not returning all posts
  57. Sanitize Disqus API results?
  58. Best Practice for re-using API Data in WordPress?
  59. For using google api is it necessary to install the google client libraries for using Oauth 2 in wordpress installation?
  60. Get non-rendered content from WP-API
  61. Cannot parse results from wp_remote_get
  62. Calling an API to do authentication / user login
  63. Add basic authentication of WordPress on any external PHP file?
  64. Enabling CORS with WordPress
  65. Authenticating a user with the WP-API V2 in Postman
  66. WP OAuth Server “The grant type was not specified in the request”
  67. How to send messages when a customer is registered
  68. Is there a way I can fetch the WordPress Developer Code References with an API?
  69. How to get the post_id after you successfully create new post using xmlrpc api wp newPost?
  70. Where to put API Code?
  71. Implement External API into WordPress [closed]
  72. hybridauth (google OAuth integration) and WP problems
  73. term_exists returns NULL
  74. Consuming an external API to publish/post to wordpress
  75. WP REST API remove the WordPress shortcodes from the JSON wp/v2/posts content->rendered
  76. WordPress API causing fatal error
  77. Composer Installed Package with WordPress Rest API Endpoint
  78. Is there a way to get Google My Business photos on WordPress with the API or other?
  79. Call external API
  80. Loop through WordPress API response errors
  81. How to save one API response to WooCommerce order meta data
  82. pulling in external JSON search results into WordPress
  83. Populating Custom Fields from live JSON
  84. Autotrader API Integration
  85. Passing data outside of WordPress possible?
  86. Periodically Query an external API on wordpress site
  87. Post to WordPress API using cURL and login cookies
  88. Extending the API I created to return category names
  89. Using the JSON API via HTTPS and HTTP
  90. add pagination to wp_remote_get
  91. Posting data from Ionic app to WordPress
  92. WordPress REST API Endpoint (Authors and Categories latest posts)
  93. Instructure Canvas API with WordPress [closed]
  94. REST API And Error Codes – No Message
  95. Developing a plugin, ran it through P3 Profiler, shows up slow, but I don’t know why
  96. Get full page HTML for a non-public WordPress page
  97. Send Order Confirmation automatically to customer’s mobile number
  98. get_body_params() is always empty in POST request
  99. XMLRPC: How to retrieve possible custom fields for a new post?
  100. Forminator + Hubspot Workflows