Like I said, you don't even have to code. You can easily use Google Sheets to create insert statements like that:
Then simply copy all these insert statements into a .sql file and import it into your relational database. Then you can run queries on it using SQL.
Search found 63 matches
- Thu Dec 03, 2020 3:58 am
- Forum: Technical Skills & Tools Questions
- Topic: Best way of using Google Sheets as a database?
- Replies: 7
- Views: 1038
- Thu Dec 03, 2020 3:51 am
- Forum: ERE Journals
- Topic: 3 yrs to FI: ertyu's journal
- Replies: 716
- Views: 106939
Re: 3 yrs to FI: ertyu's journal
I really like your project, must be a lot of fun to get that apartment in better shape. I think I'd spend way too much money on that so it's interesting how it works out for you.
- Tue Dec 01, 2020 3:40 am
- Forum: ERE Journals
- Topic: Working towards FI in Austria
- Replies: 11
- Views: 1236
Re: Working towards FI in Austria
First month journal update. :ugeek: Income November 2020 [/b]: 11.450 € Salaries: 11.340 € (I love the christmas bonus) Blood Plasma Donations: 110 € (I will keep on doing this once per week, some nice extra money while doing something good) Expenses November 2020 [/b]: 2.038 € Rent and utilities: 1...
- Sat Nov 28, 2020 12:19 pm
- Forum: Money and Investment Questions
- Topic: Acceleration of market trends - due to COVID or new normal?
- Replies: 45
- Views: 3763
Re: Acceleration of market trends - due to COVID or new normal?
Oh, bonds deliver nice returns when interest rates drop. As we know, 0% is not the limit. -1% is not the limit either. You don't need to buy bonds for interest payments. I still don't see the problem with passive investing, currently there are 14% (as stated by the sources I found via Google) of all...
- Fri Nov 27, 2020 2:49 pm
- Forum: Technical Skills & Tools Questions
- Topic: Best way of using Google Sheets as a database?
- Replies: 7
- Views: 1038
Re: Best way of using Google Sheets as a database?
Oh, if you know how to use sql you should be able to do it. You could directly generate insert statements as this can be expressed with a formula, copy them to a text file and import it into a relational database. Or maybe you can even directly import CSV. https://sqlitebrowser.org/ is a nice UI for...
- Fri Nov 27, 2020 2:40 pm
- Forum: Money and Investment Questions
- Topic: Acceleration of market trends - due to COVID or new normal?
- Replies: 45
- Views: 3763
Re: Acceleration of market trends - due to COVID or new normal?
Well, shouldn't there be a balance between passivly and actively funds as soon as the markets become inefficient due to the passive investing and give the active managers the opportunity to exploit these inefficiencies?
- Fri Nov 27, 2020 6:06 am
- Forum: Technical Skills & Tools Questions
- Topic: Best way of using Google Sheets as a database?
- Replies: 7
- Views: 1038
Re: Best way of using Google Sheets as a database?
I assume you know how to code, right? I personally would write a job that fetches the data from the google sheet, insert into a local relational database (sqlite should be sufficient) and then run the queries there. In theory you should be able to migrate your spreadsheet data to Google BigQuery but...
- Fri Nov 27, 2020 2:07 am
- Forum: Philosophy and Lifestyle Questions
- Topic: Food and climate change
- Replies: 317
- Views: 37073
Re: Food and climate change
Another problem with these fake meats, besides the disappointment, is the price. Not a good value. Well, I see them as an occasional treat and nothing someone should eat every day. I don't know how the other products taste but the Beyond burger patty has a strong meat like taste and texture. That m...
- Fri Nov 27, 2020 1:50 am
- Forum: Money and Investment Questions
- Topic: Acceleration of market trends - due to COVID or new normal?
- Replies: 45
- Views: 3763
Re: Acceleration of market trends - due to COVID or new normal?
We just experienced about a decade of abnormally smooth sailing followed by a rare wild ride. Now there are people betting on smooth sailing and others betting on the next wild ride. For US-stocks only. US stocks had a very strong outperformance the last decade, especially the big tech stocks. That...
- Thu Nov 26, 2020 1:37 pm
- Forum: Philosophy and Lifestyle Questions
- Topic: Food and climate change
- Replies: 317
- Views: 37073
Re: Food and climate change
Have you every tried the pea protein based alternatives like Beyond Meat? These have a very similar taste, maybe that helps.Alphaville wrote: ↑Thu Nov 26, 2020 1:34 pmNevertheless, I like to eat beef, I’m accustomed to it, I try to use it judiciously
- Thu Nov 26, 2020 1:28 pm
- Forum: Philosophy and Lifestyle Questions
- Topic: Food and climate change
- Replies: 317
- Views: 37073
Re: Food and climate change
I take the carbon footprint into account (I buy mostly regional, plant based food) but I have to admit that I mostly eat vegan/plant based because of ethical reasons, I oppose animal cruelty. But except storable foods/spices I only buy food grown in Austria or maybe somewhere else in Europe, that ma...
- Thu Nov 26, 2020 1:14 am
- Forum: Money and Investment Questions
- Topic: Acceleration of market trends - due to COVID or new normal?
- Replies: 45
- Views: 3763
Re: Acceleration of market trends - due to COVID or new normal?
Historically speaking, low interest rates have the tendency to increase speculation much more than of real economic growth. The flash crash in march was the best example. Everything (even highest quality government bonds and gold) were sold and there was a high correlation of all asset classes. Why?...
- Thu Nov 26, 2020 1:07 am
- Forum: Work & Education
- Topic: Income sources other than ‘normal jobs’
- Replies: 44
- Views: 10538
Re: Income sources other than ‘normal jobs’
Well. per definition blood plasma is the cell-free part of the blood containing mainly water, proteins, salts and minerals. I have done a little bit more research and apheresis really separates the blood into layers which can easily be separated then. There is almost no chance of cells being in the ...
- Tue Nov 24, 2020 8:37 am
- Forum: Work & Education
- Topic: Income sources other than ‘normal jobs’
- Replies: 44
- Views: 10538
Re: Income sources other than ‘normal jobs’
I'm not sure if this is right, but I'm under the impression that donating your plasma is also donating some of your stem cells. I don't know about these in all that much detail, so perhaps someone else can chime in, or you may want to research this if you aren't already familiar. I never heard abou...
- Tue Nov 24, 2020 5:14 am
- Forum: Work & Education
- Topic: Income sources other than ‘normal jobs’
- Replies: 44
- Views: 10538
Re: Income sources other than ‘normal jobs’
I started donating blood plasma again. It's 1650€/year if I donate once per week, it's a nice way to do something good (a lot of lives depend on plasma donations) and I can read books in peace while I am connected to the machine.
- Tue Nov 24, 2020 3:05 am
- Forum: ERE Journals
- Topic: Will's journal
- Replies: 90
- Views: 27257
Re: Will's journal
Oh, it's the same for Austrian citizens. It also depends on the bank/broker you use to buy your stocks. US is very easy, GB has no withholding tax at all, many Australian companies also pay dividends without withholding taxes (due to the stapled security structure). But for Australia that might depe...
- Tue Nov 24, 2020 2:20 am
- Forum: Money and Investment Questions
- Topic: Investments Trade Log
- Replies: 3093
- Views: 801613
Re: Investments Trade Log
I hold a bond ETF (Global Aggregate Bond hedged to EUR, 0,1% expense ratio) now and I don't know why I don't just hold cash. Weird times for investing in high-quality bonds. I just hope that interest rates will to continue to fall.
- Fri Nov 20, 2020 3:29 am
- Forum: ERE Journals
- Topic: Will's journal
- Replies: 90
- Views: 27257
Re: Will's journal
Nice journal, very interesting to read! Regarding the wealth tax: What do you think about high yield investments? Like REITs, BDCs, MLPs, CEFs, Canadian income trusts, Australian stapled securities? These investments seem to be wonderful if you don't have to pay taxes on dividends, although there is...
- Fri Nov 20, 2020 1:45 am
- Forum: Money and Investment Questions
- Topic: Newbie question:- Where do I put my $s?
- Replies: 13
- Views: 1797
Re: Newbie question:- Where do I put my $s?
Two good arguments for US-only investing are: 1. US-only index funds are usually the cheapest (lowest expense ratios) because the US market is the largest and most liquid 2. it simplifies and possibly reduces tax liability for US-based investors (this may not be visible to you as taxes are also han...
- Thu Nov 19, 2020 6:03 am
- Forum: Introduce Yourself
- Topic: Hello from Canada
- Replies: 6
- Views: 1463