LAD <-VERB("GET", url ="https://www.lostarkmarket.online/api/export-item-history/North America West/basic-oreha-fusion-material-2,crystallized-destruction-stone-0,crystallized-guardian-stone-0,great-honor-leapstone-2,honor-shard-pouch-l-3,honor-shard-pouch-m-2,honor-shard-pouch-s-1,solar-blessing-2,solar-grace-1,solar-protection-3", encode ="json")resptxt <-content(LAD, as="text")Converting <-fromJSON(resptxt)LostArkData <- Converting%>%bind_rows%>%select(id,timestamp,open,close,high,low)attach(LostArkData)#converting nonsensical time into real dates and replacing the old ones with a real date.Tconvert <- timestamp/1000Newtime <-as_date(as_datetime(Tconvert))LostArkData$timestamp <- Newtime#Removing any price=0 because the minimum price will always be 1LostArkData$open[LostArkData$open ==0] <-NALostArkData$close[LostArkData$close ==0] <-NALostArkData$high[LostArkData$high ==0] <-NALostArkData$low[LostArkData$low ==0] <-NALostArkData <- LostArkData[complete.cases(LostArkData), ]#checking new length, looks like we have removed 4 observations.#renaming first 2 columnsnames(LostArkData)[1] <-"Item"names(LostArkData)[2] <-"Date"#renaming observations to in game names.LostArkData$Item[LostArkData$Item =="basic-oreha-fusion-material-2"] <-"Basic Oreha"LostArkData$Item[LostArkData$Item =="crystallized-destruction-stone-0"] <-"Destruction Stone"LostArkData$Item[LostArkData$Item =="crystallized-guardian-stone-0"] <-"Guardian Stone"LostArkData$Item[LostArkData$Item =="great-honor-leapstone-2"] <-"Great Honor Leapstones"LostArkData$Item[LostArkData$Item =="honor-shard-pouch-l-3"] <-"Honor Shard L"LostArkData$Item[LostArkData$Item =="honor-shard-pouch-m-2"] <-"Honor Shard M"LostArkData$Item[LostArkData$Item =="honor-shard-pouch-s-1"] <-"Honor Shard S"LostArkData$Item[LostArkData$Item =="solar-blessing-2"] <-"Solar Blessing"LostArkData$Item[LostArkData$Item =="solar-grace-1"] <-"Solar Grace"LostArkData$Item[LostArkData$Item =="solar-protection-3"] <-"Solar Protection"
Cleaning and separating I have to separate each data set into its own thing for the plots to play nice with eachother.
LostArkData <- LostArkData[!(LostArkData$open ==65.00& LostArkData$high ==14899.00),]LostArkData <- LostArkData[!(LostArkData$open ==13.00& LostArkData$high ==2500.00),]LostArkData <- LostArkData[!(LostArkData$open ==187.00& LostArkData$high ==1823.00),]LostArkData <- LostArkData[!(LostArkData$open ==1823.00& LostArkData$high ==1823.00),]LostArkData <- LostArkData[!(LostArkData$open ==118.00& LostArkData$low ==11.00),]LostArkData <- LostArkData[!(LostArkData$close ==116.00& LostArkData$low ==11.00),]LostArkData <- LostArkData[!(LostArkData$open ==116.00& LostArkData$low ==11.00),]LostArkData <- LostArkData[!(LostArkData$close ==115.00& LostArkData$low ==11.00),]#look at this laterLostArkData <- LostArkData %>%filter(high <10000)#LAGHLD is a data set for Great Honor LeapstonesLAGHLD <- LostArkData %>%filter(LostArkData$Item %in%c("Great Honor Leapstones"))#LAOrehaD is a data set for Oreha material.LAOrehaD <- LostArkData %>%filter(LostArkData$Item %in%c("Basic Oreha"))#LADGD T3 Destruction and T3 GuardiansLADestructionD <- LostArkData %>%filter(LostArkData$Item %in%c("Destruction Stone"))LAGuardianD <- LostArkData %>%filter(LostArkData$Item %in%c("Guardian Stone"))#LARateupD is a data set for rate up materials LABlessingD <- LostArkData %>%filter(LostArkData$Item %in%c("Solar Blessing"))LAGraceD <- LostArkData %>%filter(LostArkData$Item %in%c("Solar Grace"))LAProtectionD <- LostArkData %>%filter(LostArkData$Item %in%c("Solar Protection"))#LAShardsD is a data set for the shard packsLALShardD <- LostArkData %>%filter(LostArkData$Item %in%c("Honor Shard L"))LAMShardD <- LostArkData %>%filter(LostArkData$Item %in%c("Honor Shard M"))LASShardD <- LostArkData %>%filter(LostArkData$Item %in%c("Honor Shard S"))#Shaded regionsShade <-data.frame(start =as.Date(c('2022-04-25','2022-05-06','2022-06-01','2022-07-12','2022-07-29','2022-09-20','2022-10-13')), end =as.Date(c('2022-04-28','2022-05-19','2022-06-30','2022-07-19','2022-08-15','2022-09-28','2022-11-16')))Shade1 <-data.frame(start =as.Date(c('2022-07-12','2022-07-29','2022-09-20')), end =as.Date(c('2022-07-19','2022-08-15','2022-09-28')))
New Data transformation This is done for having specific date data, the old data had about 12+ observations per date but the High, Low, Close data is not displayed as nice if we do not separate the dates out.
Regrouping for use in new GGPlot graphs These are for if I want to combine the data together for multiple items on a graph like the static graphs
#LADGD T3 Destruction, T3 GuardiansNDGD <- NStonesD %>%filter(NStonesD$Item %in%c("Destruction Stone","Guardian Stone"))#LARateupD is a data set for rate up materials NRateupD <- NLAD %>%filter(NLAD$Item %in%c("Solar Blessing","Solar Grace","Solar Protection"))#LAShardsD is a data set for the shard packsNShardsD <- NLAD %>%filter(NLAD$Item %in%c("Honor Shard L","Honor Shard M","Honor Shard S"))
Buttons for Shading regions in the upcoming graphs.
This graph is a “For fun” graph but can be used alongside the final graph. This candlestick graph was built from slicing data earlier to only provide the highest price, lowest price, closing price, and opening price for the day and condensing it in 1 row. I was not able to figure out how to combine this with the dates, but using the SuperLine graph and the dates pasted below, you can see the dates and hover over them with your mouse if you wished.
Candles
Plotly Line Graphs with shaded regions and Candlestick graph with dropdown option
This is the final graph.
SuperLine
A line object has been specified, but lines is not in the mode
Adding lines to the mode...
A line object has been specified, but lines is not in the mode
Adding lines to the mode...
A line object has been specified, but lines is not in the mode
Adding lines to the mode...
A line object has been specified, but lines is not in the mode
Adding lines to the mode...
A line object has been specified, but lines is not in the mode
Adding lines to the mode...
A line object has been specified, but lines is not in the mode
Adding lines to the mode...
A line object has been specified, but lines is not in the mode
Adding lines to the mode...
A line object has been specified, but lines is not in the mode
Adding lines to the mode...
Hyper express 1
4/25 express mission announced for leveling characters. https://forums.playlostark.com/t/update-to-the-express-mission-event/349957
4/28 express mission applied https://forums.playlostark.com/t/lost-ark-weekly-update-428-12-am-pt-7-am-utc-9-am-cest/351443 This was when the data began to be tracked by volunteers. This was also the same time when Amazon announced an event called “Hyper express” which made it easier to level your character.
May Update
5/6 May update announced https://www.playlostark.com/en-us/news/articles/may-2022-update-reveal
5/19 May update released https://www.playlostark.com/en-us/news/articles/may-2022-release-notes This was when they announced the first “legion raid” boss and a daily boss that doubles the Great Honor Leapstone supply for characters who can fight it.
June/July Update
6/1 June/July update announced (new character announced too) https://www.playlostark.com/en-us/news/articles/june-and-july-2022-roadmap
6/1 Anti bot measures for dungeons https://forums.playlostark.com/t/lost-ark-weekly-update-june-2nd-12-am-pt-7-am-utc-9-am-cest/396600
6/30 June update applied https://www.playlostark.com/en-us/news/articles/wrath-of-the-covetous-legion-release-notes This is when they introduced the second “legion raid” boss while also introducing anti botting measures.
6/22 June update delayed https://forums.playlostark.com/t/regarding-the-june-update/417483
6/24 A bit more anti bot measures https://forums.playlostark.com/t/an-update-to-fraud-prevention-in-lost-ark/419449 They announced the June update will be delayed, adding another week for people to hit their goals.
Hyper express 2
7/12 hyper express + new class confirmation date https://www.playlostark.com/en-gb/news/articles/arcanist-academy
7/19 Release of hyper express and arcana https://www.playlostark.com/en-us/news/articles/spells-in-spades-release-notes They announced the hyper express mission and a new character, leading you to level another character very fast and easily.
7/26 power passes disabled https://forums.playlostark.com/t/powerpasses-temporarily-disabled/439652 Due to botting, they disabled power passes to try and fix the market
August/September update
7/29 August September roadmap announced https://www.playlostark.com/en-us/news/articles/august-september-2022-roadmap They announce the August and September roadmap, unfortunately August’s update had nothing really important in the game.
8/15 August update applied, pet ranch and powerpass enabled. https://forums.playlostark.com/t/update-to-disabled-powerpasses/449952 The August update was applied, but they also re enabled the powerpasses so people can now level a character to a high level easily again.
24 hours downtime
9/7 almost 24 hours of downtime https://twitter.com/playlostark/status/1567522574292189185 The game went down for 24 hours due to some bug. Prices for Red stones became strange for about 2 days.
September/Clown Update
9/20 New class and boss confirmation date https://twitter.com/playlostark/status/1572256100841590784 They announce the new classes release date, which should also bring a new boss.
Scouter release
9/27 Scouter and clown release. https://www.playlostark.com/en-us/news/articles/rage-with-the-machinist-release-notes
November/December
update announcement 10/3 Brelshaza announced
Ark pass 2
10/13 Another event to boost the ilevel of characters.
Reaper
11/16 Reaper released with a gold sink to try and deflate the economy. Hyper express for a fast track to 1445 also released.