Page 1 of 1

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=38834

I'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=38834

I'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. :roll:

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=38834

I'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.html

I'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=38834

I'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.html

I'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.