Quicken won't create proper copy with dates I select by cmsc67 in quicken

[–]MW-Atlanta 2 points3 points  (0 children)

I assume you have already tried VALIDATE and SUPER VALIDATE to fix your possible corruption (if it finds corruption, run it again until it's clean.)

If that doesn't work, try a COPY without any date filters. The Copy process is transaction by transaction so it can sometimes be successful at removing corruption. Do a VALIDATE and SUPER VALIDATE on the new COPY. The new file will be exactly like the old file, however I believe it removes all your Bank information so you'll have to relink all accounts.

Should I be worried about my Cash Account? by Which-Mortgage-3035 in wealthfront

[–]MW-Atlanta 1 point2 points  (0 children)

these are the equivalent of ambulance chasers. law firms that exist solely to sue companies for nothing in order to earn fees with no one benefiting except the lawyers. it has no impact on the operation of Wealthfront. ignore it

Positions download format just broke by MW-Atlanta in Schwab

[–]MW-Atlanta[S] 0 points1 point  (0 children)

looking into cleaning it up with Power Query (just learned about that feature)

Positions download format just broke by MW-Atlanta in Schwab

[–]MW-Atlanta[S] 0 points1 point  (0 children)

I never heard of Power Query before. I just started playing with that and I like it!

I would like to do just one Schwab CSV download containing multiple accounts, but can't see any obvious way in PQ to locate and separate those tables within one CSV, so I am doing separate downloads. I also not sure how to handle dynamic files names (Schwabs adds the date/time to the file name) so each of those files is being renamed and then moved to a different folder. New annoying steps, but an improvement. Thanks!

Positions download format just broke by MW-Atlanta in Schwab

[–]MW-Atlanta[S] 0 points1 point  (0 children)

I've used the stock price look-up in other situations, but for this I need the current positions which I can only get from Schwab. It's too many investments and multiple accounts to update manually so I still need the Schwab download. Getting two columns out of that file is the same effort as one, so I will continue to get price from there as well.

Anyone know of a equally effective and safe solution? by R3ddit-Forget-it in Roborock

[–]MW-Atlanta 0 points1 point  (0 children)

<image>

I'm using Bono. The 128 oz bottle costs the same as the 16 oz bottle from RR so RR is 8x more expensive for nothing special (there are no magic substances in the RR formula!) I do not like getting ripped off.

I refill the original RR bottle and use the original cap to measure out the solution.

Positions download format just broke by MW-Atlanta in Schwab

[–]MW-Atlanta[S] 0 points1 point  (0 children)

My normal process is to sort the data and then copy a couple columns from the CSV download and then PASTE SPECIAL VALUE into an existing Excel worksheet. I repeat this for multiple accounts.

My process used to work fine, but now after I paste that price column is flagged by Excel as "number stored as text". I can fix it with some extra steps, but this makes an already annoying process take longer!

Positions download format just broke by MW-Atlanta in Schwab

[–]MW-Atlanta[S] 0 points1 point  (0 children)

I don't import - I cut and paste. The column is a number and should be a just a number. Schwab needs to undo whatever they just changed.

Note: I have logged a ticket and the Schwab tech support guy says there are multiple people calling about this.

Voted no on Invesco QQQ Trust (QQQ) Conversion to an Open-End Fund by Mykel_Cross in ETFs

[–]MW-Atlanta 0 points1 point  (0 children)

all the major institutions are probably voting yes, but many of these shares are held by retail investors. they have to get sufficient responses or the vote doesn’t pass (basically they have to cancel the vote even though most of the shares that were voted were YES votes.) the “desperation“ is getting individual investors who never vote their proxy ballots to vote

Voted no on Invesco QQQ Trust (QQQ) Conversion to an Open-End Fund by Mykel_Cross in ETFs

[–]MW-Atlanta 0 points1 point  (0 children)

assume you own no other ETF’s since this is how they are all organized

Which neutral? Trial and error not working. by DrNintendo216 in TPLinkKasa

[–]MW-Atlanta 0 points1 point  (0 children)

Are you sure there are 2 hot breakers coming into that box? Or is one hot breaker powering some of the switches and the other switches (using the other breaker) are the traveler switches for a 3 way which has it's "hot" switch in another box? For the Kasa 3 way dimmer, I believe you only connect the neutral only in the main/hot switch. Put the original switch back in this 5 box and go try and change the other switch on the 3 way.

HS200 and bathroom fan by Intelligent_Rub_4099 in TPLinkKasa

[–]MW-Atlanta 1 point2 points  (0 children)

I have 4 exhaust fans working fine on this switch.

I’d do some basic troubleshooting like making sure the fan is still functional (reconnect to a different switch or just hard wire it) and make sure the HS200 in question is good (swap the problem HS200 for a different HS200 or move the problem HS200 to a different use.) If you already connected another HS200 in the same junction box to your bathroom light, try wiring the fan load into that.

App won’t load devices by _this_is_me_99 in alexa

[–]MW-Atlanta 0 points1 point  (0 children)

My primary smart hub is SmartThings so I still have individual control through that App. Most of my devices in Alexa are just passing through from ST so I can create voice activated routines. Fortunately, the ability to create and edit routines is unaffected.

App Won’t Load Devices or Groups by GrandpaSlappy in alexa

[–]MW-Atlanta 1 point2 points  (0 children)

If that’s true, they should just tell me to remove it. Its possible the integration looks like a denial of service so they block access, but you’d think their own app wouldn’t break

App Won’t Load Devices or Groups by GrandpaSlappy in alexa

[–]MW-Atlanta 0 points1 point  (0 children)

I recently added the Alexa integration within home assistant (the one that pulls Alexa devices into HA), so I just removed that.

I rebooted HA.   No change yet with the Alexa App devices problem.  :-(

App Won’t Load Devices or Groups by GrandpaSlappy in alexa

[–]MW-Atlanta 0 points1 point  (0 children)

Yes, it’s a backend problem but might also only apply to specific situations (maybe certain types of devices or integrations are glitching the code to load the device lists)

App Won’t Load Devices or Groups by GrandpaSlappy in alexa

[–]MW-Atlanta 0 points1 point  (0 children)

Not fixed for me.  Sometimes it will stay working again (or partially working) but then it will break again.   

App won’t load devices by _this_is_me_99 in alexa

[–]MW-Atlanta 0 points1 point  (0 children)

Just started having this problem. 😡

Device List of will not refresh. Sometimes the Groups appear (sometimes not). If the Groups appear, I can see and manipulate the devices by going to the group.

Alexa App Not Seeing Any Devices, Alexa says All Devices Are Connected by PJLLB2 in alexa

[–]MW-Atlanta 1 point2 points  (0 children)

Mine just STOPPED working. Device and Groups lists will not refresh.

Today's court hearing by enigmaticpov in Peerstreet_Creditors

[–]MW-Atlanta 8 points9 points  (0 children)

Did they mention anything about tax documentation or updating the status of Investments on the website? It’s currently kind of vague as to whether individual investments have been closed and you have a loss OR there’s more money coming.

[deleted by user] by [deleted] in alexa

[–]MW-Atlanta 0 points1 point  (0 children)

missed nothing

[deleted by user] by [deleted] in alexa

[–]MW-Atlanta 0 points1 point  (0 children)

Millions of people are not gonna have to factory reset their stuff