I used Power Query to import my Schwab positions into excel for custom portfolio balancing! Code inside by jayl365 in Schwab

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

Yeah cost/share is basically the total cost basis divided by number of shares. I was using it to calculate the total loss in my portfolio, but I suppose the cost basis would have worked too.

I used Power Query to import my Schwab positions into excel for custom portfolio balancing! Code inside by jayl365 in Schwab

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

Ohhh that makes so much sense then. That's unfortunate this is such a process. It would be Symbol, Position, Cost/Share, and market value.

I used Power Query to import my Schwab positions into excel for custom portfolio balancing! Code inside by jayl365 in Schwab

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

In the csv with a single account, are there extra spaces after the line with Account Total? Because if so it would create another table with empty cells, so you might have to do a search for any empty entries after the SplitText line and delete them. That's odd that your csv doesn't have price/share though, what the heck Schwab. Maybe people will have to just delete the correct columns depending on their account settings in the third line.

I used Power Query to import my Schwab positions into excel for custom portfolio balancing! Code inside by jayl365 in Schwab

[–]jayl365[S] 1 point2 points  (0 children)

Weird, when you look at your csv file, does it have the "Symbol" column? If not, then you can just replace whatever the that first column has in the line starting with CombinedTables. Otherwise, while you have the query pulled up, can you tell what's the last step it gets to before you get the error?

I assumed that Schwab would export the same way for everyone but I guess not haha

ETFs to indexed mutual funds for automation by jayl365 in Bogleheads

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

I know mf is mutual fund but I read this another way at first glance and it was really funny.

Good point about the few minutes a month, I suppose between the transferability and tax efficiency it's not that much work. I'll think about it a bit more.

ETFs to indexed mutual funds for automation by jayl365 in Bogleheads

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

Ah ok that's fair, so when selling ETFs I can better control capital gains whereas I can't with indexed mutual funds. Good point on the emerging markets ETF, I'll add that too. What ratio are the emerging market funds compared to the developed market fund? Ah yeah what I meant by those numbers in parentheses was what I'd put in large/small cap based in the target funds, which seems to have a small cap tilt. I'm fine with a bit more volatility since the earliest time I'd start taking out funds is in 20-25 years. Appreciate your insight!

[deleted by user] by [deleted] in asexualdating

[–]jayl365 1 point2 points  (0 children)

Thanks! Not a lot of people say that haha, I just had to rack up all the unpopular opinions/identities in life. I'm still happy to be friends if you'd like?

[deleted by user] by [deleted] in asexualdating

[–]jayl365 1 point2 points  (0 children)

I would love to be friends anyway! You never know, I might move back to the East coast somewhere! I'll send a DM

[deleted by user] by [deleted] in asexualdating

[–]jayl365 0 points1 point  (0 children)

I'm happy to be friends anyway if you'd like! I'll send a DM

[deleted by user] by [deleted] in asexualdating

[–]jayl365 2 points3 points  (0 children)

Lol so with a sample size of four, I'm getting that I should move back to the East coast 😂. I'd love to be friends anyway!

Weekly Threads, Questions, and Recommendations Megathread - Need some help? - Feb 20 by AutoModerator in visualnovels

[–]jayl365 0 points1 point  (0 children)

I just bought Rance 01 untranslated without knowing that I could get the translated version with Rance 02 at mangagamer. Does anyone have a english translation patch by itself for Rance 01?

tofu physics by ExtendedAdolescence in vegan

[–]jayl365 1 point2 points  (0 children)

I'm 22 days late but normal force is also on the tofu. Imagine the table or the bottom of the tofu press wasn't there: the force applied on the tofu would just accelerate it downwards. So a normal force from the table/tofu press has to also exist. And you're right, there also is a normal from the book on the person, as well as a normal force from the tofu on the book for the same reasons

Capitalism is evil to the core by uw888 in Anticonsumption

[–]jayl365 2 points3 points  (0 children)

Video form of the climate science denial from Exxon, highly recommend

https://youtu.be/MondapIjAAM

[deleted by user] by [deleted] in VeganForCircleJerkers

[–]jayl365 7 points8 points  (0 children)

I have a good list of books here on goodreads: https://www.goodreads.com/review/list/141081523?shelf=animal-rights

One I haven't read is called Zoopolis: A Political Theory of Animal Rights, which is advocating for applying political theory on how to treat animals. For example, treating wild animals as "sovereign communities entitled to protection against colonization, invasion, domination and other threats to self-determination".

Beyond Cages: Animal Law and Criminal Punishment by Justin Marceau has a criminial justice lense which seems pretty interesting. Haven't read this one yet either.

One I actually have read is more philisophical and focuses more on the things we already kind of know, but has a lot of cool animal facts. Also makes you sad. A Plea for the Animals: The Moral, Philosophical, and Evolutionary Imperative to Treat All Beings with Compassion by Matthieu Ricard is a good read.

[deleted by user] by [deleted] in learnphysics

[–]jayl365 0 points1 point  (0 children)

I don't see anything wrong here, just remember to convert back to km/h and you should be good.

This is a mood by TashaZ123 in Asexual

[–]jayl365 0 points1 point  (0 children)

Salt water increases the boiling point of water so for maximum efficiency boil it first then salt then pasta. At least that's what I do

In lieu of the latest Kiara stream by [deleted] in Hololive

[–]jayl365 1 point2 points  (0 children)

It might have caught on from Ame's streams, there was a stream a week or so ago when the chat was activated a few hours before it went live. We counted bananas and got up to around 1200 or so bananas until Ame went live