Donate to Remove ads

Got a credit card? use our Credit Card & Finance Calculators

Thanks to niord,gvonge,Shelford,GrahamPlatt,gpadsa, for Donating to support the site

Stepone Portfolio Calculations

Discussions regarding financial software
Heathy128
Posts: 16
Joined: May 20th, 2019, 3:05 pm
Has thanked: 31 times
Been thanked: 3 times

Stepone Portfolio Calculations

#590077

Postby Heathy128 » May 19th, 2023, 10:17 am

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.

kiloran
Lemon Quarter
Posts: 4120
Joined: November 4th, 2016, 9:24 am
Has thanked: 3272 times
Been thanked: 2859 times

Re: Stepone Portfolio Calculations

#590082

Postby kiloran » May 19th, 2023, 10:23 am

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

Heathy128
Posts: 16
Joined: May 20th, 2019, 3:05 pm
Has thanked: 31 times
Been thanked: 3 times

Re: Stepone Portfolio Calculations

#590217

Postby Heathy128 » May 20th, 2023, 5:38 am

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:

kiloran
Lemon Quarter
Posts: 4120
Joined: November 4th, 2016, 9:24 am
Has thanked: 3272 times
Been thanked: 2859 times

Re: Stepone Portfolio Calculations

#590412

Postby kiloran » May 21st, 2023, 11:45 am

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

Heathy128
Posts: 16
Joined: May 20th, 2019, 3:05 pm
Has thanked: 31 times
Been thanked: 3 times

Re: Stepone Portfolio Calculations

#590452

Postby Heathy128 » May 21st, 2023, 7:00 pm

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.


Return to “Financial Software - Discussion”

Who is online

Users browsing this forum: No registered users and 5 guests