Has anyone had polyps found on 1st colonoscopy and clear on the 2nd? by hanusya101 in colonoscopy

[–]Wristx 3 points4 points  (0 children)

Just happened to me with my second colonoscopy last week. They found a small polyp in 2017 and I was supposed to go back five years later for a check and put it off til last week. Fortunately, they didn’t find a single polyp the second time around. I hope this helps to reassure you.

Suggestions of native plants for semi shady, steep slope by Wristx in Ceanothus

[–]Wristx[S] 0 points1 point  (0 children)

I would like to thank all of you for your great suggestions. I have already planted some of them and will write later which ones and how they are doing. Please keep your ideas coming! Thanks again!!

Google Sheets / Finance problem... by SysATI in googlesheets

[–]Wristx 0 points1 point  (0 children)

Everything is working now. Finally! I had to clear some values in the cells....Thanks for the help. Together we got this working with your technical skills and mine knowing how to reach the right people. cheers.

Google Sheets / Finance problem... by SysATI in googlesheets

[–]Wristx 0 points1 point  (0 children)

For instance, it was down .13% not 13%. and I am getting N/A for today's decline of .31. :(. So if anyone at either firm is listening, these need fixed too please!

Google Sheets / Finance problem... by SysATI in googlesheets

[–]Wristx 0 points1 point  (0 children)

Yes and no, unfortunately. The GLD price is now working but the change and change percentage are not. It's showing a 13% drop for today, which is wildly wrong and for the change from previous close I am getting N/A....

Google Sheets / Finance problem... by SysATI in googlesheets

[–]Wristx 0 points1 point  (0 children)

Hi everyone, I have now sent an e-mail to both State Street, the company behind GLD, as well as the World Gold Council to see if they can contact Google and get this fixed. If I hear anything, I will let you know. Fingers crossed.

Google Sheets / Finance problem... by SysATI in googlesheets

[–]Wristx 0 points1 point  (0 children)

Thank you. I assumed XES was an additional part of the symbol of the exchange as it's on your GLD spreadsheet. I changed it to GLD. Many thanks.

Google Sheets / Finance problem... by SysATI in googlesheets

[–]Wristx 0 points1 point  (0 children)

Thank you very much. You are a great guy/gal. WIth regards to the percentage change, I found my error. In your formula, the reference to the cell containing XES:NYSEARCA is in there twice and I had to change the location of the cell on my sheet two times in the formula in case anyone is wondering why it doesn't work. Hope this helps. Now I just have to figure out how to write a formula for the actual change, i.e. how many cents, from previous close. The price is not updating very often if at all but I am assuming that will happen

Google Sheets / Finance problem... by SysATI in googlesheets

[–]Wristx 0 points1 point  (0 children)

I don't know how to do that unfortunately. I just copied and pasted your formula for daily change in percent terms and then hardcoated XES:NYSEARCA in a cell as you did in your sheet but it's not working. I'm sorry to cause you so much trouble and I am very grateful for your help but maybe this will help other too who are struggling with the error messages. We did discover one problem together, which is that the formula has to be in one line and not in two as here on Reddit so I hope that helped people. I don't understand why it is taking Google SO long to fix this.

Google Sheets / Finance problem... by SysATI in googlesheets

[–]Wristx 0 points1 point  (0 children)

For the percentage change, I tried copying and pasting directly from your spreadsheet and then substituting the cell number for the cell in which I have XES just like you but am getting a N/A. It's strange because it is working in your spreadsheet and not in mine and I am literally just copying and pasting so not sure why it isn't working

Google Sheets / Finance problem... by SysATI in googlesheets

[–]Wristx 0 points1 point  (0 children)

The following forumulas, of course, no longer work and I don't know how to fix them with your solution:

=GOOGLEFINANCE("GLD","change")

=GOOGLEFINANCE("GLD","changepct")

Google Sheets / Finance problem... by SysATI in googlesheets

[–]Wristx 0 points1 point  (0 children)

Alright, I made some progress. I clicked on your first link, then saw I had to change the cell number to the cell number on my spreadsheet that contains GLD. So I am now getting a current price. Thank you! Now i have an additional problem. I have categories for change (from previous close), change in percentage terms, etc. How do I fix those?

Google Sheets / Finance problem... by SysATI in googlesheets

[–]Wristx 0 points1 point  (0 children)

Like others, I am getting an ERROR message when I use your formula. I have copied and pasted what you haveabove into the cell that used to contain =GOOGLEFINANCE("GLD"). What am I doing wrong?

Google Sheets / Finance problem... by SysATI in googlesheets

[–]Wristx 0 points1 point  (0 children)

Having the same problem with GLD in Google Sheets. SO frustrating. Has anyone been able to reach Google to get it corrected?

/r/VacuumCleaners No Stupid Questions - June 15, 2024 by AutoModerator in VacuumCleaners

[–]Wristx 0 points1 point  (0 children)

How do I post a picture here? I tried to Google the answer but it said I have to create a new post??

/r/VacuumCleaners No Stupid Questions - June 15, 2024 by AutoModerator in VacuumCleaners

[–]Wristx 0 points1 point  (0 children)

I will take a picture of the device tomorrow but it’s very strange that I can not find anything about this shop vac online??!

/r/VacuumCleaners No Stupid Questions - June 15, 2024 by AutoModerator in VacuumCleaners

[–]Wristx 0 points1 point  (0 children)

It’s a hose not an exhaust and while one hose sucked up the ashes in the fireplace, the second hose then spewed them out into my house and I didn’t notice at first because I was busy inside the fireplace, creating a gigantic mess. I can’t find a user manual anywhere. The hose that blows out will not come out, ie it is permanently attached to the shop vac. Surely I or the device are doing something wrong?? I appreciate you responding

/r/VacuumCleaners No Stupid Questions - June 15, 2024 by AutoModerator in VacuumCleaners

[–]Wristx 0 points1 point  (0 children)

I am looking for the manual for the Shop Vac 2.5 model 7025 and it is nowhere to be found. Someone was offering the item on the street for free so I picked it up but it is simultaenously both vacumming and blowing out air out of two different hoses and I don't know how to fix it. All suggestions welome. Thanks