https://archive.is/cQpuq

Hi all,

Apologies in advance if this is not the best community for posting questions about personal investing. If you know a better community for it, please let me know!

I have an account with ETRADE and made a small investment in AKREX some time ago. For reasons unknown to me, it is no longer possible to buy AKREX through ETRADE, and I want to continue investing in it.

I appreciate their management team and would like to stick with them. What options do you suggest I explore? Should I find another platform that offers buy/sell options for AKREX, or should I consider switching to a different mutual fund?

Thanks!

Feels like I hear so much doom and gloom but also some positives sprinkled in. Wanted to see what the community thought.

Do you think that the AI bubble will pop? Is entering the stock market dangerous right now?

Hello, investment noob here

I'm wondering, what happens to a company when it gets kicked out of the S&P 500? How big of a deal would it be?

• How hard will the stock price be affected?
• What happens to the board members and the upper management?
• What happens to the ETFs that track this index?

Looking forward to read your insights!

As someone who had to deal with income uncertainty in the past, upto and including homelessness, the peace of mind of watching month expenses slowly get enveloped is incredibly real. This is all apart of our FIRE plan to be able to leave a basic income to our family long after we pass. Yes, I'm aware straight growth investing would be higher returns but it's the price of not having as much anxiety of what ifs.

cross-posted from: https://lemmy.world/post/704147

cross-posted from: https://lemmy.world/post/704145

Yes, live.

​

I've looked for this for a while and didn't find much. Being a stubborn ass (The Boondocks voice) I kept looking until I got it down. There are trackers for the options you've sold, call and put screeners, calculators to avoid CSP risk, holdings, and a singular location for cost basis so you don't do something dumb like Idk sell SPCE CCs at $20 when your cost basis is $22 but you thought it was $18. I definitely didn't do that.

​

Google Sheet

You'll need to add a custom script:

1. Tools
2. Script Editor
3. Add file
4. Name it SAMPLE
5. Paste this into it:

The code is thanks to tanaike

Code source: https://stackoverflow.com/questions/64437503/importxml-not-producing-correct-values

function SAMPLE(url) {
  const res = UrlFetchApp.fetch(url, {muteHttpExceptions: true});
  const tables = [...res.getContentText().matchAll(/(<table[\w\s\S]+?<\/table>)/g)];
  if (tables.length < 2) return "No tables. Please confirm URL again.";
  const values = tables.reduce((ar, [,table]) => {
    if (table) {
      const root = XmlService.parse(table).getRootElement();
      const temp = root.getChild("tbody", root.getNamespace()).getChildren().map(e => e.getChildren().map(f => isNaN(f.getValue()) ? f.getValue() : Number(f.getValue())));
      ar = ar.concat(temp);
    }
    return ar;
  }, []);
  return values[0].map((_, i) => values.map(r => r[i]));
}

The result: It returns a table, so you need to use INDEX with it in order to point to a specific row/column. The method itself is SAMPLE, which takes a URL and returns a table. So you'll need to use Concatenate in order to make up the URL for a Yahoo link.

Google Sheet function:

=INDEX(SAMPLE(CONCATENATE("https://finance.yahoo.com/quote/", $A7, RIGHT(YEAR($E7), 2), TEXT(MONTH($E7), "00"), TEXT(DAY($E7),"00"), IF(B7 = "PUT", "P", "C"), SUBSTITUTE(TEXT($M7,"00000.000"), ".", ""), "?p=", $A7, RIGHT(YEAR($E7), 2), TEXT(MONTH($E7), "00"), TEXT(DAY($E7),"00"), "C", SUBSTITUTE(TEXT($M7,"00000.000"), ".", ""))), 2, 3) 

​

Known issues:

1. Loading from mobile is not reliable. You may have to erase the cell and undo, or reload, or get on a laptop/desktop.
2. Sorting recalculates the numbers and sometimes it stops working. I just don't sort anymore, but it'll eventually fix itself.
3. It doesn't calculate if you change values. Just erase the cell and undo, it'll do it correctly.
4. Not all options are available on Yahoo, especially if you're looking 30+ days.

​

Full page, two words: ~~Fuck you~~ good luck!

​

P.S. Yahoo dev: If you're seeing this, please let me be. This was already hard enough to put together. Plz.

Transcript: https://www.federalreserve.gov/mediacenter/files/FOMCpresconf20230614.pdf

Link goes to the start of Powell's statement. A few minutes later, the press Q-and-A session begins, and goes for about 50 minutes.

TL;DR: Pause on Federal Funds Rate, but Powell expects additional hikes this year.

The Federal Reserve holds the target Federal Funds Rate at 5.00% or so, the first rate-pause in nearly a year.

For those unaware, the Fed is the central bank of the USA. Their goal is to minimize inflation and maximize employment, largely through their control of the FFR.

Money market funds, such as Vanguards VMFXX or Schwab's SWVXX, closely track the FFR minus a few fractions-of-a-percent that they take for fees. So all investors have the ability to access this incredibly low-risk investment.

As this "low risk" investment makes more yield, the general theory is that everyone else in the economy takes slightly less-and-less risk. After all, if you can make money off of low-risk, why bother chasing the high-risk portions of the economy?

That leads to either riskier-portions being more expensive (ie: if a risky-company wants to borrow money, they have to borrow it at higher %). Or lose value (if a risky company wasn't planning to make a profit for another 10 years, those 10-years of no-profits just got far more costly, and therefore the company loses theoretical value).

Hello! Welcome!

This community is new. I added it because that's what I read mainly on Reddit. I figured I'd start this and hope it gets populated over time. :)