Stepone Portfolio Calculations
Posted: May 19th, 2023, 10:17 am
by Heathy128
Hi all,
When I update the prices in the stepone portfolio they all turn red and go to 100%.
Any ideas why this is happening or what to do to solve this problem?
Thanks,
Steve.
Re: Stepone Portfolio Calculations
Posted: May 19th, 2023, 10:23 am
by kiloran
Heathy128 wrote:When I update the prices in the stepone portfolio they all turn red and go to 100%.
Any ideas why this is happening or what to do to solve this problem?
Steve.
It'll be due to the recent Yahoo problems discussed here:
viewtopic.php?f=27&t=38834I'll look at updating the StepOne Portfolio in the next day or two
--kiloran
Re: Stepone Portfolio Calculations
Posted: May 20th, 2023, 5:38 am
by Heathy128
kiloran wrote:Heathy128 wrote:When I update the prices in the stepone portfolio they all turn red and go to 100%.
Any ideas why this is happening or what to do to solve this problem?
Steve.
It'll be due to the recent Yahoo problems discussed here:
viewtopic.php?f=27&t=38834I'll look at updating the StepOne Portfolio in the next day or two
--kiloran
Thank you for the keeping the ship afloat. The Stepone portfolio is a bridge too far for my Excel skills.
Re: Stepone Portfolio Calculations
Posted: May 21st, 2023, 11:45 am
by kiloran
kiloran wrote:Heathy128 wrote:When I update the prices in the stepone portfolio they all turn red and go to 100%.
Any ideas why this is happening or what to do to solve this problem?
Steve.
It'll be due to the recent Yahoo problems discussed here:
viewtopic.php?f=27&t=38834I'll look at updating the StepOne Portfolio in the next day or two
--kiloran
The StepOne Portfolio has been updated to version 3-2 at
http://lemonfoolfinancialsoftware.weebl ... folio.htmlI've added a Parameters sheet which allows selection of v6 or v7 of the Yahoo stock price API in cell B2. It now defaults to v6
--kiloran
Re: Stepone Portfolio Calculations
Posted: May 21st, 2023, 7:00 pm
by Heathy128
kiloran wrote:kiloran wrote:It'll be due to the recent Yahoo problems discussed here:
viewtopic.php?f=27&t=38834I'll look at updating the StepOne Portfolio in the next day or two
--kiloran
The StepOne Portfolio has been updated to version 3-2 at
http://lemonfoolfinancialsoftware.weebl ... folio.htmlI've added a Parameters sheet which allows selection of v6 or v7 of the Yahoo stock price API in cell B2. It now defaults to v6
--kiloran
Working great now!
Thank you.