Hi All,
Since the issues early last week with getting prices from Yahoo using the TLF addin (written by eventide I think) I have been having strange problems with one of my portfolio spreadsheets. (I don't know if the timing is a coincidence)
Before last week, whenever I opened my spreadsheet, the prices would be populated. Right-clicking and selecting 'TLF Update' and would update the prices. This was the same on 2 spreadsheets I run for 2 portfolios (call them A and B).
Since last week's issues, though, when I open spreadsheet A, all the prices say ':queued:', and running 'TLF update' has no effect. I have discovered a workaround is that I can go into each of the cells, press F2 and Enter (so effectively editing the cell although making no changes), and then refresh and the prices will update. If I press 'F2' on some of the cells, but not others, then the prices will only update in the cells which have been edited - the rest remain saying :queued:.
Spreadsheet B, for a different portfolio, still works the original way - prices update first time with no need to edit the cells. I have compared the code in each spreadsheet and they are visually identical.
After last weeks issues, I did update a line of code in both spreadsheets, per eventide's instructions. It was to change an error check from checking .StatusText, to using .Status. I made the same change in both my spreadsheets.
I tried creating a new spreadsheet, copying my data into it, and importing the code from spreadsheet A, and it suffers exactly the same issue. So I create a second new spreadsheet, and this time copied the code in from spreadsheet B, and it still has the same issue. It seems that even starting afresh with a new spreadsheet is not working.
I'm curious whether anyone else uses the TLF add-in and 'getdata' function, and if they have the same problem - it would be good to know what shows in the spreadsheet cells when they first open the spreadsheet - the last value, or 'queued'. And does anyone have any suggestions on how to resolve this?
Thanks
StepOne
Ad blocker detected: Our website is made possible by displaying online advertisements to our visitors. Please consider supporting us by disabling your ad blocker on our website.
Issue with lastprice
Discussions regarding financial software
Return to “Financial Software - Discussion”
Jump to
- About the Site
- ↳ Welcome to the Lemon Fool (TLF)
- ↳ Announcements
- ↳ Suggestions to Improve the Site
- ↳ Welcome to US Fools
- Investors' Roundtable
- ↳ How Do I Invest
- ↳ The Economy
- ↳ Investment Strategies
- ↳ Green Investing
- ↳ Company Analysis
- ↳ Retirement Investing (inc FIRE)
- ↳ Property Investment Discussions
- ↳ Portfolio Management & Review
- ↳ High Yield Shares & Strategies - General
- ↳ HYP Practical (See Group Guidelines)
- ↳ Growth Strategies
- ↳ Trading my way to a million
- ↳ Technical Analysis
- ↳ Passive Investing
- ↳ Macro and Global Topics
- ↳ International & Expat Investors
- ↳ Other Investing
- ↳ Brokers and Share Dealing
- ↳ Crypto and NFTs
- Sectors & General Share Dealing
- ↳ Company Share news (LSE Main Market)
- ↳ Stocks and Share Dealing Discussions
- ↳ Investment Trusts and Unit Trusts
- ↳ Gilts and Bonds
- ↳ Mining & Metals
- ↳ Oil & Gas & Energy (Sector & Companies)
- ↳ REITs & Property Companies
- ↳ Banking Sector
- ↳ Venture Capital Trusts (VCT's)
- ↳ Pharmaceuticals & Bio-Pharma
- Managing Your Finances
- ↳ Dealing with Debt
- ↳ Bank Accounts Savings & ISAs
- ↳ Financial Software - Discussion
- ↳ Living Below Your Means
- ↳ Student Finance
- ↳ Pensions - Practical Problems
- ↳ Mortgages
- ↳ Credit Cards and Loans
- ↳ Taxes (Practical)
- ↳ Your Tomorrow Starts Today
- ↳ Personal Finance Calculators
- Lemon-Aid
- ↳ Does anyone know?
- ↳ Legal Issues (Practical)
- ↳ Technology - Computers, TV, Phones etc.
- ↳ Building and DIY
- ↳ Comfort Cafe
- ↳ Running a Business
- ↳ Charitable Giving
- ↳ Family Matters
- Lemon Lounge
- ↳ Room 101 - Escalation to Admin
- ↳ Room 102 - Site Issues, Complaints & General Chat
- ↳ Beerpig's Snug
- ↳ Lemon Socials
- ↳ Laughing Lemons
- ↳ Coronavirus Discussions
- Travel Lounge
- ↳ Cars, Driving, Motorbikes or any Transport
- ↳ London lovers
- ↳ Around the UK
- ↳ Airport Lounge
- ↳ Cycling
- Interests - Culture, Leisure , Food and Nature
- ↳ Sports Bar (all sports)
- ↳ Music, Theatre, TV and Film
- ↳ Food
- ↳ Drink
- ↳ The Natural World
- ↳ Books and Reading
- ↳ Photography
- ↳ Science
- ↳ History
- ↳ Health & Wellbeing
- Polite Debate & Discussion
- ↳ Current Affairs & News
- ↳ The Meaning of Life
- Any Other Business
- ↳ Land of Off Topic Posts
- ↳ Pedants' Place
- ↳ Bitter Lemons
- ↳ Curiosity Corner
- ↳ Games, Puzzles and Riddles
- ↳ Catastrophe Corner
- ↳ Testing 123...