Posted by marranca on June 10, 2011 at 4:23pm
4 followers
Jump to:
| Project: | Stock API |
| Version: | 6.x-1.x-dev |
| Component: | Code |
| Category: | support request |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | closed (duplicate) |
Issue Summary
With the limited documentation available for this module, I am having difficulty tracing the source of my issues... I cannot consistently keep stock portfolios refreshed. I see no error messages, cron runs successfully, but the stock portfolio simply doesn't update.
I'm running Drupal 6.2. Can anyone advise on what I should be looking for?
Comments
#1
also have the same issue.
#2
Correction: one symbol specifically (exclusively) is not updating: ^DJI (arguably the most important). I don't know if this has anything to do with the fact that it was the first symbol I set up when I first installed and configured Stock and StockAPI. I am using the two to display a fixed portfolio to all site users, containing a basic list of the major stock indices and indicators.
In an attempt to resolve the issue, I have tried:
-- uninstalling/re-installing the modules (multiple times)
-- manually editing, and ultimately removing, the row in stockapi table associated with this symbol
-- dropping that entire table completely, and replacing with an older version from backup
All other symbols update fine.... except this one. I have observed that two additional rows appear in the stockapi table: in the symbol field, they are labelled "Missing Symbols List." and "MISSING". I can delete these rows with no apparent errors, but they always reappear. ^DJI has it's own row, but all subsequent fields are, and remain, empty.
#3
We are having this issue as well. Following the link in the module code brought me to Yahoo's website here: http://download.finance.yahoo.com/q?d=t&s=^DJI and it looks like the "Download Spreadsheet" link on this page is no longer working at all, it simply returns the "Missing Symbols List." you're seeing in your database.
It looks like Yahoo Finance is pushing a new drop in widget for websites - is it possible they're abandoning the option to download spreadsheets from download.finance.yahoo.com ?
#4
More info on this can be found in these other issues:
Dow Jones Information crashing site
Duplicate entry 'Missing Sy' for key 1 query...
I'll close this as a duplicate.