Historical data data usage on Android Pie

I’m trying to check my historical data usage on my OnePlus 6 (OxygenOS 9.0.6).

I used to be able to go to the Data Usage settings and use a drop-down list at the top to select different time periods, but trying this just now it only shows me the usage since the start of my current billing cycle, with no option to show any other period.

This is not the behaviour I was expecting, so I wonder if this specific to Android Pie on my OnePlus 7, or has Android Pie (or earlier) removed the ability to display data usage history.

Noticing that my billing cycle start date was wrong, I corrected it and found that the usage data shown now goes back to the start of the new billing cycle start date, so obviously it stores more data than is displays.

If more history is still recorded somewhere, how can I get access to it, and how far back would the history go?

My device is not rooted, nor can it be, but I’m comfortable with using ADB if necessary.

Currency Conversion Function (Historical Date) [on hold]

I am using this sub which works fine but outputs a table with rates

Option Explicit Public Sub GetTable()     Dim sResponse As String, html As HTMLDocument, ws As Worksheet, clipboard As Object      Set ws = ThisWorkbook.Worksheets("Sheet1")      With CreateObject("MSXML2.XMLHTTP")         .Open "GET", "https://www.x-rates.com/historical/?from=CAD&amount=1&date=" & Format$  (Date - 1, "yyyy-mm-dd"), False         .setRequestHeader "If-Modified-Since", "Sat, 1 Jan 2000 00:00:00 GMT"         .send         sResponse = StrConv(.responseBody, vbUnicode)     End With      Set clipboard = GetObject("New:{1C3B4210-F441-11CE-B9EA-00AA006B1A69}")     Set html = New HTMLDocument      With html         .body.innerHTML = sResponse         clipboard.SetText .querySelectorAll(".ratesTable").item(1).outerHTML         clipboard.PutInClipboard     End With          ws.Cells(1, 1).PasteSpecial  End Sub 

Instead it would be more useful to replace this with a function with 3 arguments.

Currency From, Currency To, Historical Date

function_convert(USD,GBP,30/12/2015) 

I have searched around the internet but couldn’t find a working solution. Any help would be much appreciated.

Currency Conversion Function (Historical Date) [on hold]

I am using this sub which works fine but outputs a table with rates

Option Explicit Public Sub GetTable()     Dim sResponse As String, html As HTMLDocument, ws As Worksheet, clipboard As Object      Set ws = ThisWorkbook.Worksheets("Sheet1")      With CreateObject("MSXML2.XMLHTTP")         .Open "GET", "https://www.x-rates.com/historical/?from=CAD&amount=1&date=" & Format$  (Date - 1, "yyyy-mm-dd"), False         .setRequestHeader "If-Modified-Since", "Sat, 1 Jan 2000 00:00:00 GMT"         .send         sResponse = StrConv(.responseBody, vbUnicode)     End With      Set clipboard = GetObject("New:{1C3B4210-F441-11CE-B9EA-00AA006B1A69}")     Set html = New HTMLDocument      With html         .body.innerHTML = sResponse         clipboard.SetText .querySelectorAll(".ratesTable").item(1).outerHTML         clipboard.PutInClipboard     End With          ws.Cells(1, 1).PasteSpecial  End Sub 

Instead it would be more useful to replace this with a function with 3 arguments.

Currency From, Currency To, Historical Date

function_convert(USD,GBP,30/12/2015) 

I have searched around the internet but couldn’t find a working solution. Any help would be much appreciated.

Google Finance Historical Data Multiple Attributes?

=GOOGLEFINANCE("NSE:"&A2, "all",(TODAY()-($  N$  2)),TODAY(),"DAILY") 

The above code returns OHLC data for specified days with the date column.

What I want is only high, low and close columns.

=GOOGLEFINANCE("NSE:"&A2, ("high", "low", "close"),(TODAY()-($  N$  2)),TODAY(),"DAILY") 

This code doesn’t work.

And if use:

=GOOGLEFINANCE("NSE:"&A2, "high",(TODAY()-($  N$  2)),TODAY(),"DAILY") 

it returns high but with an added column named date.

So if I do this for all 3 (high, low, close) individually in different columns, I will get 6 columns instead of 3 (3 date columns are unnecessary for me).

I need just the high, low and close without the date column or at the most just 1 date column.

Thank you.

How to improve the user experience on a infinite record historical flow?

I’m building a SaaS product and having doubts on how to organize the user navigation regarding historical and new user records.

One of our document objects is supposed to be stored forever – it is a stock transaction record.

So, in my application menu, I have two options:

  • Remove From Stock
  • Add To Stock
  • Show Stock Transactions

Both Remove From Stock and Add To Stock will open an input page where the user will select the stock item article, description and quantity and a new record is added to database. Date/Time and type (added/removed) fields are added automatically. The latest added field is shown in screen after commit.

The Show Stock Transactions option that will show all of my transactions over time. I’ve opted to use a date filter instead of pagination, as the following example:

enter image description here

The user can select a specific date rage (Today, Yesteday, etc.) or choose to type specific dates on the FROM and TO inputs.

In practice, this approach is getting “complaints” from the following points:

a) When adding new transactions, I should be switching screens on the menu. b) Every time I add a new transaction, I have to switch to “Show Stock Transactions” to see the added record. The added record is not easily visible on screen. c) There is no clone buttons. I need to be able to clone a previous transaction, no matter how old it is.

I knindly ask for ideas on how to improve this simple use case.

Which is the better estimator for future mining intervals, the 10 minute protocol target or the observed, historical average?

The Bitcoin protocol is designed so that the network difficulty is periodically adjusted so that new blocks are mined on average every 10th minute. However, looking back the last 10 years, it appears the observed, average mining interval is 567.35 seconds. I calculated this by subtracting the timestamp of block nr. 573,795 with the timestamp of block nr. 0 and dividing by 573,794. I know block timestamps aren’t that accurate, but this error should be negligible.

Bitcoin mining can be modeled as a Poisson process with certain simplifying assumptions. If I’ve done the math right, the 95 % confidence interval of a Poisson process with λ = 1.0575 (historical average nr. blocks mined every 600 seconds) and n = 573794 (current nr. of historical block intervals) allows for an actual mining interval no higher than 568.1 seconds, an error bound which is a long way from the 600 second block interval predicted by network difficulty.

I’m aware of at least one reason why there’s a discrepancy, and that’s the 2016 block difficulty adjustment interval. This was discussed and answered in a relation question here. But is this the only reason why historical block intervals are shorter than the mathematically predicted block intervals? If we experienced a long period of consistent decline in network hash rate, would we see a similar, opposite effect, where the observed block intervals consistently exceed 600 seconds?

Bottom line question is… for block intervals in the future, is it best to assume the target block interval of 600 seconds, or an interval that is slightly lower or higher than this? If so, how much? This has implications, e.g., for designing predictive time series models in finance.

Which is the better estimator for future mining intervals, the 10 minute protocol target or the observed, historical average?

The Bitcoin protocol is designed so that the network difficulty is periodically adjusted so that new blocks are mined on average every 10th minute. However, looking back the last 10 years, it appears the observed, average mining interval is 567.35 seconds. I calculated this by subtracting the timestamp of block nr. 573,795 with the timestamp of block nr. 0 and dividing by 573,794. I know block timestamps aren’t that accurate, but this error should be negligible.

Bitcoin mining can be modeled as a Poisson process with certain simplifying assumptions. If I’ve done the math right, the 95 % confidence interval of a Poisson process with λ = 1.0575 (historical average nr. blocks mined every 600 seconds) and n = 573794 (current nr. of historical block intervals) allows for an actual mining interval no higher than 568.1 seconds, an error bound which is a long way from the 600 second block interval predicted by network difficulty.

I’m aware of at least one reason why there’s a discrepancy, and that’s the 2016 block difficulty adjustment interval. This was discussed and answered in a relation question here. But is this the only reason why historical block intervals are shorter than the mathematically predicted block intervals? If we experienced a long period of consistent decline in network hash rate, would we see a similar, opposite effect, where the observed block intervals consistently exceed 600 seconds?

Bottom line question is… for block intervals in the future, is it best to assume the target block interval of 600 seconds, or an interval that is slightly lower or higher than this? If so, how much? This has implications, e.g., for designing predictive time series models in finance.

Can anyone help me with exact dep/landing times of specific historical flight?

The flight is LHR to BKK with a stopover in Kuwait l. Flight with Kuwait Airways departing LHR on 29/12/16 at 15.35. Scheduled to arrive in BKK 21.15 30/12/16. The flight was delay d but I need to know exactly when it departed Kuwait and landed in Bangkok please?

KU0411 is flight number

Life saver if anyone could answer

Is there a way to view historical flight loads for American Airlines or other airlines?

I work for an airline and I’m able to view flight loads through a company travel portal.

What I’m looking for is historical data for American Airlines on a specific flights that flew last year. Even more public information like if the flight was sold out would be helpful.

Does anyone know of a database that keeps track of past flight information in anyway?