Stock Forum

Discuss value investing stock ideas

 You must be logged in to post
Search Forums:


 






Wildcard Usage:
*    matches any number of characters
%    matches exactly one character

Home Report Errors Doesnt retrieve data

Doesnt retrieve data
Page:   1  
No Tags
UserPost

1:22 am
October 21, 2009


Jae Jun

Admin

posts 1336
1

If you encounter an issue where you hit refresh (F9) but you get blank, NAME or VAL errors in the statement tab or any other tab, try the following.

  • Go to morningstar directly and verify whether the financial statements for the ticker is available.
  • Type the ticker in UPPER and lower case as Excel is case sensitive and reads it differently. One may work while the other may not.
  • Close and restart excel because excel also has an internal cache which needs to be cleared. If you have a spreadsheet where a certain ticker just won't grab any data, no matter how many times you hit F9, excel may just keep retrieving the blank, NAME or VAL errors from cache.
No Tags
Page:   1  


About the Stock Valuation Software forum

Most Users Ever Online: 147

Currently Online: Graeme
12 Guests

Currently Browsing this Topic:
1 Guest

Forum Stats:

Groups: 4
Forums: 40
Topics: 694
Posts: 3681

Membership:

There are 868 Members
There have been 8 Guests

There is 1 Admin
There are 3 Moderators

Top Posters:

somrh – 273
Graeme – 122
zehua – 96
valueinvestortoday – 75
nell – 67
krackerjack121 – 67

Recent New Members: kalidas, NathanB21, jademan10, romans122, vincentbston, mrpenguin

Administrators: Jae Jun (1336 Posts)

Moderators: Jae Jun (1336 Posts), VANYA (1 Post), djsun (0 Posts)