Reddit _MoveSwiftly • 1 year ago • 91%

To partner with our community and be included here, you are free to message the moderators or comment on our pinned post. - [Tech Support](/c/techsupport@lemmy.world) - [Mental Health](/c/mentalhealth@lemmy.world) - [No Stupid Questions](/c/nostupidquestions@lemmy.world) - [Now Lemmy Explain](/c/nowlemmyexplain@lemmy.world) - [Ask Lemmy](/c/asklemmy@lemmy.world)

Today I Learned _MoveSwiftly • 1 year ago • 89%

To partner with our community and be included here, you are free to message the moderators or comment on our pinned post. - [No Stupid Questions](/c/nostupidquestions@lemmy.world) - [You Should Know](/c/youshouldknow@lemmy.world) - [Mildly Infuriating](/c/mildlyinfuriating@lemmy.world) - [Lemmy Review](/c/lemmyreview@lemmy.world) - [Ask Lemmy](/c/asklemmy@lemmy.world) - [Jokes](/c/jokes@lemmy.world) - [Comedy Heaven](/c/comedyheaven@lemmy.world) - [Now Lemmy Explain](/c/nowlemmyexplain@lemmy.world) - [Mental Health](/c/mentalhealth@lemmy.world) - [Lemmy Be Wholesome](/c/lemmybewholesome@lemmy.world) - [Lemmy Shitpost](/c/lemmyshitpost@lemmy.world) - [Hoy aprendí (TIL->HA)](/c/hoyaprendi@lemmy.world)

You Should Know _MoveSwiftly • 1 year ago • 94%

To partner with our community and be included here, you are free to message the moderators or comment on our pinned post. - [Mental Health](/c/mentalhealth@lemmy.world) - [Chronic Pain](/c/chronicpain@lemmy.world) - [No Stupid Questions](/c/nostupidquestions@lemmy.world) - [Mildly Infuriating](/c/mildlyinfuriating@lemmy.world) - [Tech Support](/c/techsupport@lemmy.world) - [Now Lemmy Explain](/c/nowlemmyexplain@lemmy.world) - [Lemmy Review](/c/lemmyreview@lemmy.world) - [Lemmy Be Wholesome](/c/lemmybewholesome@lemmy.world) - [Jokes](/c/jokes@lemmy.world) - [Lemmy Shitpost](/c/lemmyshitpost@lemmy.world) - [Ask Lemmy](/c/asklemmy@lemmy.world) - [Adulting](/c/adulting@lemmy.world)

No Stupid Questions _MoveSwiftly • 1 year ago • 89%

To partner with our community and be included here, you are free to message the moderators or comment on our pinned post. - [You Should Know](/c/youshouldknow@lemmy.world) - [Mildly Infuriating](/c/mildlyinfuriating@lemmy.world) - [Lemmy Review](/c/lemmyreview@lemmy.world) - [Ask Lemmy](/c/asklemmy@lemmy.world) - [Jokes](/c/jokes@lemmy.world) - [Comedy Heaven](/c/comedyheaven@lemmy.world) - [Now Lemmy Explain](/c/nowlemmyexplain@lemmy.world) - [Mental Health](/c/mentalhealth@lemmy.world) - [Lemmy Be Wholesome](/c/lemmybewholesome@lemmy.world) - [Lemmy Shitpost](/c/lemmyshitpost@lemmy.world) - [Health](/c/health@lemmy.world)

Denver _MoveSwiftly • 1 year ago • 88%

I'm getting ready to purchase a sports car, and wanted to inquire credit unions with low interest rates for someone who has the cash, but wants a low interest rate loan because they can. Who'd you recommend?

No Stupid Questions _MoveSwiftly • 1 year ago • 87%

The roll over worry because of hybrid is not an excuse. There are electric hybrids.

No Stupid Questions _MoveSwiftly • 1 year ago • 97%

Imgur breaks when I upload, and catbox uploads the video but can't play it... I need a service that can handle large quality images or UHD videos.

Investing _MoveSwiftly • 1 year ago • 100%

cross-posted from: https://lemmy.world/post/704147 > cross-posted from: https://lemmy.world/post/704145 > > > Yes, live. > > > > &#x200B; > > > > 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. > > > > &#x200B; > > > > [Google Sheet](https://docs.google.com/spreadsheets/d/19FQZsNXHvIY-FuwNu5ZzXIW-Aevbkl1a8Eo7RXKLwdM/edit?usp=sharing) > > > > 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](https://stackoverflow.com/users/7108653/tanaike) > > > > Code source: [https://stackoverflow.com/questions/64437503/importxml-not-producing-correct-values](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) > > > > &#x200B; > > > > 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. > > > > &#x200B; > > > > Full page, two words: ~~Fuck you~~ good luck! > > > > &#x200B; > > > > P.S. Yahoo dev: If you're seeing this, please let me be. This was already hard enough to put together. Plz.

Stocks _MoveSwiftly • 1 year ago • 100%

cross-posted from: https://lemmy.world/post/704145 > Yes, live. > > &#x200B; > > 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. > > &#x200B; > > [Google Sheet](https://docs.google.com/spreadsheets/d/19FQZsNXHvIY-FuwNu5ZzXIW-Aevbkl1a8Eo7RXKLwdM/edit?usp=sharing) > > 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](https://stackoverflow.com/users/7108653/tanaike) > > Code source: [https://stackoverflow.com/questions/64437503/importxml-not-producing-correct-values](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) > > &#x200B; > > 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. > > &#x200B; > > Full page, two words: ~~Fuck you~~ good luck! > > &#x200B; > > P.S. Yahoo dev: If you're seeing this, please let me be. This was already hard enough to put together. Plz.

Options _MoveSwiftly • 1 year ago • 100%

Yes, live. &#x200B; 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. &#x200B; [Google Sheet](https://docs.google.com/spreadsheets/d/19FQZsNXHvIY-FuwNu5ZzXIW-Aevbkl1a8Eo7RXKLwdM/edit?usp=sharing) 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](https://stackoverflow.com/users/7108653/tanaike) Code source: [https://stackoverflow.com/questions/64437503/importxml-not-producing-correct-values](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) &#x200B; 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. &#x200B; Full page, two words: ~~Fuck you~~ good luck! &#x200B; P.S. Yahoo dev: If you're seeing this, please let me be. This was already hard enough to put together. Plz.

AI Art & Image Generation _MoveSwiftly • 1 year ago • 100%

cross-posted from: https://lemmy.world/post/511274 > Got Stable Diffusion running locally and had to try this out.

Denver _MoveSwiftly • 1 year ago • 96%

Got Stable Diffusion running locally and had to try this out.

Stocks _MoveSwiftly • 1 year ago • 100%

www.engadget.com

cross-posted from: https://lemmit.online/post/11065 > ##### This is an automated archive made by the [Lemmit Bot](https://lemmit.online/). > The original was posted on [/r/technology](https://old.reddit.com/r/technology/comments/14gv7cf/ford_receives_92_billion_loan_from_us_department/) by [/u/Sorin61](https://old.reddit.com/u/Sorin61) on 2023-06-23 10:41:54+00:00. >

ChatGPT _MoveSwiftly • 1 year ago • 100%

www.engadget.com

cross-posted from: https://lemmit.online/post/11514 > ##### This is an automated archive made by the [Lemmit Bot](https://lemmit.online/). > The original was posted on [/r/technology](https://old.reddit.com/r/technology/comments/14gxbrd/us_lawyers_fined_5000_after_including_fake_case/) by [/u/Sorin61](https://old.reddit.com/u/Sorin61) on 2023-06-23 12:29:36+00:00. >

Stocks _MoveSwiftly • 1 year ago • 100%

www.engadget.com

cross-posted from: https://radiation.party/post/22211 > [ [comments](https://news.ycombinator.com/item?id=36417747) | sourced from [HackerNews](https://news.ycombinator.com/) \]