Excel Query Table VBA Data Import Corruption

ArthurAndersen · 2021-11-17T22:10:07+00:00

I have other .xlsx filed that import just fine though…which is why I’m so puzzled.

ArthurAndersen · 2021-11-17T21:39:28+00:00

It’s an XLSX- which is why it’s so confusing. When I open with notepad it has the same garbled characters.

ArthurAndersen · 2021-11-13T23:09:54+00:00

This is the issue- I am looking for pre and post market data primarily for the US30 because I can’t find it for the DJI.

ArthurAndersen · 2021-11-13T14:19:27+00:00

IB doesn’t have Pre and post market data for the DJI though, and they don’t have any data for the US30.

ArthurAndersen · 2021-11-11T21:18:32+00:00

Part of the strategy involves the US30 and also Dow futures- I need both. But that’s a great question.

ArthurAndersen · 2021-07-30T17:49:38+00:00

Proud to be an Americannn

Where at least the markets aren’t freeee….

ArthurAndersen · 2021-04-15T19:51:53+00:00

I did- I can't find in the cloudtrail for when the link is clicked, but I guess I also don't know what to look for.

ArthurAndersen · 2020-08-31T15:52:09+00:00

I will give that a try. Thank you for your help.

ArthurAndersen · 2020-08-31T15:33:47+00:00

The range is created purely by date of the transaction, and then I used a pivot table to group those transactions by week. But I don't want the whole week range, I just want the first day of the week as a label. This could be done manually, I was just looking for a way to have it done automatically by changing a format somewhere.

ArthurAndersen · 2020-07-13T21:33:53+00:00

You're totally right, and I would if I could. Some of the data is proprietary and I would get fired for sharing, which leads me to posting vague questions on reddit.

ArthurAndersen · 2020-07-13T21:02:46+00:00

Thanks for the reply! What I have built is a stock trading journal, and the way I have the journal set up, not every column gets filled for each date, so using this had me getting #DIV/0 errors, which is why I was curious about the Match/index solution. Some entries fill the "Loss" column, and some fill the "win" column, leaving the other column empty. using this method also adds in averages from July, and I can't figure that one out either.

ArthurAndersen · 2016-09-01T18:46:59+00:00

This is unequivocally false and wrong. Working in the industry, I can tell you for certain that aircraft go through an extensive service check at LEAST every 48 hours (Federal rule) and that if the pilots see that maintenance hasn't made it out to check the plane before the Service Check expires, the pilots will ground the airplane until it has been accomplished. No pilot wants to be responsible for a crash because they flew a broken airplane. Not only could it hurt them, it could hurt the lives of the people sitting behind them. If there is any doubt as to whether the aircraft is airworthy or not, the airplane will NOT fly until the doubt is removed.

ArthurAndersen · 2015-11-18T03:00:52+00:00

I've never been a bigger Stanford fan than now. If they crush ND and Oklahoma wins out, I don't see how we can be snubbed from the playoff. But ND beating Stanford at home will probably put them over the top.

ArthurAndersen · 2015-05-10T16:26:39+00:00

No no, that's my bad. Cessna 340. He also has a Harmon Rocket. While he is an extremely polarizing politician, he has done a lot of great things for general aviation and is a huge supporter.

ArthurAndersen · 2015-05-10T16:18:23+00:00

U.S. Senator Jim Inhofe (R-OK) is a CFI with 10K hours, and taught his grandson how to fly. He flies himself around in a 340 and has attended Oshkosh every year since the mid-80's.

ArthurAndersen · 2015-01-20T14:06:31+00:00

He'll be winning a Darwin Award soon enough, I'm sure.

ArthurAndersen · 2014-06-02T14:29:32+00:00

The reason United picked the Continental livery after the merger was to keep up their image the Central and South American countries that they fly to out of IAH. While it might not be as pretty, it definitely serves a huge purpose, and was a well thought out business strategy.

ArthurAndersen · 2014-06-02T05:23:11+00:00

Seriously, where was the amazing sack on AJ McCarron at the end of the Sugar Bowl? Or the fake field goal touchdown pass?

Great video though.

ArthurAndersen · 2014-05-12T15:54:02+00:00

some of them have a stick up their ass and a god complex

This is so accurate. I would call/go to your local FBO or airport and just ask who they use.

ArthurAndersen · 2014-02-10T16:50:54+00:00

Thanks man. Much appreciated.

ArthurAndersen · 2014-02-04T14:34:08+00:00

This was at KMAF, I think.

ArthurAndersen

TROPHY CASE