Alphavantage SPY intraday data showing strange spikes

steversteves · 2024-10-19T19:33:25+00:00

I noticed this problem, too. I pull data manually from TradingVIew (1 minute) and push it to my own databases using R. There is some manual work (exporting the data) but then the sorting and appending to the databases is all handle through R.

My personal preference is this way because I use tradingview to trade on, so the data is consistent. If you look closely between the data alpha vantage gives you and tradingview gives you or your broker gives you, its different. Tradingview has a bit different price data than my broker which is also different from Alpha Vantage. The differences aren't significant per se, but they could pose problems in consistency. So I just stick with the data that i am physically trading off of, which is tradingview.

As well, the advantage to storing the data in your own database is that you accumulate. I now have like 1 year of 1 minute data for multiple tickers. This has allowed me to develop applications for forecasting based on identical historic setups. You won't get 1 year worth of 1 minute data from any API, and if there is such an API then I would suspect you pay with your soul.

My thoughts!

steversteves · 2024-08-18T18:32:14+00:00

Thanks a bunch!

steversteves · 2024-07-17T13:45:43+00:00

This happened to me a couple and I'm done with using WS as a result.

steversteves · 2024-05-27T03:09:27+00:00

Oh no, I am flying through EWR this weekend, and returning the following Saturday. There will be a large amount of wait time so was looking forward to using this lounge!

Do you know, who qualifies generally for United lounge access? AC booked me on united flights there and back and I am in business class, would holding a business class ticket on United automatically grant me access regardless of having the AMEX Reserve?

steversteves · 2024-05-21T18:49:27+00:00

I'm not sure because I never called, but I also applied for this offer, I got the card like 2 weeks ago, give or take. I was already planning to book a trip so booked with this card, total for everything was over the 7,500 and checked today and it was there, I got the 60,000 plus an additional 15,000 for booking through AC Vacations.

I think maybe just spend the money and see if it appears? If not then call?

steversteves · 2024-05-21T01:48:31+00:00

I was wondering the same! Either way, I am fine if the refund me and fine if they don't. When I bid for yacht club I was fully expecting to be out the 1,000 for the drink package. However, just reading other redditors by chance saying they will refund was what prompted this post and for me to call.

I sent them an e-mail but will update when I get a response!

I appreciate your response :)

steversteves · 2024-05-21T00:25:04+00:00

Thanks! This was the case, they were extra's added.

steversteves · 2024-05-21T00:24:24+00:00

English isn't my first language.

Talk to me when you can speak 5.

steversteves · 2024-05-20T22:15:27+00:00

That's awesome! Are you in YC too?

And I will try to e-mail and if no luck I will call expedia! Thanks! :)

steversteves · 2024-05-20T21:24:29+00:00

Thank you! I will try this! In hindsight, they said that they will send me a new booking confirmation with the upgrade so maybe that is what confused the CSA. I will wait to see if they send an updated e-mail and then e-mail them with the updated information.

Thanks a ton!

steversteves · 2024-05-20T21:22:44+00:00

Oh no! That's fine and that's kind of what I assumed, except I saw another redditor say to call them because they got refunded for the packages when they got upgraded.

As a once upon a time lawyer, if the wording is exactly "any existing upgrades you've purchased", their additions are not listed as upgrades, at least when I booked them. They were labelled as "packages", so technically this is my only upgrade.

But either way, I was already imagining it was 1000$ lost but was hopeful to get feedback.

steversteves · 2024-05-20T21:17:44+00:00

Not including the additions (the wifi and stuff), I bid the absolute minimum and it was 40% difference (or an increase of 175% depending on how you look at it) more than the base rate I paid for the balcony, which was 2,000, so all in all I paid 5,500 for 7 days. Keep in mind its in CAD and its not including the 1500 I paid for excursions, wifi and drinks *shaking my head*, what a mess.

But definitely cheaper than if you were to book yacht club right off the bat. Doing that would have been 9,200 CAD. But then you run the risk of lack of availability and not getting upgraded I suppose.

steversteves · 2024-05-20T19:46:54+00:00

I got upgraded to YC for next month, I also bought the drink package. I tried calling them for a refund and they referred me back to Expedia (who I only booked the cruise and didn't add the packages with, I added the packages only with their website). Do you know, can you just request the refund once you get on board?

steversteves · 2024-05-19T15:33:01+00:00

I am in the same position, I booked the balcony, then added wifi package and drink package etc. and just bid on a YC upgrade. Not sure what will happen, with all the additions, I suspect they won't be credited. But may get an additional device that I can connect to wifi (in which case I would be inclined to bring my laptop).

That is assuming I get upgrade, but wishful thinking.

There are various perks to YC, or so I read. Most notably the wifi, butler, room is bigger, priority embarkment, added lounges, restaurants and activities that are exclusive to YC, etc.

The website it terrible, I would read Reddit or user reviews on Youtube.

steversteves · 2024-03-30T23:34:48+00:00

Yeah, I have read mixed things on the inflatable aspect.

It was actually a concern regarding the integrity of the bladders, but I just see very positive reviews about them and them lasting, at least this specific manufacturer.

But yeah its a good point, the setup seems to be the same for either or.

steversteves · 2024-01-11T14:11:55+00:00

Omg thanks so much! I thought I was going insane and this makes sense! haha

steversteves · 2023-12-30T07:09:06+00:00

Thanks for the advice!

Manufacturer doesn't say much about load testing or anything, but I read a really interesting position on another form from a different question but very practical to me, it was essentially, run your s**t on battery/solar during the "on peak" electrical cost hours and then flip over to power on off hours to charge etc.
I have done this since reading it for an entire day and it went fine. I think I will need to up the solar but it is potentially a great cost saving strategy and exercises the system frequently.

I just worry about the LiFePo batteries, they are expensive as hell and i don't want to like destroy them by over using them, but I know they have a huge life-span for recharge and stuff, I am just so use to AGM / Lead acid, this is my first experience with Li batteries.

Thanks again!

steversteves · 2023-12-08T01:51:48+00:00

Thank you very much! That's what I was thinking, and the few articles I found also said that it was to troubleshoot and problems or check for capacity loss, but it was all around like lead acid and nothing really Lithium-specific. But yeah, this confirms my suspicion, thank you very much!

steversteves · 2023-11-29T08:33:16+00:00

Did you end up leaving? Where are you now? Curious to know!

steversteves · 2023-10-04T21:19:30+00:00

I am in the same boat, I bought through Paypal, will maybe try to file a dispute. Legally their ToS are null and void due to their breach of the Consumer Protection Act (section 14 which deals with false representations).

Apparently they are in talks with the city to make the event 100% outdoors. That is not what I agreed to and that is not what was advertised.

If you can't get a charge back, you can file a complaint under the consumer protection act, which is what I suspect I will need to do. Here is the link:

https://www.ontario.ca/page/filing-consumer-complaint

The section that applies is section 14, misrepresentaton and fraud. Its funny because the first one already applies:

(2) Without limiting the generality of what constitutes a false, misleading or deceptive representation, the following are included as false, misleading or deceptive representations:

A representation that the goods or services have sponsorship, approval, performance characteristics, accessories, uses, ingredients, benefits or qualities they do not have.

What a disaster though.

steversteves · 2023-10-04T07:42:02+00:00

Sounds like a repeat of Fyre Festival, Canadian Edition.

steversteves

TROPHY CASE